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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-02 : 08:22:34
|
| "Newbie" writes "We're relatively new to SQL Server. I've searched the forums as throughly as I can, and can't seem to come up with any answers to our question. Please forgive if this is a repeat...We are familiar with "Generate SQL Script..." under the 'Tools' menu in SQL Server EM. We would like to be able to generate a SQL script for our user defined functions via DTS so we could schedule this job on a periodic basis to serve as a backup. Is there any way to do this?...We are running SQL Server 2000 with Enterprise Manager 8.0, on a Windows 2003 Enterprise Edition server with Service Pack 1 installed...Thanks..." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-02 : 09:10:16
|
| Here is a script to doi it via sql. It's easy to take the dmo commands and put them into an activex task (or you could just call the sp from dts.http://www.nigelrivett.net/DMO/DMOScriptAllDatabases.htmlhttp://www.nigelrivett.net/DMO/DMOScripting.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. |
 |
|
|
|
|
|
Generating SQL Scripts via DTS