Sacha Tomey's blog

Molding the Microsoft BI Stack

Browse by Tags

All Tags » SQL Server 2000 (RSS)
Sorry, but there are no more tags available to filter with.
Scripting SQL Server 2000 Jobs
SQL Server Agent Jobs can be scripted with the following SQL DMO VB Script: Dim conServer Dim fso Dim iFile Dim oJB Dim strJob Dim strFilename Const ioModeAppend = 8 Set conServer = CreateObject("SQLDMO.SQLServer") conServer.LoginSecure = True...
Automated SQL Server 2000 Data Dictionary
The two stored procedures below will help with automating the generation and maintenance of a database data dictionary. If you provide a description for each database field in a SQL Database, these stored procedures can be used to extract that description...