Open a query analyzer windows. Also make sure that the database is not set to "master"
I did the same thing before. Could have slapped myself. -----Original Message----- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Monday, July 30, 2007 2:28 PM To: CF-Community Subject: Stupid sql server question So, I have a sql script that creates some tables. I'm using sql server management studio express. How do I run the darn sql script? I tried clicking the database engine query icon, opening the file and doing an execute, but it's not actually creating the tables, even though it says it ran. WTF? Why is it that I can do all sorts of stuff in Oracle, and this really simple thing has me baffled in sql server? *sigh* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:239251 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
