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

Articles with tag SMO Rss

Search for any content tagged smo

   Items 1 to 20 of 34    Older >>
 

Stairway to SQL PowerShell Level 7: SQL Server PowerShell and the Basics of SMO

In this level we begin our journey into the SQL Server SMO space. SMO stands for Shared Management Objects and is a library written in .NET for use with SQL Server. The SMO library is available when you install SQL Server Management Tools or you install it separately.  Read more...
By Ben Miller 2014/05/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,471 reads

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 | 6,048 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 | 408 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,607 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 | 152 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,729 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 | 494 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,998 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,777 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,306 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,504 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,303 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,838 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,182 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,422 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,466 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,351 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,097 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,316 reads

Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4

This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.  Read more...
By Additional Articles 2007/10/16 | Source: Database Journal | Category: smo
Rating: (not yet rated)  Rate this |   Briefcase | 2,295 reads
   Items 1 to 20 of 34    Older >>