Microsoft.SqlServer.Managem ...


Microsoft.SqlServer.Management.Smo Namespace

The Microsoft.SqlServer.Management.Smo namespace contains classes that represent the core SMO objects. These include instances, utility classes, enumerations, event handler types, and exception types.

The Microsoft.SqlServer.Management.Smo namespace contains the instance object classes that represent SQL Server Database Engine objects and some utility classes that represent specific tasks, such as scripting. When a connection to the instance of SQL Server has been established by using a Server object variable, objects on the instance of SQL Server can be accessed by using the SMO instance objects. For example, you can use the Database object to access databases on the connected instance of SQL Server. All the instance classes are related to the Server class in the object hierarchy. Utility classes exist outside of the Server class object hierarchy and represent specific tasks, such as backup or scripting.

The Microsoft.SqlServer.Management.Smo namespace resides in the Microsoft.SqlServer.Smo.dll file. Additionally, some of the enumeration classes are in the Microsoft.SqlServer.SqlEnum.dll and Microsoft.SqlServer.SmoEnum.dll assembly files. You will have to import all three files to access the classes in the Microsoft.SqlServer.Management.Smo namespace.

By using the Microsoft.SqlServer.Management.Smo namespace, you can do the following:

  • Connect to an instance of SQL Server.

  • View and modify SQL Server settings and configuration options.

  • View and modify SQL Server engine objects.

  • Perform DDL (data definition language) tasks on an instance of SQL Server.

  • Script databases dependencies.

  • Back up and restore databases.

  • Transfer database schemas and data.

Classes

ClassDescription
AbstractCollectionBaseThe AbstractCollectionBase object is a base class object that is used in the construction of collection objects.
ApplicationRoleThe ApplicationRole object represents a security role that is used to set access privileges from an application regardless of the user's permissions.
ApplicationRoleCollectionThe ApplicationRoleCollectionclass represents a collection of ApplicationRole objects that represent all the application roles on the referenced database.
ApplicationRoleEventsThe ApplicationRoleEvents object represents the settings required for Microsoft SQL Server application role event notification.
ArrayListCollectionBaseThe ArrayListCollectionBase object represents a base class that is used in the construction of collections that are based on array lists.
AsymmetricKeyThe AsymmetricKey object represents a SQL Server asymmetric key.
AsymmetricKeyCollectionThe AsymmetricKeyCollection class represents a collection of AsymmetricKey objects that represent all the asymmetric keys on the referenced database.
AsyncStatusThe AsyncStatus object represents the status of an asynchronous process.
AuditThe Audit object represents a SQL Server audit log.
AuditCollectionThe AuditCollection class represents a collection of Audit objects that represent all the audits on the instance of SQL Server.
AuditExtenderAdds methods and properties to the Audit object.This class is not CLS-compliant.
AuditSpecificationThe Column object represents a SQL Server column.
BackupThe Backup object provides programmatic access to Microsoft SQL Server backup operations.
BackupDeviceThe BackupDevice object provides programmatic access to SQL Server backup devices.
BackupDeviceCollectionThe BackupDeviceCollection class represents a collection of BackupDevice objects that represent all the backup devices on an instance of SQL Server.
BackupDeviceItemThe BackupDeviceItem object provides programmatic access to named SQL Server backup devices.
BackupDeviceListThe BackupDeviceList object provides programmatic access to a list backup devices. This class is not CLS-compliant.
BackupRestoreBaseThe BackupRestoreBase class is a base class that represents functionality that is common to both backup and restore operations.
CertificateThe Certificate object represents a SQL Server certificate.
CertificateCollectionThe CertificateCollection class represents a collection of Certificate objects that represent all the certificates on an instance of SQL Server.
CertificateEventsThe CertificateEvents object represents the settings that are required for SQL ServerCertificate event notification.
CheckThe Check object represents a Microsoft SQL Server check constraint.
CheckCollectionThe CheckCollection class represents a collection of Check objects that represent all the check constraints defined on the parent object.
CollectionNotAvailableExceptionThe CollectionNotAvailableException class is an exception that is raised when an attempt is made to retrieve a collection that is not available.
ColumnThe Column object represents a SQL Server column.
ColumnCollectionThe ColumnCollection class represents a collection of Column objects that represent all the columns defined on a table.
ConfigPropertyThe ConfigProperty object contains information pertaining to a Microsoft SQL Server configuration option, such as maximum, minimum, current, and new values.
ConfigPropertyCollectionThe ConfigPropertyCollection class represents a collection of ConfigProperty objects that represent all the configuration properties defined on the instance of SQL Server.
ConfigurationThe Configuration class contains the configuration information for the instance of SQL Server.
ConfigurationBaseThe ConfigurationBase class is a base class that represents configuration information for the instance of SQL Server.
CredentialThe Credential object represents a Microsoft SQL Server credential.
CredentialCollectionThe CredentialCollection class represents a collection of Credential objects that represent all the credentials defined on the instance of Microsoft SQL Server.
CryptographicProviderThe CryptographicProvider object represents a SQL Server cryptographic provider.
CryptographicProviderCollectionA collection of type CryptographicProviderCollection that represents a collection of CryptographicProviderr objects.
DatabaseThe Database object represents a SQL Server database.
DatabaseActiveDirectoryThe DatabaseActiveDirectory object provides programmatic access to the Active Directory settings for a database.
DatabaseAdapterDatabase Adapter type to be used as a management facet.
DatabaseAdapterBaseDatabase adapter base.
DatabaseAuditSpecificationThe DatabaseAuditSpecification object represents an auditable event on the database.
DatabaseAuditSpecificationCollectionThe DatabaseAuditSpecificationCollection class represents a collection of DatabaseAuditSpecification objects that represent all the audit specifications defined on the database.
DatabaseAuditSpecificationExtenderAdds methods and properties to the DatabaseAuditSpecification object.This class is not CLS-compliant.
DatabaseCollectionThe DatabaseCollection class represents a collection of Database objects that represent all the databases defined on the instance of SQL Server.
DatabaseDdlTriggerThe DatabaseDdlTrigger object represents a SQL Server database data definition language (DDL) trigger.
DatabaseDdlTriggerCollectionThe DatabaseDdlTriggerCollection class represents a collection of DatabaseDdlTrigger objects that represent all the database data definition language (DDL) triggers defined on a table.
DatabaseDdlTriggerEventThe DatabaseDdlTriggerEvent object represents the SQL Server database DDL trigger events that can be included in a database DDL trigger event set.
DatabaseDdlTriggerEventSetThe DatabaseDdlTriggerEventSet object represents a set of SQL Server database data definition language (DDL) trigger events.
DatabaseEncryptionKeyCreates a database encryption key.
DatabaseEncryptionKeyExtenderExtends the database encryption key class.This class is not CLS-compliant.
DatabaseEventThe DatabaseEvent object represents the SQL Server database events that can be included in a database event set.
DatabaseEventArgsThe DatabaseEventArgs object represents the arguments passed by the event raised by the database.
DatabaseEventsThe DatabaseEvents object represents the settings required for Microsoft SQL Server database event notification.
DatabaseEventSetThe DatabaseEventSet object represents a SQL Server set of database events.
DatabaseFileThe DatabaseFile object is a base class used in the construction of DataFile objects and LogFile objects.
DatabaseFileMappingsDictionaryThis class, which is inherited from Dictionary, maps database file paths from the source server to the corresponding target server location that the user specifies.
DatabaseMaintenanceAdapterThe Database Maintenance facet has logical properties. It inherits from the DatabaseAdapter class.
DatabaseMappingThe DatabaseMapping object represents a SQL Server database mapping.
DatabaseMirroringPayloadThe DatabaseMirroringPayload object represents database mirroring payload settings.
DatabaseOptionsThe DatabaseOptions object represents SQL Server database options.
DatabasePerformanceAdapterThe Database Performance facet implements logical properties relevant to database performance management.
DatabasePermissionThe DatabasePermission object represents a SQL Server database permission. The database permission can be added to a database permission set, and then granted, revoked, or denied to a user.
DatabasePermissionInfoThe DatabasePermissionInfo object represents information about a SQL Server database permission.
DatabasePermissionSetThe DatabasePermissionSet object represents a SQL Server set of database permissions.
DatabaseRoleThe DatabaseRole object represents a SQL Server database security role.
DatabaseRoleCollectionThe DatabaseRoleCollection class represents a collection of DatabaseRole objects that represent all the database roles defined on the parent database.
DatabaseSecurityAdapterIncludes properties and methods that are used to expose the Database Security facet.
DatabaseSnapshotExtenderAdds methods and properties to the DatabaseSnapshot object.This class is not CLS-compliant.
DataFileThe DataFile object represents a Microsoft SQL Server data file.
DataFileCollectionThe DataFileCollection class represents a collection of DataFile objects that represent all the data files defined on the parent object.
DataTypeThe DataType object represents a SQL Server data type.
DdlTriggerBaseThe DdlTriggerBase is a base class that is inherited by the DatabaseDdlTrigger object. This represents a SQL Server database data definition language (DDL) trigger.
DefaultThe Default object represents a Microsoft SQL Server default.
DefaultCollectionThe DefaultCollection class represents a collection of Default objects.
DefaultConstraintThe DefaultConstraint object represents a SQL Server default constraint.
DefaultRuleBaseThe DefaultRuleBase class is a base class that is inherited by the Rule class and the Default class.
DependencyCollectionThe DependencyCollection class represents a collection of Dependency objects that are used to derive the node classes in SMO scripting operations.
DependencyCollectionNodeThe DependencyCollectionNode class represents a node in the dependency collection that is derived during scripting operations.
DependencyNodeThe DependencyNode class represents a node that is defined by a URN address.
DependencyTreeThe DependencyTree object represents a tree structure that contains SQL Server objects and their hierarchical relationships to each other.
DependencyTreeNodeThe DependencyTreeNode class represents the child and sibling SQL Server objects within a DependencyTree object hierarchy.
DependencyWalkerThe DependencyWalker object is a tool to perform scripting operations that involve dependencies such as identifying dependent relationships. The tool and converts this output to a list.
EndpointThe Endpoint class represents an endpoint service that can listen natively for requests.
EndpointCollectionThe EndpointCollection class represents a collection of Endpoint objects that represent all the HTTP endpoints.
EndpointPayloadThe EndpointPayload object represents an endpoint payload.
EndpointProtocolThe EndpointProtocol object represents an HTTP endpoint protocol.
EventPropertyThe EventProperty class represents a property of an event.
EventPropertyCollectionThe EventPropertyCollection object represents the properties of event objects.
EventSetBaseThe EventSetBase class is a base class that is used to derive the event set objects.
ExtendedPropertyThe ExtendedProperty object represents the extended properties that are defined for any object that has an ExtendedProperties collection property.
ExtendedPropertyCollectionThe ExtendedPropertyCollection class represents a collection of ExtendedPropertyCollectionobjects that represent all the extended properties.
ExtendedStoredProcedureThe ExtendedStoredProcedure object represents an extended stored procedure on the instance of Microsoft SQL Server.
ExtendedStoredProcedureCollectionThe ExtendedStoredProcedureCollection class represents a collection of ExtendedStoredProcedure objects that represent all the extended stored procedures defined on the parent database.
FailedOperationExceptionThe FailedOperationException class represents the exception raised when an operation fails.
FileGroupThe FileGroup object represents a SQL Server file group.
FileGroupCollectionThe FileGroupCollection class represents a collection of FileGroup objects that represent all the filegroups defined on the parent database.
ForeignKeyThe ForeignKey object represents a SQL Server foreign key.
ForeignKeyCollectionThe ForeignKeyCollection class represents a collection of ForeignKey objects that represent all the foreign keys defined on the parent object.
ForeignKeyColumnThe ForeignKeyColumn object represents a SQL Server foreign key column.
ForeignKeyColumnCollectionThe ForeignKeyColumnCollection class represents a collection of ForeignKeyColumn objects that represent all the foreign key columns defined on the parent object.
FrequencyPairThe FrequencyPair object is a utility that measures frequency by storing count and duration information.
FullTextCatalogThe FullTextCatalog object represents a Microsoft Search full-text catalog.
FullTextCatalogCollectionThe FullTextCatalogCollection class represents a collection of FullTextCatalog objects that represent all the full-text catalogs defined on the parent object.
FullTextIndexThe FullTextIndex object represents a Microsoft Search full-text index.
FullTextIndexColumnThe FullTextIndexColumn object represents a Microsoft Search full-text index column.
FullTextIndexColumnCollectionThe FullTextIndexColumnCollection class represents a collection of FullTextIndexColumn objects that represent all the full-text index columns defined on the parent object.
FullTextServiceThe FullTextService object allows programmatic access to the Microsoft Search full-text settings.
FullTextStopListThe FullTextStopList object represents a full-text stop list.
FullTextStopListCollectionThe FullTextStopListCollection class represents a collection of FullTextStopList objects that represent all the full-text stop lists that are defined on the parent database.
HttpProtocolThe HttpProtocol object represents an HTTP protocol on an instance of Microsoft SQL Server.
IndexThe Index object represents a SQL Server index.
IndexCollectionThe IndexCollection class represents a collection of Index objects that represent all the indexes defined on the instance of SQL Server.
IndexedColumnThe IndexedColumn object represents a SQL Server column that is participating in an index.
IndexedColumnCollectionThe IndexedColumnCollection class represents a collection of IndexedColumn objects that represent all the indexed columns defined on the instance of SQL Server.
IndexEventsThe IndexEvents object represents the settings that are required for SQL Server index event notification.
InformationThe Information class contains nonconfigurable information about the instance of SQL Server. These include system information and options that are set during Setup, such as the collation.
InternalSmoErrorExceptionThe InternalSmoErrorException class represents the exception raised when an error occurs during the internal phase of a SMO operation.
InvalidSmoOperationExceptionThe InvalidSmoOperationException class represents the exception raised when an SMO operation is not valid.
InvalidVersionSmoOperationExceptionThe InvalidVersionSmoOperationException class represents the exception raised when the version is not valid on an SMO operation.
JobScheduleCollectionBaseThe JobScheduleCollectionBase class represents a base class that is used in the construction of the JobScheduleCollection class.
LanguageA Language object represents a language supported by SQL Server. The SQL Server language determines the date and time formats and the language in which the system messages are displayed.
LanguageCollectionThe LanguageCollection class represents a collection of Language objects that represent all the languages which are defined on the instance of SQL Server.
LinkedServerA LinkedServer object represents a database system other than SQL Server and is linked to the current instance of SQL Server by using an OLE DB driver.
LinkedServerCollectionThe LinkedServerCollection class represents a collection of LinkedServer objects that represent all the linked servers registered on the instance of SQL Server.
LinkedServerLoginThe LinkedServerLogin object represents a SQL Server logon account that has permission to connect to the linked server.
LinkedServerLoginCollectionThe LinkedServerLoginCollection class represents a collection of LinkedServerLogin objects that represent all the linked server logins defined on the linked server.
LogFileThe LogFile object represents a SQL Server log file.
LogFileCollectionThe LogFileCollection class represents a collection of LogFile objects that represent all the log files defined on the instance of Microsoft SQL Server.
LoginThe Login object represents a SQL Server login account that has been granted access to the instance of SQL Server through Windows Authentication or SQL Server Authentication.
LoginCollectionThe LoginCollection class represents a collection of Login objects that represent all the login accounts defined on the instance of SQL Server.
LoginEventsThe LoginEvents object represents the settings required for SQL Server login event notification.
MasterKeyThe MasterKey object represents a SQL Server database master key.
MessageCollectionBaseThe MessageCollectionBase class is a base class that is used in the construction of message collection classes.
MessageObjectBaseThe MessageObjectBase class is a base class that is inherited by message classes.
MissingObjectExceptionThe MissingObjectException class represents the exception raised when an object is missing.
NamedSmoObjectThe NamedSmoObject object represents a named SMO object.
NumberedObjectCollectionBaseThe NumberedObjectCollectionBase class is a base class that represents common functionality for collections of numbered objects, such as the NumberedStoredProcedure object.
NumberedStoredProcedureThe NumberedStoredProcedure class represents a Microsoft SQL Server numbered stored procedure.
NumberedStoredProcedureCollectionThe NumberedStoredProcedureCollection class represents a collection of NumberedStoredProcedure objects that represent all the numbered stored procedures defined on a table.
NumberedStoredProcedureParameterThe NumberedStoredProcedureParameter object represents a SQL Server numbered stored procedure parameter.
NumberedStoredProcedureParameterCollection 
ObjectAlteredEventArgsThe ObjectAlteredEventArgs object represents the arguments that are passed by the event that is raised when an object is altered.
ObjectCreatedEventArgsThe ObjectCreatedEventArgs object represents the arguments that are passed by the event that is raised when an object is created.
ObjectDroppedEventArgsThe ObjectDroppedEventArgs object represents the arguments that are passed by the event that is raised when an object is dropped.
ObjectEventThe ObjectEvent object represents the of SQL Server object events that can be included in an object event set.
ObjectEventSetThe ObjectEventSet object represents a SQL Server set of object events.
ObjectPermissionThe ObjectPermission object represents a SQL Server object permission.
ObjectPermissionInfoThe ObjectPermissionInfo object represents information about a SQL Server object permission.
ObjectPermissionSetThe ObjectPermissionSet object represents a set of object permissions in Microsoft SQL Server.
ObjectRenamedEventArgsThe ObjectRenamedEventArgs object represents the arguments passed by the event raised when an object is renamed.
OleDbProviderSettingsThe OleDbProviderSettings object represents the setting for a SQL Server OLE DB provider.
OleDbProviderSettingsCollectionThe OleDbProviderSettingsCollection class represents a collection of OleDbProviderSettings objects that represent all the OLE DB provider settings defined on the linked server.
OrderColumnOrderColumn points to a column with an order that is specified within a table-valued function that was created by using CREATE FUNCTION and the ORDER BY clause.
OrderColumnCollectionRepresents a collection of OrderColumn.
ParameterThe Parameter class represents a parameter. It is a base class that is inherited by the StoredProcedureParameter class and the UserDefinedFunctionParameter class and contains common features of both classes.
ParameterBaseThe ParameterBase class is a base class that is inherited by the Parameter class and the UserDefinedAggregate class. It contains common features of both classes.
ParameterCollectionBaseThe ParameterCollectionBase class is a base class that is used in the construction of parameter collection classes.
PartitionFunctionThe PartitionFunction object provides programmatic access to partition functions.
PartitionFunctionCollectionThe PartitionFunctionCollection class represents a collection of PartitionFunction objects that represent all the partition functions defined on the instance of SQL Server.
PartitionFunctionEventsThe PartitionFunctionEvents object represents the settings required for SQL Server partition function event notification.
PartitionFunctionParameterThe PartitionFunctionParameter object provides programmatic access to partition function parameters.
PartitionFunctionParameterCollectionThe PartitionFunctionParameterCollection class represents a collection of PartitionFunctionParameter objects that represent all the partition function parameters defined on the partition function.
PartitionNumberedObjectCollectionBaseThe PartitionNumberedObjectCollectionBase is a base class that is inherited by the PhysicalPartitionCollection class.
PartitionSchemeThe PartitionScheme object provides programmatic access to partition schemes.
PartitionSchemeCollectionThe PartitionSchemeCollection class represents a collection of PartitionScheme objects that represent all the partition schemes defined on the instance of SQL Server.
PartitionSchemeEventsThe PartitionSchemeEvents object represents the settings required for Microsoft SQL Server partition scheme event notification.
PartitionSchemeParameterThe PartitionSchemeParameter object provides programmatic access to partition scheme parameters.
PartitionSchemeParameterCollectionThe PartitionSchemeParameterCollection class represents a collection of PartitionSchemeParameter objects that represent all the partition scheme parameters defined on the partition scheme.
PayloadThe Payload object represents a SQL Server HTTP endpoint payload.
PercentCompleteEventArgsThe PercentCompleteEventArgs object represents the arguments passed by the event raised when a process reaches a percent complete marker.
PerformanceCountersA PerformanceCounters object represents a performance counter that is used to trace the performance of the instance of SQL Server.
PermissionInfoThe PermissionInfo class represents information regarding granted or denied privileges.
PermissionSetBaseThe PermissionSetBase class is a base class that is inherited by permission set classes.
PhysicalPartitionThe PhysicalPartition object represents the physical partition where the data and meta data is stored for a SQL Server object.
PhysicalPartitionCollectionThe PhysicalPartitionCollection class represents a collection of PhysicalPartition objects that represent all the physical partitions that are defined on an object.
PlanGuideCreates a plan guide object: PlanGuide
PlanGuideCollectionCollection of plan guide objects.
PlanGuideExtenderExtends the Property set for a Plan GuideThis class is not CLS-compliant.
ProgressReportEventArgsThe ProgressReportEventArgs object provides programmatic access to the arguments used to report the progress of an operation that works through an object hierarchy, such as discovering dependencies in scripting operations.
PropertyThe Property object provides programmatic access to the properties of all the SMO objects.
PropertyCannotBeRetrievedExceptionThe PropertyCannotBeRetrievedException class represents the exception raised when a property cannot be retrieved.
PropertyCollectionThe PropertyCollection class represents a collection of Property objects that represent all the properties defined on the parent object.
PropertyNotSetExceptionThe PropertyNotSetException class represents the exception that is raised when a property value has not been set.
PropertyReadOnlyExceptionThe PropertyReadOnlyException class represents the exception that is raised when an attempt is made to set a read-only property.
PropertyTypeMismatchExceptionThe PropertyTypeMismatchException class represents the exception raised when an attempt is made to set the property with a value that has the incorrect data type.
PropertyWriteExceptionThe PropertyWriteException class represents the exception that is raised when an error occurs when setting the value of a property.
ProtocolThe Protocol object provides programmatic access to the protocols supported by SQL Server.
RelocateFileThe RelocateFile object is a programmatic tool that lets a file be relocated.
ResourceGovernorResourceGovernor class.
ResourcePoolResource Pool Class
ResourcePoolCollectionRepresents a collection of Resource Pools.
RestoreThe Restore object provides programmatic access to restore operations.
RuleThe Rule object provides programmatic access to a SQL Server rule.
RuleCollectionThe RuleCollection class represents a collection of Rule objects that represent all the rules defined on the instance of SQL Server.
SchemaThe Schema object represents an ownership context for a SQL Server database object.
SchemaCollectionThe SchemaCollection class represents a collection of Schema objects that represent all the schemas on the referenced database.
SchemaCollectionBaseThe SchemaCollectionBase class is a base class that is inherited by the SchemaCollection class.
SchemaEventsThe SchemaEvents object represents the settings required for SQL Server schema event notification.
ScripterThe Scripter object is the overall, top-level object for managing scripting operations.
ScriptingErrorEventArgsThe ScriptingErrorEventArgs object provides programmatic access to the arguments used to report the errors that occur during scripting operations.
ScriptingOptionsThe ScriptingOptions object provides programmatic options to the options that can be set for scripting operations.
ScriptNameObjectBaseThe ScriptNameObjectBase is a base class that is inherited by classes that can use an alternative name that is used in scripting operations.
ScriptOptionThe ScriptOption object represents the SQL Server script options that can be included in scripting options that are set by using the ScriptingOptions object.
ScriptSchemaObjectBaseThe ScriptSchemaObjectBase is a base class that is inherited by classes that can use an alternative name used in scripting operations.
ServerThe Server object represents an instance of SQL Server.
ServerActiveDirectoryThe ServerActiveDirectory object provides programmatic access to the Active Directory functionality.
ServerAdapterThis class aggregates otherwise hidden server properties.
ServerAdapterBaseA ServerAdapterBase object is a base class that is used in the construction of the ServerAdapter class.
ServerAuditSpecificationThe ServerAuditSpecification object represents an auditable event on the instance of SQL Server.
ServerAuditSpecificationCollectionThe ServerAuditSpecificationCollection class represents a collection of ServerAuditSpecification objects that represent all the audit specifications defined on the server.
ServerAuditSpecificationExtenderAdds methods and properties to the ServerAuditSpecification object.This class is not CLS-compliant.
ServerConfigurationAdapter 
ServerDdlTriggerThe ServerDdlTrigger object represents a SQL Server data definition language (DDL) trigger.
ServerDdlTriggerCollectionThe ServerDdlTriggerCollection class represents a collection of ServerDdlTrigger objects that represent all the server data definition language (DDL) triggers defined on a table.
ServerDdlTriggerEventThe ServerDdlTriggerEvent object represents the of Microsoft SQL Server data definition language (DDL) trigger events that can be included in a server DDL trigger event set.
ServerDdlTriggerEventSetThe ServerDdlTriggerEventSet object represents a set of SQL Server server data definition language (DDL) trigger events.
ServerEventThe ServerEvent object represents the SQL Server server events that can be included in a server event set.
ServerEventArgsThe ServerEventArgs object provides programmatic access to the arguments that are used to report all types of events that occur on an instance of SQL Server.
ServerEventsThe ServerEvents object represents the settings required for SQL Server server-level event notification.
ServerEventSetThe ServerEventSet object represents a set of server events on an instance of SQL Server.
ServerPermissionThe ServerPermission object represents a SQL Server server-level permission.
ServerPermissionInfoThe ServerPermissionInfo object represents information about a SQL Server server-level permission.
ServerPermissionSetThe ServerPermissionSet object represents a set of server permissions.
ServerProxyAccountThe ServerProxyAccount class represents the implementation of a proxy account on an instance of SQL Server. The ProxyAccount object allows for impersonation of job step execution. Created by the system administrator, it can be further be assigned to a login or a server role or a database role and one of the subsystems, except for Transact-SQL.
ServerRoleThe ServerRole object represents a Microsoft SQL Server security role.
ServerRoleCollectionThe ServerRoleCollection class represents a collection of ServerRole objects that represent all the server roles that are defined on a table.
ServerSecurityAdapterA security facet that extends ServerAdapterBase.
ServerSetupAdapterA ServerSetupAdapter object represents a server setup adapter.
ServerSurfaceAreaAdapterA ServerSurfaceAreaAdapter object represents a server surface area adapter.
ServerTraceEventThe ServerTraceEvent object represents the SQL Server server trace events that can be included in a server trace event set.
ServerTraceEventSetThe ServerTraceEventSet object represents a set server trace events.
ServiceBrokerPayloadThe ServiceBrokerPayload object represents a SQL Server Service Broker payload.
ServiceMasterKeyThe ServiceMasterKey object represents a Microsoft SQL Server service master key.
ServiceQueueEventThe ServiceQueueEvent object represents the Service Broker service queue events that can be included in a service queue event set.
ServiceQueueEventSetThe ServiceQueueEventSet object represents a set of SQL Server service queue events.
ServiceRequestExceptionThe ServiceRequestException class represents the exception that is raised when an error occurs during a service request.
SettingsThe Settings object represents a group of configurable settings on the instance of SQL Server.
SimpleObjectCollectionBaseThe SimpleObjectCollectionBase class is a base class that is used in the construction of collection objects.
SmoApplicationThe SmoApplication class represents an SMO application with respect to event management.
SmoCollectionBaseThe SmoCollectionBase class is a base class that is used in the construction of SMO collection classes and contains members that are common to them.
SmoDmfAdapterImplements Evaluate
SmoEventArgsThe SmoEventArgs object provides programmatic access to the arguments used to report the events that occur in SMO applications.
SmoExceptionThe SmoException class represents the exception that is raised when an error occurs during an SMO operation.
SmoObjectBaseThe SmoObjectBase is a base class that is inherited by the SqlSmoObject class.
SmoObjectExtender 
SoapMethodCollectionBaseThe SoapMethodCollectionBase class is a base class that is inherited by SOAP method collection objects and provides programmatic access to the collection of SOAP methods that exist in the SOAP configuration.
SoapMethodObjectThe SoapMethodObject class provides programmatic access to the referenced SOAP method.
SoapPayloadThe SoapPayload object represents a SQL Server SOAP payload.
SoapPayloadMethodThe SoapPayloadMethod class represents a SOAP payload method for the referenced HTTP endpoint.
SoapPayloadMethodCollectionThe SoapPayloadMethodCollection class represents a collection of SoapPayloadMethod objects that represent all the SOAP payload methods defined on a table.
SortedListCollectionBaseThe SortedListCollectionBase class is a base class that is used in the construction of sorted list collection classes.
SqlAssemblyThe SqlAssembly class represents an assembly in the Microsoft .NET environment.
SqlAssemblyCollectionThe SqlAssemblyCollection class represents a collection of SqlAssembly objects that represent all the assemblies defined on a table.
SqlAssemblyEventThe SqlAssemblyEvent object represents the SQL Server assembly events that can be included in an assembly event set.
SqlAssemblyEventsThe SqlAssemblyEvents object represents the settings that are required for SQL Server assembly event notification.
SqlAssemblyEventSetThe SqlAssemblyEventSet object represents a set of assembly events.
SqlAssemblyFileThe SqlAssemblyFile object represents an assembly file that stores an assembly.
SqlAssemblyFileCollectionThe SqlAssemblyFileCollection class represents a collection of SqlAssemblyFile objects that represent all the assembly files that are defined on a table.
SqlPropertyCollectionThe SqlPropertyCollection class is an abstract class that is used in the management of object properties.
SqlPropertyInfoThe SqlPropertyInfo class is an abstract class used to store information about properties.
SqlServerRegistrationsRepresents registered instances of SQL Server.Obsolete.
SqlSmoObjectThe SqlSmoObject object represents all SQL Server objects.
StatisticThe Statistic class represents a SQL Server statistic counter.
StatisticCollectionThe StatisticCollection class represents a collection of Statistic objects that represent all the statistic counters defined on the table or view.
StatisticColumnThe StatisticColumn object represents a column defined in a SQL Server statistics counter.
StatisticColumnCollectionThe StatisticColumnCollection class represents a collection of StatisticColumn objects that represent all the statistic columns defined on a table.
StatisticEventsThe StatisticEvents object represents the settings required for SQL Server statistic counter event notification.
StoredProcedureThe StoredProcedure object represents a SQL Server stored procedure.
StoredProcedureCollectionThe StoredProcedureCollection class represents a collection of StoredProcedure objects that represent all the stored procedures that are defined on a table.
StoredProcedureEventThe StoredProcedureEvent object represents the SQL Server stored procedure events that can be included in an stored procedure event set.
StoredProcedureEventsThe StoredProcedureEvents object represents the settings that are required for SQL Server stored procedure event notification.
StoredProcedureEventSetThe StoredProcedureEventSet object represents a set of stored procedure events.
StoredProcedureParameterThe StoredProcedureParameter object represents a SQL Server stored procedure parameter.
StoredProcedureParameterCollectionThe StoredProcedureParameterCollection class represents a collection of StoredProcedureParameter objects that represent all the stored procedure parameters defined on a table.
SymmetricKeyThe SymmetricKey object represents a SQL Server symmetric key.
SymmetricKeyCollectionThe SymmetricKeyCollection class represents a collection of SymmetricKey objects that represent all the symmetric keys on the referenced database.
SymmetricKeyEncryptionThe SymmetricKeyEncryption class represents the encryption type used when encrypting symmetric keys.
SynonymThe Synonym object represents a SQL Server synonym.
SynonymCollectionThe SynonymCollection class represents a collection of Synonym objects that represent all the synonyms on the referenced database.
SynonymEventsThe SynonymEvents object represents the settings that are required for SQL Server synonym event notification.
SystemDataTypeThe SystemDataType object represents a supported system data type. The SystemDataTypeCollection represents all the supported system data types.
SystemDataTypeCollectionThe SystemDataTypeCollection class represents a collection of SystemDataType objects that represent all the system data types on the referenced database.
SystemMessageThe SystemMessage object represents messages defined by the system.
SystemMessageCollectionThe SystemMessageCollection class represents a collection of SystemMessage objects that represent all the system messages on the instance of SQL Server.
TableThe Table object represents a SQL Server table.
TableCollectionThe TableCollection class represents a collection of Table objects that represent all the tables on the referenced database.
TableEventThe TableEvent object represents the SQL Server table events that can be included in a table event set.
TableEventsThe TableEvents object represents the settings required for SQL Server table event notification.
TableEventSetThe TableEventSet object represents a set of table events.
TableViewBaseThe TableViewBase class is a base class that is used in the construction of the Table class and View class. It contains functionality that is common to both classes.
TableViewTableTypeBaseBase class for table view types.
TcpProtocolThe TcpProtocol object provides programmatic access to the protocols supported by Microsoft SQL Server.
TransferThe Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.
TriggerThe Trigger object represents a SQL Server trigger.
TriggerCollectionThe TriggerCollection class represents a collection of Trigger objects that represent all the triggers defined on a table.
TriggerEventsThe TriggerEvents object represents the settings that are required for SQL Server trigger event notification.
UnknownPropertyExceptionThe UnknownPropertyException class represents the exception that is raised when an SMO operation encounters an unknown property.
UnsupportedFeatureExceptionThe UnsupportedFeatureException class represents the exception raised when an SMO operation encounters a request for an unsupported feature.
UnsupportedObjectNameExceptionThe UnsupportedObjectNameException class represents the exception that is raised when an SMO operation encounters an unsupported object name.
UnsupportedVersionExceptionThe UnsupportedVersionException class represents the exception raised when an SMO operation encounters an unsupported version of SQL Server.
UrnCollectionThe UrnCollection class represents a collection of Urn objects that represent Uniform Resource Name (URN) addresses.
UserThe User object represents a SQL Server user.
UserCollectionThe UserCollection class represents a collection of User objects that represent all the database users defined on a database.
UserDefinedAggregateThe UserDefinedAggregate object represents a SQL Server user-defined aggregate.
UserDefinedAggregateCollectionThe UserDefinedAggregateCollection class represents a collection of UserDefinedAggregate objects that represent all the database user-defined aggregates that are defined on a database.
UserDefinedAggregateParameterThe UserDefinedAggregateParameter object represents the parameters that are used with a user-defined aggregate.
UserDefinedAggregateParameterCollectionThe UserDefinedAggregateParameterCollection class represents a collection of UserDefinedAggregateParameter objects that represent all the user-defined aggregate parameters that are defined on a table.
UserDefinedDataTypeThe UserDefinedDataType object represents a SQL Server user-defined data type.
UserDefinedDataTypeCollectionThe UserDefinedDataTypeCollection class represents a collection of UserDefinedDataType objects that represent all the user-defined data types defined on a table.
UserDefinedFunctionThe UserDefinedFunction object represents a SQL Server user-defined function.
UserDefinedFunctionCollectionThe UserDefinedFunctionCollection class represents a collection of UserDefinedFunction objects that represent all the user-defined functions that are defined on a table.
UserDefinedFunctionEventThe UserDefinedFunctionEvent object represents the SQL Server user-defined function events that can be included in a user-defined function event set.
UserDefinedFunctionEventsThe UserDefinedFunctionEvents object represents the settings that are required for SQL Server user-defined function event notification.
UserDefinedFunctionEventSetThe UserDefinedFunctionEventSet object represents a SQL Server set of user-defined function events.
UserDefinedFunctionParameterThe UserDefinedFunctionParameter object represents a SQL Server user-defined function parameter.
UserDefinedFunctionParameterCollectionThe UserDefinedFunctionParameterCollection class represents a collection of UserDefinedFunctionParameter objects that represent all the user-defined function parameters that are defined on a table.
UserDefinedMessageThe UserDefinedMessage object represents a user-defined message.
UserDefinedMessageCollectionThe UserDefinedMessageCollection class represents a collection of UserDefinedMessage objects that represent all the user-defined messages defined on a table.
UserDefinedTableTypeThe UserDefinedTableType object represents a SQL Server user-defined table type data type.
UserDefinedTableTypeCollectionThe UserDefinedTableTypeCollection class represents a collection of UserDefinedTableType objects that represent all the user-defined table types that are defined on a database.
UserDefinedTypeThe UserDefinedType represents an alias data type that is based on .NET data types.
UserDefinedTypeCollectionThe UserDefinedTypeCollection class represents a collection of UserDefinedType objects that represent all the alias data types that are defined on a table.
UserDefinedTypeEventsThe UserDefinedTypeEvents object represents the settings required for SQL Server user-defined type event notification.
UserEventsThe UserEvents object represents the settings that are required for SQL Server database user event notification.
UserOptionsThe UserOptions object represents a set configurable server options that relate specifically to users.
VerifyCompleteEventArgsThe VerifyCompleteEventArgs object provides programmatic access to the arguments used to report the details of the event that occurs when a backup verification operation completes.
ViewThe View object represents a SQL Server view.
ViewCollectionThe ViewCollection class represents a collection of View objects that represent all the views defined on a table.
ViewEventThe ViewEvent object represents the SQL Server view events that can be included in a view event set.
ViewEventsThe ViewEvents object represents the settings that are required for SQL Server view event notification.
ViewEventSetThe ViewEventSet object represents a set of view events.
WorkloadGroup 
WorkloadGroupCollectionInitializes a workload group.
WrongPropertyValueExceptionThe WrongPropertyValueException class represents the exception that is raised when a property is assigned the wrong value.
XmlSchemaCollectionThe XmlSchemaCollection object represents a collection of XML namespaces. The collection of XML namespaces behave a composite object though the namespaces can be enumerated within the collection.
XmlSchemaCollectionCollectionThe XmlSchemaCollectionCollection class represents a collection of XmlSchemaCollection objects that represent all the XML schema collections defined on a table. The XmlSchemaCollection object represents a collection of XML namespaces.
Interfaces

InterfaceDescription
IColumnPermissionThe IColumnPermission class represents the interface that manages permissions for a specified column.
IDatabaseMaintenanceFacetInterface that defined methods and properties for the database maintenance facet.This interface is not CLS-compliant.
IDatabaseOptionsInterface with properties that expose database options.This interface is not CLS-compliant.
IDatabasePerformanceFacet 
IDatabaseSecurityFacetSecurity facet interface.This interface is not CLS-compliant.
IExtendedPropertiesThe IExtendedProperties class is an interface that represents the collection of extended properties associated with an object.
ILoginOptionsThe ILoginOptions class is an interface that represents a collection of options associated with a login.This interface is not CLS-compliant.
IMultipartNameFacetInterface to deal with object names containing both the object and the schema.This interface is not CLS-compliant.
INameFacetRepresents the name facet interface.This interface is not CLS-compliant.
IObjectPermissionThe IObjectPermission class represents the interface used to set object permissions.
IScriptableThe IScriptable class represents the interface used to create Transact-SQL scripts of SMO objects.
IServerAuditFacetInterface that identifies audit facet members.This interface is not CLS-compliant.
IServerConfigurationFacetContains configuration information for the interface based on ConfigurationThis interface is not CLS-compliant.
IServerInformationAn interface based on the Information type properties.This interface is not CLS-compliant.
IServerPerformanceFacetAn interface for the performance facet.This interface is not CLS-compliant.
IServerSecurityFacetAn interface that defines members for the SeverSecurityFacet.This interface is not CLS-compliant.
IServerSettingsAn interface for SQL Server 2008 Policy-Based Management that is based on Settings.This interface is not CLS-compliant.
IServerSetupFacetRepresents the Policy-Based Management facet interface for setting up an instance of SQL Server.This interface is not CLS-compliant.
ISurfaceAreaFacetAn interface that defines surface area facet members.This interface is not CLS-compliant.
ITableOptionsThe ITableOptions class is an interface that represents a collection of options that is associated with a table.This interface is not CLS-compliant.
ITextObjectThe ITextObject class represents the interface that is used to implement text on objects.
IViewOptionsThe IViewOptions class is an interface that represents a collection of options that is associated with a view.This interface is not CLS-compliant.
Structures

StructureDescription
AuditSpecificationDetailThe AuditSpecificationDetail object represents a SQL Server audit specification detail required when creating an audit.
DdlTextParserHeaderInfoThis class supports the SMO infrastructure and is not intended to be used directly from your code.
Delegates

DelegateDescription
PercentCompleteEventHandlerThe PercentCompleteEventHandler class represents the event handler that is used to handle percent complete events.
ProgressReportEventHandlerThe ProgressReportEventHandler class represents the event handler that is used to handle progress report events.
ScriptingErrorEventHandlerThe ScriptingErrorEventHandler class represents the event handler that is used to handle scripting errors.
ScriptingFilterThis class supports the SMO infrastructure and is not intended to be used directly from your code.
ServerEventHandlerThe ServerEventHandler class represents the event handler that is used to handle server errors.
SmoApplication.AnyObjectEventHandlerThe SmoApplication.AnyObjectEventHandler class represents the event handler that is used to handle events from any object.
SmoApplication.DatabaseEventHandlerThe SmoApplication.DatabaseEventHandler class represents the event handler that handles database events.
SmoApplication.ObjectAlteredEventHandlerThe SmoApplication.ObjectAlteredEventHandler class represents the event handler that is used to handle events that occur when an object is altered.
SmoApplication.ObjectCreatedEventHandlerThe SmoApplication.ObjectCreatedEventHandler class represents the event handler that is used to handle events when an object is created.
SmoApplication.ObjectDroppedEventHandlerThe SmoApplication.ObjectDroppedEventHandler class represents the event handler that is used to handle events when an object is dropped.
SmoApplication.ObjectRenamedEventHandlerThe SmoApplication.ObjectRenamedEventHandler class represents the event handler that handles events that occur when an object is renamed.
VerifyCompleteEventHandlerThe VerifyCompleteEventHandler class represents the event handler that handles completion events.
Enumerations

EnumerationDescription
ActivationExecutionContextThe ActivationExecutionContext enumeration contains values that specify the security context used by a procedure. These procedures are activated by a service queue.
AssemblyAlterOptionsThe AssemblyAlterOptions enumeration contains values that are used to specify the addition options when altering an assembly. The values are bit flag values and they may be combined by adding the values.
AssemblySecurityLevelThe AssemblySecurityLevel enumeration contains values that are used to specify the access rights for an assembly.
AsymmetricKeyEncryptionAlgorithmThe AsymmetricKeyEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an asymmetric key.
AsymmetricKeySourceTypeThe AsymmetricKeySourceType enumeration contains values that are used to specify the source type used to load an asymmetric key.
AttachOptionsThe AttachOptions enumeration contains values that are used to specify attach options.
AuditActionTypeThe AuditActionType enumeration contains values that are used to specify the audit action types.
AuditDestinationTypeThe >AuditDestination enumeration contains values that are used to specify the destination, to which the results of a SQL Server Audit are sent.
AuditFileSizeUnitThe AuditFileSizeUnit enumeration contains values that are used to specify the unit that specifies the size of the audit file.
AuditLevelThe AuditLevel enumeration contains values that are used to specify the SQL Server audit level setting.
AuditStatusTypeThe AuditStatusType enumeration contains values that are used to specify the status of the audit.
BackupActionTypeThe BackupActionType enumeration contains values that are used to specify the type of backup.
BackupCompressionOptionsThe BackupCompressionOptions enumeration contains values that are used to specify the backup compression option.
BackupDeviceTypeThe BackupDeviceType enumeration contains values that are used to specify the backup device type.
BackupRestoreBase.AsyncOperationThe BackupRestoreBase.AsyncOperation enumeration contains values that are used to specify which backup components are running asynchronously.
BackupSetFlagThe BackupSetFlag enumeration contains values that are used to specify the purpose of the backup.
BackupSetTypeThe BackupSetType enumeration contains values that are used to specify the backup type.
BackupTruncateLogTypeThe BackupTruncateLogType enumeration contains values that are used to specify the truncate action taken on the log.
CatalogPopulationActionThe CatalogPopulationAction enumeration contains values that are used to specify the method used to populate a full-text catalog.
CatalogPopulationStatusThe CatalogPopulationStatus enumeration contains values that are used to specify the status of the full-text catalog.
CertificateSourceTypeThe CertificateSourceType enumeration contains values that are used to specify the source of the certificate.
ChangeTrackingThe ChangeTracking enumeration contains values that are used to specify change tracking in a full-text index.
CollationVersionThe CollationVersion enumeration contains values that specify the collation versions.
CompatibilityLevelThe CompatibilityLevel enumeration is a list of constant values that specify the behavior that corresponds to a version of SQL Server.
CreateDispositionTypeThe CreateDispositionType enumeration contains values that are used to specify the source of the symmetric key.
DatabaseDdlTriggerExecutionContextThe DatabaseDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the database DDL trigger runs.
DatabaseEncryptionAlgorithmSpecifies the algorithm used to encrypt the database encryption key
DatabaseEncryptionState 
DatabaseEncryptionTypeThe DatabaseEncryptionType enumeration contains values that are used to specify the encryption types.
DatabaseEventTypeThe DatabaseEventType enumeration is a list of constant values that specify the database event type.
DatabaseObjectTypesThe DatabaseObjectTypes enumeration is a list of constant values that specifies the types of database object.
DatabasePermissionSetValueThe DatabasePermissionSetValue enumeration is a list of constant values that specify all the database permissions.
DatabaseStatusThe DatabaseStatus enumeration is a list of constant values that specify the status of a database, whether it be loading, recovering, or normal, for example. This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
DatabaseUserAccessThe DatabaseUserAccess enumeration is a list of constant values that specify how user access can be restricted.
DataCompressionTypeThe DataCompressionType enumeration contains values that are used to specify the type of data compression used to store data on the physical partition.
DependencyTypeThe DependencyType enumeration is a list of constant values that specifies the direction of the dependency discovery operation.
DeviceTypeThe DeviceType enumeration is a list of constant values that specify the various different types of devices supported by SQL Server.
EditionThe Edition enumeration is a list of constant values that specify the various different types of devices that are supported by SQL Server.
EndpointAuthenticationOrderThe EndpointAuthenticationOrder enumeration contains values that are used to specify the authentication methods and order of preference for the endpoint connection.
EndpointEncryptionThe EndpointEncryption enumeration contains values that are used to specify the state of encryption on the endpoint.
EndpointEncryptionAlgorithmThe EndpointEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an endpoint.
EndpointStateThe EndpointState enumeration is a list of constant values that specifies the state of the HTTP endpoint.
EndpointTypeThe EndpointType enumeration is a list of constant values that specifies the type of HTTP endpoint.
EventTypeThe EventType enumeration is a list of constant values that specify the various different types of events that are supported by SQL Server.
ExecutionContextThe ExecutionContext enumeration is a list of constant values that specify the different types of context (or which role is assumed) when executing a process represented by an object.
ExecutionStatusThe ExecutionStatus enumeration is a list of constant values that specify the status of an executing process.
FileGrowthTypeThe FileGrowthType enumeration is a list of constant values that specify whether file growth is determined by percentage amount or by KB.
FilestreamAccessLevelTypeThe FilestreamAccessLevelType enumeration contains values that are used to specify the type of access permitted on file stream operations.
FileStreamEffectiveLevelThe FileStreamEffectiveLevel enumeration contains values that are used to specify the file stream level.
FileStreamLevelThe FileStreamLevel enumeration contains values that are used to specify the file stream level.
ForeignKeyActionThe ForeignKeyAction enumeration is a list of constant values that specify the action that is taken when the primary key reference by a foreign key is updated.
FragmentationOptionThe FragmentationOption enumeration is a list of constant values that specify the levels of detail of collected fragmentation information.
FullTextCatalogUpgradeOptionThe FullTextCatalogUpgradeOption enumeration contains values that are used to specify the action taken when the full-text catalog is upgraded.
HttpAuthenticationModesThe HttpAuthenticationModes enumeration contains values that specify the HTTP port for HTTP endpoints.
HttpPortTypesThe HttpPortTypes enumeration contains values that are used to specify the type HTTP port.
ImplementationTypeThe ImplementationType enumeration contains values that are used to specify the type of implementation for a stored procedure, a user-defined function, and other objects.
IndexEnableActionThe IndexEnableAction enumeration contains values that are used to specify the action that is taken on an index when it is enabled after having been disabled.
IndexKeyTypeThe IndexKeyType enumeration contains values that are used to specify the type of key on which the index is created.
IndexOperationThe IndexOperation enumeration contains values that are used to specify index operations.
IndexPopulationActionThe IndexPopulationAction enumeration contains values that are used to specify the type of Microsoft Search full-text index population.
IndexPopulationStatusThe IndexPopulationStatus enumeration contains values that are used to specify the type of population in progress.
InDoubtTransactionResolutionType 
KeyEncryptionTypeThe KeyEncryptionType enumeration is a list of constant values that specify the key encryption type.
LinkedTableTypeThe LinkedTableType enumeration contains values that specify the type of table accessed on a linked server.
LinkFieldTypeThe LinkFieldType enumeration contains values that specify the type of link field.
LockEscalationTypeAn enumeration that lists lock escalation types.
LockRequestStatusThe LockRequestStatus enumeration contains constant values that specify the lock request status.
LoginCreateOptionsThe LoginCreateOptions enumeration contains values that are used to specify the password options when you create a logon.
LoginTypeThe LoginType enumeration contains values that are used to specify the authentication type and the Windows account type.
LogReuseWaitStatusThe LogReuseWaitStatus enumeration contains values that specify the current operation on which the reuse of transaction log space is waiting.
MappedClassType 
MediaTypesThe MediaTypes enumeration contains values that are used to specify the type of media used to store data. This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
MethodLoginTypeThe MethodLoginType enumeration contains values that are used to specify the method used for logging on to the instance of SQL Server.
MethodXsdSchemaOptionThe MethodXsdSchemaOption enumeration contains values that specify the XSD schema returned for a SOAP method.
MirroringOptionThe MirroringOption enumeration contains values that specify the mirroring options for a database.
MirroringRoleThe MirroringRole enumeration contains values that specify the role the database plays in mirroring.
MirroringSafetyLevelThe MirroringSafetyLevel enumeration contains values that specify the safety guarantee on updates to the mirrored database.
MirroringStatusThe MirroringStatus enumeration contains values that specify the state of a database regarding mirroring.
MirroringWitnessStatusThe MirroringWitnessStatus enumeration contains values that specify the state of the mirroring witness.
MonthThe Month enumeration contains constant values that specify the twelve calendar months.
NSActivationStateThe NSActivationState enumeration contains constant values that specify the activation state of Notification Services.
ObjectClassThe ObjectClass enumeration contains values that specify the SMO class type.
ObjectPermissionSetValueThe ObjectPermissionSetValue enumeration is a list of constant values that specify all the object permissions.
OnFailureActionThe OnFailureAction enumeration contains values that specify the action to be taken when an audit fails.
PageVerifyThe PageVerify enumeration contains constant values that specify the automatic page verification options for a database.
PerfMonModeThe PerfMonMode enumeration contains values that are used to specify the polling behavior in Performance Monitor.
PermissionStateThe PermissionState enumeration contains values that specify the state of a permission.
PlanGuideType 
PrincipalTypeThe PrincipalType enumeration contains values that specify the type of user, role, or login.
PrivateKeyEncryptionTypeThe PrivateKeyEncryptionType enumeration contains values that are used to specify the encryption types for a private key associated with a certificate or an asymmetric key.
PrivilegeTypesThe PrivilegeTypes enumeration contains values that are used to specify the operations that the grantee can perform on the specified object when permission is granted.
ProtocolTypeThe ProtocolType enumeration contains values that are used to specify the type of protocol.
ProviderAuthenticationTypeSpecifies the type of authentication supported by Cryptographic Provider.
RangeTypeThe RangeType enumeration contains values that are used to specify the type range.
RecoveryModelThe RecoveryModel enumeration contains values that are used to specify the type of recovery model.
RepairOptionsThe RepairOptions enumeration contains values that are used to specify the repair options that are used when checking data in a table.
RepairStructureThe >RepairRepairStructure enumeration contains values that are used to specify the type of repair options used when checking data in a table.
RepairTypeThe RepairType enumeration contains values that are used to specify the type of repair mode used by the database consistency check (DBCC) functions.
ReplicationOptionsThe ReplicationOptions enumeration contains values that are used to specify the replication settings for the referenced database.
ResourceUsageThe ResourceUsage enumeration contains values that specify the relative operating system execution priority setting for the Microsoft Search service.
RestoreActionTypeThe RestoreActionType enumeration contains values that are used to specify the type of action that is required during a data restore operation.
RestoreTypeThe RestoreType enumeration contains values that specify the type of restore operation to perform.
ResultFormatThe ResultFormat enumeration contains values that specify the format in which to return results for an HTTP endpoint.
RetentionPeriodUnits 
RoleTypesThe RoleTypes enumeration contains values that are used to specify the type of role.
SecondaryXmlIndexTypeThe SecondaryXmlIndexType enumeration contains values that are used to specify the secondary XML index type.
ServerDdlTriggerExecutionContextThe ServerDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the server DDL trigger runs.
ServerLoginModeThe ServerLoginMode enumeration contains values that are used to specify the method used to connect to the instance of SQL Server.
ServerMirroringRoleThe ServerMirroringRole enumeration contains values that are used to specify the role of the instance of SQL Server when participating in mirroring.
ServerPermissionSetValueThe ServerPermissionSetValue enumeration is a list of constant values that specify all the database permissions.
ServerStatusThe ServerStatus enumeration contains values that are used to specify the status of the instance of SQL Server.
ServerTypeThe ServerType enumeration contains values that are used to specify whether the server is part of a multi-server administration matrix.
ServiceStartModeThe ServiceStartMode enumeration contains values that are used to specify the method that is used to start a service.
ShrinkMethodThe ShrinkMethod enumeration contains values that are used to specify the method that is used shrink a database file.
SmoExceptionTypeThe SmoExceptionType enumeration contains values that are used to specify the type of SMO exception.
SnapshotIsolationStateThe SnapshotIsolationState enumeration contains values that are used to specify the current state of snapshot isolation.
SortOrderThe SortOrder enumeration contains values that specify how objects are sorted in an enumerated list.
SpatialGeoLevelSize 
SpatialIndexType 
SqlDataTypeThe SqlDataType enumeration contains values that are used to specify a SQL Server data type.
SqlServerVersionThe SqlServerVersion enumeration contains values that are used to specify the version of the referenced instance of SQL Server.
SqlServerVersionsThe SqlServerVersions enumeration contains values that are used to specify the version of the referenced instance of SQL Server.
SqlSmoStateThe SqlSmoState enumeration contains values that are used to specify the state of an SMO object.
SqlVerifyActionThe SqlVerifyAction enumeration contains values that are used to specify the type of backup verification.
StatisticsScanTypeThe StatisticsScanType enumeration contains values that specify the ways in which statistical information is collected from tables or views during the creation or update of a statistic counter.
StatisticsTargetThe StatisticsTarget enumeration contains values that specify the type of statistic that is targeted for the update operation.
StopListOptionThe StopListOption enumeration contains values that are used to specify the way in which a new stop list is created.
SymmetricKeyEncryptionAlgorithmThe SymmetricKeyEncryptionAlgorithm enumeration contains values that specify the algorithm that is used to encrypt the symmetric key.
SymmetricKeyEncryptionTypeThe SymmetricKeyEncryptionType enumeration contains constant values that specify the type of symmetric key encryption.
SynonymBaseTypeThe SynonymBaseType enumeration contains constant values that specify the type of synonym.
TerminationClauseThe TerminationClause enumeration contains constant values that specify the action taken when transactions are terminated.
TransactionTypesThe TransactionTypes enumeration contains constant values that specify the method of recording transactions.
UrnIdOption 
UserDefinedFunctionTypeThe UserDefinedFunctionType enumeration is a list of constant values that specify the types of user-defined functions that are supported by SQL Server.
UserDefinedTypeFormatThe UserDefinedTypeFormat enumeration is a list of constant values that specify the formats used by user-defined types.
UserTypeThe UserType enumeration contains constant values that specify the security type for the user.
WindowsLoginAccessTypeThe WindowsLoginAccessType enumeration contains constant values that specify the type of access a Windows login has to the instance of SQL Server.
WorkloadGroupImportanceThe WorkloadGroupImportance enumeration contains values that specify the importance of workload groups.
WsdlGeneratorOptionThe WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.
XmlDocumentConstraintThe XmlDocumentConstraint enumeration contains constant values that specify the constraints imposed on an XML document.
XmlFormatOptionThe WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.
XmlTypeDerivationThe XmlTypeDerivation enumeration contains constant values that specify the XML type derivation.
XmlTypeKindThe XmlTypeKind enumeration contains constant values that specify the kind of XML component.
XsdSchemaOptionThe XsdSchemaOption enumeration contains constant values that specify whether an inline schema for the method result is returned in the SOAP response.
Tags :


Community Content

Thomas Lee
Classes moved to another assembly

Be aware that some classes like "Backup" and "Restore" with SQL Server 2008 is moved to the new assembly "Microsoft.SqlServer.SmoExtended".

The assembly can be loaded in a PowerShell script like this

[void][System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMOExtended')

Page view tracker