What Is SMO?
SMO is a Microsoft .NET–based object model included with the SQL Server 2008 client tools in an assembly named Microsoft.SqlServer.Smo.dll. Other supporting assemblies are typically located in the Program Files\Microsoft SQL Server\100\SDK\Assemblies folder for a 32-bit installation and in the Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies for a 64-bit installation. A handful of the SMO namespaces are shown in Table 4-1, along with their assembly if it differs from Microsoft.SqlServer.Smo.dll.
Table 4-1. Partial SMO Namespace Map
Class | Function |
---|---|
Microsoft.SqlServer.Management.Smo | The core SMO namespace, which contains instance classes, utility classes, and enumerations that are used to programmatically manipulate SQL Server ... |
Get Programming Microsoft® SQL Server™ 2008 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.