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 37    Older >>
 

Generate All Table Script By Using SMO C#

Generate Script All Table and Specific Table By Using SMO C#  Read more...
By Anuj Jain 2014/09/01 | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 755 reads

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,583 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,053 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 | 409 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 | 920 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,619 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 | 154 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,734 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 | 4,000 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,795 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,320 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,514 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,308 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,848 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,184 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 | 936 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,423 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,471 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,358 reads
   Items 1 to 20 of 37    Older >>
 
Tags
sql server 2005 (20)    
powershell (17)    
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)    
stairway series (1)