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

Articles with tag SQL-DMO Rss

Search for any content tagged sql-dmo

<< Newer    Items 21 to 34 of 34   
 

Restoring Using DMO - Getting File List and No Recovery

Following up on a question posted in our discussion area, Andy demonstrates how to backup/restore a database using DMO, how to get the list of files to be restored, and how to do a restore with no recovery. Lots of sample code!   Read more...
By Andy Warren 2002/10/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,480 reads

Adding Linked Servers Using SQL-DMO

Following up on a question posted in our discussion area, Andy looks at how to use DMO to add and remove linked servers. Along the way he points out a couple 'gotchas' and throws in a cool tip about how to save a little time when you experiment with DMO.   Read more...
By Andy Warren 2002/09/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,116 reads

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,117 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,704 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,330 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,581 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,637 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,341 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 34 of 34