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.
| Author |
Topic |
|
lici
Starting Member
11 Posts |
 Posted - 2004-08-18 : 12:14:42
|
Hi everybodyI need to generate the sql script from several data bases and i need to do this every day at nignt , is there a sp that i can run to do this??tnx  |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-08-18 : 13:10:00
|
| http://www.nigelrivett.net/DMOScriptAllDatabases.htmlhttp://www.nigelrivett.net/ScriptDTSProperties.htmlhttp://www.nigelrivett.net/SaveAllDTSPackagesToFiles.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
lici
Starting Member
11 Posts |
Posted - 2004-08-18 : 13:34:50
|
| thanks a lot nrlet me see and let me try, =) |
|
|
|
|
|
|
Store to generate SQL Script