Yes, this is exactly what I do Bushy. If you do that you will never have a problem like you have. Thanks Craig.
-----Original Message----- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 9:28 AM To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 A fair amount of people simply start table names with 'tbl', which would solve your problems. -----Original Message----- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 13 August 2003 14:28 To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 Login is a reserved word. Change the login table name to something else and it will work. Try not to use names for anything that are simple names, such as login, password, name, position, etc. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
