in

Adatis BI Blogs

Browse by Tags

  • Reminder: Support for SQL 2000 expiry date

    Not new news but a useful reminder! http://support.microsoft.com/lifecycle/?p1=2852 SQL 2000 will no longer be supported under standard support agreements after 8th April 2008 (or August 4th depending on how you read the date format!). I'm guessing there is still a lot of DTS packages out there!
    Posted to Tim Kent's blog (Weblog) by Tim Kent on 06-06-2007

  • 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 conServer.Connect "SQL2K_Server" strFilename...
    Posted to Sacha Tomey's blog (Weblog) by sachatomey on 03-16-2006

  • 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 information together with some other useful column...
    Posted to Sacha Tomey's blog (Weblog) by sachatomey on 02-17-2006
Page 1 of 1 (3 items)