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

   Items 1 to 20 of 32    Older >>
 

PowerSMO At Work Part I: DBA Scripts and Functions

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.  Read more...
By Additional Articles 2007/03/13 | Source: SimpleTalk | Category: sql-dmo
Rating:  Rate this |   Briefcase | 2,768 reads

Automating Common SQL Server Tasks using DMO

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.  Read more...
By Additional Articles 2006/12/04 | Source: Red-Gate | Category: sql-dmo
Rating:  Rate this |   Briefcase | 2,570 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,528 reads

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

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.   Read more...
By Chad Miller 2005/10/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,128 reads

Logins, Users, and Roles - Getting Started

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.   Read more...
By Andy Warren 2005/09/30 (first published: 2003/02/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,253 reads

Save Your Stored Procedures

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.   Read more...
By Andy Warren 2005/06/17 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 12,665 reads

Introduction to SQL-DMO

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.   Read more...
By Andy Warren 2005/06/10 (first published: 2003/08/15) | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 38,565 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

Dump SQL Permissions

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.   Read more...
By Chad Miller 2004/03/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,634 reads

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.   Read more...
By Andy Warren 2003/11/05 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 11,442 reads

SQL DMO Poster in PDF!

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.  Read more...
By Additional Articles 2003/10/03 | Source: SQLServerCentral.com | Category: sql-dmo
Rating:  Rate this |   Briefcase | 1,568 reads

VBScript Class to Return Backup Information

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

Introduction to SQL-DMO

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.   Read more...
By Andy Warren 2005/06/10 (first published: 2003/08/15) | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 38,565 reads

Lots of Tables and a Little DMO

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?   Read more...
By Andy Warren 2003/07/30 | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 6,994 reads

Creating a Script from a Stored Procedure

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.   Read more...
By Ryan Randall 2003/05/02 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 16,457 reads

Logins, Users, and Roles - Getting Started

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.   Read more...
By Andy Warren 2005/09/30 (first published: 2003/02/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,253 reads

Managing Jobs - Part 1

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.   Read more...
By Andy Warren 2003/01/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,434 reads

Review of Real-World SQL-DMO

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!   Read more...
By Andy Warren 2002/11/19 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 5,245 reads

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,112 reads
   Items 1 to 20 of 32    Older >>
 
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)