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 - 2002-06-18 : 09:17:05
|
| walter writes "Our group would like to find a way to schedule a job to generate sql scripts for our 6.5 databases. we have been doing this manually and would like to stop. is there any way this can be done?We are at the highest service pack for 6.5 and at NT SP6." |
|
|
dsdeming
479 Posts |
Posted - 2002-06-18 : 13:20:47
|
| It's been a while since I worked in 6.5 but I do know you could use SQLOLE ( or SQLDMO in versions 7 and up ) to force SQL objects to script themselves. SQLOLE basically exposes the entire SQL engine as an object, so you can supposedly use it to do anything you could with EM or QA. |
 |
|
|
|
|
|