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

Content with tag SMO Rss

   Items 1 to 20 of 35    Older >>
 

11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines

Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.   Read more...
By Daniel Calbimonte 2012/08/14 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 5,980 reads

Using SMO 2012 to trouble shoot support issues

SMO can be a valuable tool for working with SQL Server when you don't have access to all the tools that come with the platform. In this article, SMO helps solve an issue with a SQL Server.  Read more...
By Peter Bannister 2012/07/26 | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 406 reads

Create Normalised Databases with Powershell

Database creation with powershell SMO objects  Read more...
By Patrick Viennot 2012/07/06 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 903 reads

Automated Script-generation with Powershell and SMO

Phil Factor demonstrates how to generate T-SQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.  Read more...
By Additional Articles 2012/02/28 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,549 reads

Little Love Lost for SMO

SMO is a very useful way of automating a wide range of routine database jobs, but Phil Factor laments Microsoft's apparent ambivalence towards the technology, including a lack of anything remotely resembling adequate documentation.  Read more...
By Phil Factor 2011/11/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 144 reads

Configuring Database Mail with Powershell and SMO

Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.  Read more...
By Bruce Kastner 2011/08/15 | Source: SQLServerCentral.com | Category: database mail
Rating: |  Discuss |   Briefcase | 2,694 reads

Is Microsoft neglecting SMO?

Phil Fator, the self-confessed wild man of T-SQL, finally comes clean: he's a secret PowerShell user. But for the DBA, what is PowerShell without SMO? Is Microsoft giving the latter the care and attention it needs?  Read more...
By Phil Factor 2011/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 491 reads

Moving Indexes with Powershell and SMO

Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.  Read more...
By Zach Mattson 2010/09/30 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 3,980 reads

SSIS Package to Script All SQL Server Jobs to Individual Files

The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.  Read more...
Rating: |  Discuss |   Briefcase | 9,608 reads

The T-SQL Hammer

The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...  Read more...
By Chad Miller 2010/02/23 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 3,245 reads

Transfer database schema objects and data to another server/database with SMO

In this tip, I am going to show you how you can use SMO (SQL Server Management Objects) classes to transfer database objects and data to another server or database.  Read more...
By Additional Articles 2010/01/06 | Source: MSSQLTips.com | Category: smo
Rating: (not yet rated)  Rate this |   Briefcase | 3,444 reads

Getting started with SQL Server Management Objects (SMO)

In this tip, I am going to discuss how you can get started with SMO and how you can programmatically manage a SQL Server instance with your choice of programming language.   Read more...
By Additional Articles 2009/09/04 | Source: MSSQLTips.com | Category: smo
Rating:  Rate this |   Briefcase | 3,268 reads

Using PowerShell with SQL Server Management Objects (SMO)

I want to know how Windows PowerShell can help me as a SQL Server DBA.  Read more...
By Additional Articles 2009/05/18 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,762 reads

Using SQL Management Objects to create and restore SQL Databases.

SQL Management Objects(SMO)can be used for customized automation of various database.This article gives an implementation for SMO using C#.  Read more...
By Amriteshwar Singh 2008/06/18 | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 5,181 reads

Powershell/SMO: Unload table schema, dri, perms & data.

PSH script to unload table schema, dri, permissions and data to file(s).  Read more...
By Gordon-265412 2008/06/10 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 932 reads

Backing Up a Database with SMO

In SQL Server 2005, the management object framework changed substantially from the DMO framework in prior verisons. Now we have SMO, RMO, and other .NET assemblies that can be used to manage SQL Server. New author Brandie Tarvin brings us a short look at how SMO can be used to perform one of those critical tasks in SQL Server.   Read more...
By Brandie Tarvin 2007/03/13 | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 6,416 reads

SQL Server Management Objects: Lessons from the Wild

Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.  Read more...
By Additional Articles 2007/11/13 | Source: DevX | Category: smo
Rating: (not yet rated)  Rate this |   Briefcase | 2,439 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 9

Learn how to use PowerShell in conjunction with SMO to Generate an SQL Server Script.  Read more...
By Additional Articles 2007/10/26 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,321 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 8

This installment illustrates how to use PowerShell in conjunction with SMO to display object properties of all SQL Server Objects.  Read more...
By Additional Articles 2007/10/23 | Category: smo
Rating: (not yet rated)  Rate this |   Briefcase | 2,064 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 7

This installment of the series illustrates how to use PowerShell in conjunction with SMO to display SQL Server Objects.  Read more...
By Additional Articles 2007/10/19 | Source: Database Journal | Category: smo
Rating: (not yet rated)  Rate this |   Briefcase | 2,286 reads
   Items 1 to 20 of 35    Older >>
 
Tags
sql server 2005 (20)    
powershell (16)    
administration (2)    
editorial (2)    
backup (1)    
backup / restore (1)    
blogs (1)    
creation (1)    
database (1)    
database mail (1)    
database weekly (1)    
indexing (1)    
integration services (ssis) (1)    
jobs (1)    
programming (1)    
script (1)    
simple-talk series (1)    
sql agent (1)    
sql server 2000 (1)    
sql server 2008 (1)    
sqlcmd (1)    
sql-dmo (1)