More Ideas About Using SQL-DMO
This article by Andy Warren introduces some additional SQL-DMO methods that are very useful when automating administrative tasks.
2003-11-05
11,520 reads
You rated this post out of 5. Change rating
This article by Andy Warren introduces some additional SQL-DMO methods that are very useful when automating administrative tasks.
2003-11-05
11,520 reads
The second article in a 3 part series that presents another VBScript class file that creates a class that can be used to display the backup information from a SQL server's maintanence plans.
2003-08-28
6,819 reads
This article by Andy warren shows you how to get started with DMO using either VB or VBScript. The article includes sample code that will backup all databases on a server and will update the statistics on all databases as well.
2007-10-02 (first published: 2003-08-15)
38,976 reads
Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.
2005-09-30 (first published: 2003-02-19)
37,396 reads
A VBscript class is created that can be used to query the maintenance plans on an SQL server to determine when a backup has occurred. This class can be used with others to create a scripted method for monitoring backups.
2002-08-22
6,319 reads