http://www.sqlservercentral.com/Content tagged SMO posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)SQL Management Objects(SMO)can be used for customized automation of various database.This article gives an implementation for SMO using C#.http://www.sqlservercentral.com/articles/SMO/63126/2008/06/18http://www.sqlservercentral.com/articles/SMO/63126/PSH script to unload table schema, dri, permissions and data to file(s).http://www.sqlservercentral.com/scripts/powershell/63040/2008/06/10http://www.sqlservercentral.com/scripts/powershell/63040/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. http://www.sqlservercentral.com/articles/SMO/2900/2008/03/05http://www.sqlservercentral.com/articles/SMO/2900/Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.http://www.sqlservercentral.com/redirect/articles/61416/2007/11/13http://www.sqlservercentral.com/redirect/articles/61416/Learn how to use PowerShell in conjunction with SMO to Generate an SQL Server Script.http://www.sqlservercentral.com/redirect/articles/61264/2007/10/26http://www.sqlservercentral.com/redirect/articles/61264/This installment illustrates how to use PowerShell in conjunction with SMO to display object properties of all SQL Server Objects.http://www.sqlservercentral.com/redirect/articles/61189/2007/10/23http://www.sqlservercentral.com/redirect/articles/61189/This installment of the series illustrates how to use PowerShell in conjunction with SMO to display SQL Server Objects.http://www.sqlservercentral.com/redirect/articles/61190/2007/10/19http://www.sqlservercentral.com/redirect/articles/61190/This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.http://www.sqlservercentral.com/redirect/articles/61191/2007/10/16http://www.sqlservercentral.com/redirect/articles/61191/Part 3 of this series illustrates how to script PowerShell cmdlets and execute them. Scripting is essential for automation and executing repetitive tasks.http://www.sqlservercentral.com/redirect/articles/61192/2007/10/08http://www.sqlservercentral.com/redirect/articles/61192/Part II of this series discusses more about PowerShell and its features in conjunction with SMO. http://www.sqlservercentral.com/redirect/articles/61193/2007/10/05http://www.sqlservercentral.com/redirect/articles/61193/As you probably know, Windows PowerShell is the new command shell and scripting language that provides a command line environment for interactive exploration and administration of computers. In addition, it provides an opportunity to script these commands so that we can schedule and run these scripts multiple times.http://www.sqlservercentral.com/redirect/articles/61194/2007/10/04http://www.sqlservercentral.com/redirect/articles/61194/Part 6 of "Microsoft Windows PowerShell and SQL Server 2005 SMO" illustrates how to use PowerShell and PowerShell script to backup databases.http://www.sqlservercentral.com/redirect/articles/3189/2007/09/05http://www.sqlservercentral.com/redirect/articles/3189/Part 5 of "Microsoft Windows PowerShell and SQL Server 2005 SMO" illustrates how to use PowerShell and PowerShell script to create databases.http://www.sqlservercentral.com/redirect/articles/3159/2007/08/22http://www.sqlservercentral.com/redirect/articles/3159/Part 3 of this series discussed how to script PowerShell and connect to SQL Server. This installment illustrates how to use a PowerShell script to loop through the content of a file and connect to different servers.http://www.sqlservercentral.com/redirect/articles/3110/2007/07/24http://www.sqlservercentral.com/redirect/articles/3110/A good article on using SMO in SQL Server 2005.http://www.sqlservercentral.com/redirect/articles/3074/2007/07/18http://www.sqlservercentral.com/redirect/articles/3074/In this column, I discuss how SMO can be used to examine a database’s objects and to perform a variety of administrative tasks. http://www.sqlservercentral.com/redirect/articles/3029/2007/06/18http://www.sqlservercentral.com/redirect/articles/3029/Allen White provides an SMO script for automating database log backups, using either native backup or Red Gate's SQL Backup tool.http://www.sqlservercentral.com/redirect/articles/2980/2007/05/07http://www.sqlservercentral.com/redirect/articles/2980/Dan Sullivan continues his exploration of the versatile PowerSMO tool with coverage of how to control logins, monitor server activity and create standalone administrative scripts.http://www.sqlservercentral.com/redirect/articles/2939/2007/04/02http://www.sqlservercentral.com/redirect/articles/2939/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.http://www.sqlservercentral.com/redirect/articles/2884/2007/03/13http://www.sqlservercentral.com/redirect/articles/2884/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. http://www.sqlservercentral.com/articles/SMO/2900/2008/03/05http://www.sqlservercentral.com/articles/SMO/2900/SQL Server guru Andy Warren has been working with all aspects of SQL Server for many years and is slowly upgrading his skills to SQL Server 2005. Here he takes a look at SMO basics, which is the replacement for DMO. http://www.sqlservercentral.com/articles/SMO/smobasics/2468/2006/06/28http://www.sqlservercentral.com/articles/SMO/smobasics/2468/One of the big changes with SQL Server 2005 is the evolution of SQL-DMO to the new SMO managed code assemblies. Author Raj Vasant brings us quite a bit of code to show how this can be used to script your objects. http://www.sqlservercentral.com/articles/SMO/scriptdatabaseobjectswithsmo/2342/2006/04/04http://www.sqlservercentral.com/articles/SMO/scriptdatabaseobjectswithsmo/2342/