SQLServerCentral.com Articles tagged SQL-DMO

Potential Issue with Re-Naming Stored Procedures

Thu, 07 Oct 2010 06:00:00 UT

In this article Mohammad Meimandi explains an issue faced while using SQL-DMO to copy database objects.

Automate the Publishing of Data Changes into DML Scripts

Mon, 02 Nov 2009 07:00:00 UT

For those of you still using SQL Server 2000, learn how to use SQL-DMO to create DML scripts to deploy new records or data changes to other servers. From Oscar Garcia.

PowerSMO At Work Part I: DBA Scripts and Functions

Tue, 13 Mar 2007 06:00:00 UT

Dan Sullivan delves deeper into PowerSMO, the versatile command line utility for managing SQL Server databases. Using a certificate strategy, he provides a step-by-step guide to creating and deploying secure, signed DBA scripts. He then describes how to use PowerSMO functions to manage the extended properties of SQL Server objects.

Automating Common SQL Server Tasks using DMO

Mon, 04 Dec 2006 07:00:00 UT

The article's intention is to show how easy it is to use DMO (and its successor, SMO) from within SQL Server, and how any COM object that does not rely on events can be used.

Using DMO to Restore a Database

Fri, 16 Jun 2006 06:00:00 UT

This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Use SQL-DMO and Excel to Quickly Create Reports for Auditors

Tue, 04 Oct 2005 06:00:00 UT

Auditing SQL Server, or any system, is not an easy task and with new regulations like Sarbanes-Oxley, it is becoming a full time job in some environments. Chad Miller brings us a way that he developed with Excel and some scripting to automate some of the security information for a large installation of SQL Servers.

Logins, Users, and Roles - Getting Started

Fri, 30 Sep 2005 06:00:00 UT

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.

Save Your Stored Procedures

Fri, 17 Jun 2005 06:00:00 UT

Version control of stored procedures is not exactly a SQL Server 2000 strong point. In fact, it is downright abysmal and there have been lots of ideas and solutions put forth to solve the problem. Andy Warren brings us a new one that's small and lightweight and may help you after getting inspired at TechEd 2005.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Introduction to SQL-DMO

Fri, 10 Jun 2005 06:00:00 UT

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.

Using DMO to Enable and Disable Triggers

Thu, 12 Aug 2004 06:00:00 UT

This short article shows you how to use SQL-DMO to enable or disable all the triggers in a database.

Dump SQL Permissions

Wed, 17 Mar 2004 06:00:00 UT

We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO.

More Ideas About Using SQL-DMO

Wed, 05 Nov 2003 07:00:00 UT

This article by Andy Warren introduces some additional SQL-DMO methods that are very useful when automating administrative tasks.

SQL DMO Poster in PDF!

Fri, 03 Oct 2003 06:00:00 UT

Last year we did a project with Lumigent to create a DMO poster. Part of the agreement allows us to now distribute the PDF version to our readers. It's about a 400k file, print size is 24x36. We hope you DMO users will find it useful.

VBScript Class to Return Backup Information

Thu, 28 Aug 2003 06:00:00 UT

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.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Introduction to SQL-DMO

Fri, 10 Jun 2005 06:00:00 UT

Lots of Tables and a Little DMO

Wed, 30 Jul 2003 06:00:00 UT

Andy discusses a recent thread where a reader has very slow login tables with 2000 tables. After writing some DMO code (very handy by the way) and creating some objects, he can't track it down. Have any ideas?

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Creating a Script from a Stored Procedure

Fri, 02 May 2003 06:00:00 UT

Ryan demonstrates how he arrived at a solution that allows you to create scripts from a stored procedure using SQL-DMO. If you get interested in DMO, we've got quite a bit of additional content here on the site to help you get going! Ryan is a new author here on the site, please take a minute to read his article, add a comment, maybe just say hello.

Logins, Users, and Roles - Getting Started

Fri, 30 Sep 2005 06:00:00 UT

Managing Jobs - Part 1

Fri, 31 Jan 2003 07:00:00 UT

How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control.

Review of Real-World SQL-DMO

Tue, 19 Nov 2002 07:00:00 UT

Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book!

Restoring Using DMO - Getting File List and No Recovery

Tue, 15 Oct 2002 06:00:00 UT

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!

Adding Linked Servers Using SQL-DMO

Thu, 19 Sep 2002 06:00:00 UT

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.

SQL-DMO - Using the '2' Objects

Mon, 02 Sep 2002 06:00:00 UT

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.

SQL-DMO for Beginners

Thu, 29 Aug 2002 06:00:00 UT

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.

VBScript Classes to Query SQL Server for Backup Information

Thu, 22 Aug 2002 06:00:00 UT

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.

SQL Server DMO Resources

Mon, 29 Apr 2002 06:00:00 UT

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.

Adding a Column using SQL_DMO

Thu, 14 Feb 2002 07:00:00 UT

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!

Review of SQL Comparison and Synchronization Toolkit

Wed, 16 Jan 2002 07:00:00 UT

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.

Automate Writing Stored Procedures

Mon, 25 Jun 2001 06:00:00 UT

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!

Executing Multiple Scripts in a Folder using the ScriptRunner Utility

Thu, 14 Jun 2001 06:00:00 UT

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.