2007-07-18
2,936 reads
2007-07-18
2,936 reads
In this column, I discuss how SMO can be used to examine a database’s objects and to perform a variety of administrative tasks.
2007-06-18
2,930 reads
Allen White provides an SMO script for automating database log backups, using either native backup or Red Gate's SQL Backup tool.
2007-05-07
2,426 reads
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.
2007-04-02
2,261 reads
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.
2008-03-05 (first published: 2007-03-13)
6,634 reads
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.
2006-06-28
10,335 reads
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.
2006-04-04
16,365 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers