shove this code at the top of your SP: SET QUOTED_IDENTIFIER OFF
What happens? -----Original Message----- From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] Sent: 04 November 2002 13:23 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Robertson-Ravo, Neil (REC) wrote: > your table really should not be 50 fields in size.... I think a > normalisation could be implemented.. before you reach the SQL Server > limit on row size. We are doing an exercise of the mind on a fictitious database schema here (right Philip?). As such, it is quite easy to come up with something that has 50 fields and is perfectly normalized. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com