15. SQL Server Management Objects
Introduction
SQL Server Management Objects, known as SMO, is an object model for SQL Server and its configuration settings. SMO-based applications use .NET Framework languages to program against this in-memory object model rather than sending Transact-SQL (T-SQL) commands to SQL Server to do so. SMO makes it very straightforward to create applications that manage SQL Server because it encapsulates specific knowledge of each version of SQL Server and T-SQL in its object model.
SMO also provides some capabilities for managing other SQL Server applications, such as Analysis Services, Notification Services, and Reporting Services, but this chapter focuses on SQL Server itself—that is, the database engine, and specifically ...
Get A Developer’s Guide to SQL Server 2005 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
