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,665 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,382 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,448 reads
By Steve Jones
tangency– n. a fleeting glimpse of what might have been. I tend to live...
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...
I'm struggling setting relationships among tables. I understand the one-to-many, many-to-one, many-to-many, and self-referential...
Hi All, need help with an SQL query. We have an existing table that's...
I connect to this clustered instance and run : begin distributed transaction Msg 8501,...
What is the output of this code in SQL Server 2022?
select bit_count(0xEF)See possible answers