Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 how to generate script using sql query

Author  Topic 

DURGESH
Posting Yak Master

105 Posts

Posted - 2008-11-19 : 03:49:50
hi all,

I need to generate the Scripts through SQL server query analyzer,
that's I need script, that script I need to use in front end application to generate script every 15 days without logging into SQL Server Enterprise Manager and SQL server.
2. When I generate the scripts I need to generate Single script for each table with table name as file name, I need to do for Tables, Functions, Views and Stored Procedures, all single files.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-19 : 04:44:37
See http://weblogs.sqlteam.com/peterl/archive/2008/10/24/How-to-script-out-all-your-objects-one-per-file.aspx


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -