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)
 sql server 6.5

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.

Go to Top of Page
   

- Advertisement -