I am trying to put together a little package to throw up to this list. Something that you guys can look at and let us know whether we are on the right track or way off base (concerning all of the performance questions we have been having lately, we wanted to make sure that we are at least doing things the "right way").
Anyways, I am trying to script the database (SQL Server 2000) and its now allowing me to create a table named "User". I can do this in Enterprise Manager just fine, but doing it via a CREATE TABLE in Query Analyzer it fails. I know why it fails, because "User" is a reserved word. (So its lame that Ent. Mgr. lets me but QA doesnt. Thats lame!) So how I can properly script it then? I tried playing with using "Quoted Identifiers" and it works, but it actually creates a table called "User" (quotes and all), and that is just plain wrong. So how can I do this? How are other people working with the very popular table name "User"? I know this is kind of off-topic but it is related to me getting a package thrown together for this and in addition I am sure a ton of you are using this table name (is the trick to to name your table something else and just use "alias=" in the Reactor XML? Thanks /Cody Cody Caughlan [EMAIL PROTECTED] Senior Engineer / Developer Jabico Enterprises, LLC 831.454.0850 ext 18. (Office) 831.454.0847 (Fax) This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error or if you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail, or numbers listed above, if you have received this e-mail by mistake and immediately delete this e-mail and all file attachments from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
