Open a connection to the db server, select the database, click New Query, paste the sql script into the query window and click Execute.
You might need to make sure to commit your changes if you are using a transaction. Care to post your script? Just a thought. On 7/30/07, Deanna Schneider <[EMAIL PROTECTED]> wrote: > > 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:239259 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
