Last post Jun 04, 2007 03:44 AM by jdm2104
Jun 03, 2007 10:56 AM|jdm2104|LINK
Could you tell me what the usual way is for executing the sql scripts in the App_Data folder?
I have created two new MS SQL databases on my webserver but can't figure out how to run the scripts for adding and configuring the tables. The Classifieds site works fine locally.
Thanks for you help.
Jun 03, 2007 12:05 PM|vivek_iit|LINK
You can simply run those scripts manually in the
1. Query Analyzer (Sql Server 2000)
2. If using SQL Server 2005, copy paste the query in the Management Studio New Query window and run it against your database.
Also, you can use the Server Explorer in the Visual Studio to execute those queries from VS itself.
Jun 04, 2007 03:44 AM|jdm2104|LINK
Thank you for your reply. It was very helpful!