SMO

SQLServerCentral Article

Backing Up a Database with SMO

  • Article

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.

4.75 (4)

You rated this post out of 5. Change rating

2008-03-05 (first published: )

6,665 reads

SQLServerCentral Article

SMO Basics

  • Article

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.

You rated this post out of 5. Change rating

2006-06-28

10,382 reads

Blogs

A New Word: Tangency

By

tangency– n.  a fleeting glimpse of what might have been. I tend to live...

Join me at the Microsoft Fabric Community Conference with a discount code

By

I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...

Is Your Business Truly Ready for AI?

By

The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...

Read the latest Blogs

Forums

Several Questions: Relationships and SSMS and Data Diagrams

By Ahr Aitch

I'm struggling setting relationships among tables.  I understand the one-to-many, many-to-one, many-to-many, and self-referential...

Query Help to show record in single row

By sqldba20

Hi All, need help with an SQL query. We have an existing table that's...

MSDTC not available on Windows 2022 clustered SQL 2019 CU30

By Johan Bijnens

I connect to this clustered instance and run : begin distributed transaction Msg 8501,...

Visit the forum

Question of the Day

Counting Bits III

What is the output of this code in SQL Server 2022?

select bit_count(0xEF)

See possible answers