Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Programming, SQL-DMO Rss

<< Newer    Items 21 to 32 of 32   
 

SQL-DMO - Using the '2' Objects

In this short article Andy talks about the differences in DMO between SQL7 and SQL2K, why it matters, and when you should use the newer version of DMO that comes with SQL2K.   Read more...
By Andy Warren 2002/09/02 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 5,724 reads

SQL-DMO for Beginners

How many of you are VB programmers? How many of you have never worked with DMO? This is the article if you don't work with VB or DMO, but want to get started. One of the more powerful tools that you can add to your arsenal.   Read more...
By Steve Jones 2002/08/29 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 12,609 reads

VBScript Classes to Query SQL Server for Backup Information

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.   Read more...
By Bruce Szabo 2002/08/22 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 6,115 reads

SQL Server DMO Resources

As I work with a particular topic or problem, I often research on the Internet different opinions, white papers, etc. Here is a list of resources that are located both on SQL Server Central and other sites that I have found useful.   Read more...
By Steve Jones 2002/04/29 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 6,244 reads

Adding a Column using SQL_DMO

One of our readers needed some help with altering a table with DMO, so Andy has a code sample and some comments in general about how to add objects using DMO. It's good code and a very quick introduction to how objects work. Worth reading!   Read more...
By Andy Warren 2002/02/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,703 reads

Review of SQL Comparison and Synchronization Toolkit

This week Andy takes a look at a new product from Red-Gate that gives you even more options than you get with their SQL Compare and SQL Data Compare tools - now you can build your own. Add the features you always wanted. Build automated processes instead of using the GUI. It's an interesting product - read the review and then maybe even enter the contest to win a free copy.   Read more...
By Andy Warren 2002/01/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,361 reads

Automate Writing Stored Procedures

This article by David Rabb from the June 2001 issue of VBPJ shows you how to build a tool that will build a select, insert, update, and delete stored procedure for each table in a database. It's a great example of how to use DMO and a great tool as well!   Read more...
By Additional Articles 2001/06/25 | Source: DevX | Category: stored procedures
Rating:  Rate this |   Briefcase | 2,323 reads

Executing Multiple Scripts in a Folder using the ScriptRunner Utility

Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.   Read more...
By Andy Warren 2001/06/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,579 reads

Using DMO to Execute a Job

Using DMO to execute a job is a powerful technique that is easy to apply. This article by Andy Warren has all the code you need to do it!   Read more...
By Andy Warren 2001/05/22 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 5,186 reads

Using DMO to Enable and Disable Triggers

This short article shows you how to use SQL-DMO to enable or disable all the triggers in a database.   Read more...
By Andy Warren 2004/08/12 (first published: 2001/05/18) | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 7,635 reads

Minimizing the Number of Log Backups

This article by Andy Warren outlines two ways you can reduce the number of log backups you do. Includes sample DMO code.   Read more...
By Andy Warren 2001/05/11 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 4,340 reads

Using DMO to Restore a Database

This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.   Read more...
By Andy Warren 2006/06/16 (first published: 2001/05/07) | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 24,529 reads
<< Newer    Items 21 to 32 of 32   
 
Tags
sql server 7 (12)    
administration (8)    
miscellaneous (6)    
t-sql (6)    
visual basic 6 (6)    
backup / restore (4)    
configuring (4)    
stored procedures (4)    
strategies (4)    
ado (2)    
disaster recovery (dr) (2)    
replication (2)    
security (2)    
.net (1)    
database design (1)    
distributed queries (1)    
monitoring (1)    
naming standards (1)    
smo (1)    
sql server 2005 (1)    
sql server 6.5 (1)