Microsoft.SqlServer.Management.Smo Namespace

  • Article

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.

Updated text:17 July 2006

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.

Release

History

17 July 2006

 Changed content:

  • Added introductory text.

Classes

Class Description
AbstractCollectionBase The AbstractCollectionBase object is a base class object used in the construction of collection objects.
ApplicationRole The ApplicationRole object represents a security role that is used to set access privileges from an application regardless of the user's permissions.
ApplicationRoleCollection The ApplicationRoleCollectionclass represents a collection of ApplicationRole objects that represent all the application roles on the referenced database.
ApplicationRoleEvents The ApplicationRoleEvents object represents the settings required for Microsoft SQL Server application role event notification.
ArrayListCollectionBase The ArrayListCollectionBase object represents a base class that is used in the construction of collections that are based on array lists.
AsymmetricKey The AsymmetricKey object represents a SQL Server asymmetric key.
AsymmetricKeyCollection The AsymmetricKeyCollection class represents a collection of AsymmetricKey objects that represent all the asymmetric keys on the referenced database.
AsyncStatus The AsyncStatus object represents the status of an asynchronous process.
Backup The Backup object provides programmatic access to Microsoft SQL Server backup operations.
BackupDevice The BackupDevice object provides programmatic access to SQL Server backup devices.
BackupDeviceCollection The BackupDeviceCollection class represents a collection of BackupDevice objects that represent all the backup devices on an instance of Microsoft SQL Server.
BackupDeviceItem The BackupDeviceItem object provides programmatic access to named SQL Server backup devices.
BackupDeviceList The BackupDeviceList object provides programmatic access to a list backup devices. This class is not CLS-compliant.
BackupRestoreBase The BackupRestoreBase class is a base class that represents functionality that is common to both backup and restore operations.
Certificate The Certificate object represents a SQL Server certificate.
CertificateCollection The CertificateCollection class represents a collection of Certificate objects that represent all the certificates on an instance of SQL Server.
CertificateEvents The CertificateEvents object represents the settings required for Microsoft SQL ServerCertificate event notification.
Check The Check object represents a Microsoft SQL Server check constraint.
CheckCollection The CheckCollection class represents a collection of Check objects that represent all the check constraints defined on the parent object.
CollectionNotAvailableException The CollectionNotAvailableException class is an exception that is raised when an attempt is made to retrieve a collection that is not available.
Column The Column object represents a Microsoft SQL Server column.
ColumnCollection The ColumnCollection class represents a collection of Column objects that represent all the columns defined on a table.
ConfigProperty The ConfigProperty object contains information pertaining to a Microsoft SQL Server configuration option, such as maximum, minimum, current, and new values.
ConfigPropertyCollection The ConfigPropertyCollection class represents a collection of ConfigProperty objects that represent all the configuration properties defined on the instance of Microsoft SQL Server.
Configuration The Configuration class contains the configuration information for the instance of Microsoft SQL Server.
ConfigurationBase The ConfigurationBase class is a base class that represents configuration information for the instance of Microsoft SQL Server.
Credential The Credential object represents a Microsoft SQL Server credential.
CredentialCollection The CredentialCollection class represents a collection of Credential objects that represent all the credentials defined on the instance of Microsoft SQL Server.
Database The Database object represents a Microsoft SQL Server database.
DatabaseActiveDirectory The DatabaseActiveDirectory object provides programmatic access to the Active Directory settings for a database.
DatabaseCollection The DatabaseCollection class represents a collection of Database objects that represent all the databases defined on the instance of Microsoft SQL Server.
DatabaseDdlTrigger The DatabaseDdlTrigger object represents a Microsoft SQL Server database data definition language (DDL) trigger.
DatabaseDdlTriggerCollection The DatabaseDdlTriggerCollection class represents a collection of DatabaseDdlTrigger objects that represent all the database data definition language (DDL) triggers defined on a table.
DatabaseDdlTriggerEvent The DatabaseDdlTriggerEvent object represents the of Microsoft SQL Server database data definition language (DDL) trigger events that can be included in a database DDL trigger event set.
DatabaseDdlTriggerEventSet The DatabaseDdlTriggerEventSet object represents a set of Microsoft SQL Server database data definition language (DDL) trigger events.
DatabaseEvent The DatabaseEvent object represents the Microsoft SQL Server database events that can be included in a database event set.
DatabaseEventArgs The DatabaseEventArgs object represents the arguments passed by the event raised by the database.
DatabaseEvents The DatabaseEvents object represents the settings required for Microsoft SQL Server database event notification.
DatabaseEventSet The DatabaseEventSet object represents a Microsoft SQL Server set of database events.
DatabaseFile The DatabaseFile object is a base class used in the construction of DataFile objects and LogFile objects.
DatabaseMapping The DatabaseMapping object represents a Microsoft SQL Server database mapping.
DatabaseMirroringPayload The DatabaseMirroringPayload object represents database mirroring payload settings.
DatabaseOptions The DatabaseOptions object represents a Microsoft SQL Server database options.
DatabasePermission The DatabasePermission object represents a Microsoft SQL Server database permission. The database permission can be added to a database permission set, and then granted, revoked, or denied to a user.
DatabasePermissionInfo The DatabasePermissionInfo object represents information about a Microsoft SQL Server database permission.
DatabasePermissionSet The DatabasePermissionSet object represents a Microsoft SQL Server set of database permissions.
DatabaseRole The DatabaseRole object represents a Microsoft SQL Server database security role.
DatabaseRoleCollection The DatabaseRoleCollection class represents a collection of DatabaseRole objects that represent all the database roles defined on the parent database.
DataFile The DataFile object represents a Microsoft SQL Server data file.
DataFileCollection The DataFileCollection class represents a collection of DataFile objects that represent all the data files defined on the parent object.
DataType The DataType object represents a Microsoft SQL Server data type.
DdlTriggerBase The DdlTriggerBase is a base class that is inherited by the DatabaseDdlTrigger object, which represents a Microsoft SQL Server database data definition language (DDL) trigger.
Default The Default object represents a Microsoft SQL Server default.
DefaultCollection The DefaultCollection class represents a collection of Default objects.
DefaultConstraint The DefaultConstraint object represents a Microsoft SQL Server default constraint.
DefaultRuleBase The DefaultRuleBase class is a base class that is inherited by the Rule class and the Default class.
Dependency The Dependency class is a base class that is used to derive the node classes in SQL Server Management Objects (SMO) scripting classes.
DependencyChainCollection The DependencyChainCollection class represents a collection of Dependency objects used in dependency discovery operations.
DependencyCollection The DependencyCollection class represents a collection of Dependency objects that are used to derive the node classes in SQL Server Management Objects (SMO) scripting operations.
DependencyCollectionNode The DependencyCollectionNode class represents a node in the dependency collection that is derived during scripting operations.
DependencyNode The DependencyNode class represents a node that is defined by a URN address.
DependencyTree The DependencyTree object represents a tree structure that contains Microsoft SQL server objects and their hierarchical relationships to each other.
DependencyTreeNode The DependencyTreeNode class represents the child and sibling Microsoft SQL Server objects within a DependencyTree object hierarchy.
DependencyWalker The DependencyWalker object is a tool for performing scripting operations that involve dependencies such as identifying dependent relationships and converting this output to a list.
Endpoint The Endpoint class represents an endpoint service that can listen natively for requests.
EndpointCollection The EndpointCollection class represents a collection of Endpoint objects that represent all the HTTP endpoints.
EndpointPayload The EndpointPayload object represents an endpoint payload.
EndpointProtocol The EndpointProtocol object represents an HTTP endpoint protocol.
EnumeratorException The EnumeratorException class represents the exception raised when an error occurs during enumeration operations.
EventProperty The EventProperty class represents a property of an event.
EventPropertyCollection The EventPropertyCollection object represents the properties of event objects.
EventSetBase The EventSetBase class is a base class that is used to derive the event set objects.
ExtendedProperty The ExtendedProperty object represents the extended properties that are defined for any object that has an ExtendedProperties collection property.
ExtendedPropertyCollection The ExtendedPropertyCollection class represents a collection of ExtendedPropertyCollectionobjects that represent all the extended properties.
ExtendedStoredProcedure The ExtendedStoredProcedure object represents an extended stored procedure on the instance of Microsoft SQL Server.
ExtendedStoredProcedureCollection The ExtendedStoredProcedureCollection class represents a collection of ExtendedStoredProcedure objects that represent all the extended stored procedures defined on the parent database.
FailedOperationException The FailedOperationException class represents the exception raised when an operation fails.
FileGroup The FileGroup object represents a Microsoft SQL Server file group.
FileGroupCollection The FileGroupCollection class represents a collection of FileGroup objects that represent all the filegroups defined on the parent database.
FilterNode This class supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
ForeignKey The ForeignKey object represents a Microsoft SQL Server foreign key.
ForeignKeyCollection The ForeignKeyCollection class represents a collection of ForeignKey objects that represent all the foreign keys defined on the parent object.
ForeignKeyColumn The ForeignKeyColumn object represents a Microsoft SQL Server foreign key column.
ForeignKeyColumnCollection The ForeignKeyColumnCollection class represents a collection of ForeignKeyColumn objects that represent all the foreign key columns defined on the parent object.
FullTextCatalog The FullTextCatalog object represents a MicrosoftSearch full-text catalog.
FullTextCatalogCollection The FullTextCatalogCollection class represents a collection of FullTextCatalog objects that represent all the full-text catalogs defined on the parent object.
FullTextIndex The FullTextIndex object represents a Microsoft Search full-text index.
FullTextIndexColumn The FullTextIndexColumn object represents a Microsoft Search full-text index column.
FullTextIndexColumnCollection The FullTextIndexColumnCollection class represents a collection of FullTextIndexColumn objects that represent all the full-text index columns defined on the parent object.
FullTextService The FullTextService object allows programmatic access to the Microsoft Search full-text settings.
HttpProtocol The HttpProtocol object represents an HTTP protocol on an instance of Microsoft SQL Server.
Index The Index object represents a Microsoft SQL Server index.
IndexCollection The IndexCollection class represents a collection of Index objects that represent all the indexes defined on the instance of Microsoft SQL Server.
IndexedColumn The IndexedColumn object represents a Microsoft SQL Server column that is participating in an index.
IndexedColumnCollection The IndexedColumnCollection class represents a collection of IndexedColumn objects that represent all the indexed columns defined on the instance of Microsoft SQL Server.
IndexEvents The IndexEvents object represents the settings required for Microsoft SQL Server index event notification.
Information The Information class contains nonconfigurable information about the instance of Microsoft SQL Server. These include system information and options that are set during setup, such as the collation.
InternalEnumeratorException The InternalEnumeratorException class represents the exception raised when a error occurs during the internal phase of an enumeration operation.
InternalSmoErrorException The InternalSmoErrorException class represents the exception raised when an error occurs during the internal phase of a SQL Server Management Objects (SMO) operation.
InvalidConfigurationFileEnumeratorException The InvalidConfigurationFileEnumeratorException class represents the exception raised when a configuration file that is not valid is encountered.
InvalidPropertyUsageEnumeratorException The InvalidPropertyUsageEnumeratorException class represents the exception raised when an object property is accessed incorrectly.
InvalidQueryExpressionEnumeratorException The InvalidQueryExpressionEnumeratorException class represents the exception raised when a query expression that is not valid is encountered.
InvalidSmoOperationException The InvalidSmoOperationException class represents the exception raised when a SQL Server Management Objects (SMO) operation is not valid.
InvalidVersionEnumeratorException The InvalidVersionEnumeratorException class represents the exception raised when the version is not valid.
InvalidVersionSmoOperationException The InvalidVersionSmoOperationException class represents the exception raised when the version is not valid on a SQL Server Management Objects (SMO) operation.
JobScheduleCollectionBase The JobScheduleCollectionBase class represents a base class used in the construction of the JobScheduleCollection class.
Language A Language object represents a language supported by Microsoft SQL Server. The SQL Server language determines the date and time formats and the language in which the system messages are displayed.
LanguageCollection The LanguageCollection class represents a collection of Language objects that represent all the languages defined on the instance of Microsoft SQL Server.
LinkedServer A LinkedServer object represents a database system other than Microsoft SQL Server and is linked to the current instance of SQL Server using an OLE DB driver.
LinkedServerCollection The LinkedServerCollection class represents a collection of LinkedServer objects that represent all the linked servers registered on the instance of Microsoft SQL Server.
LinkedServerLogin The LinkedServerLogin object represents a Microsoft SQL Server logon account that has permission to connect to the linked server.
LinkedServerLoginCollection The LinkedServerLoginCollection class represents a collection of LinkedServerLogin objects that represent all the linked server logins defined on the linked server.
LogFile The LogFile object represents a Microsoft SQL Server log file.
LogFileCollection The LogFileCollection class represents a collection of LogFile objects that represent all the log files defined on the instance of Microsoft SQL Server.
Login The Login object represents a Microsoft SQL Server login account that has been granted access to the instance of SQL Server through Microsoft Windows Authentication or SQL Server Authentication.
LoginCollection The LoginCollection class represents a collection of Login objects that represent all the login accounts defined on the instance of Microsoft SQL Server.
LoginEvents The LoginEvents object represents the settings required for Microsoft SQL Server login event notification.
MasterKey The MasterKey object represents a SQL Server database master key.
MessageCollectionBase The MessageCollectionBase class is a base class that is used in the construction of message collection classes.
MessageObjectBase The MessageObjectBase class is a base class that is inherited by message classes.
MissingObjectException The MissingObjectException class represents the exception raised when an object is missing.
NamedSmoObject The NamedSmoObject object represents a named Microsoft SQL Server Management Objects (SMO) object.
NotYetImplementedEnumeratorException This class supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
NumberedObjectCollectionBase The NumberedObjectCollectionBase class is a base class that represents common functionality for collections of numbered objects, such as the NumberedStoredProcedure object.
NumberedStoredProcedure The NumberedStoredProcedure class represents a Microsoft SQL Server numbered stored procedure.
NumberedStoredProcedureCollection The NumberedStoredProcedureCollection class represents a collection of NumberedStoredProcedure objects that represent all the numbered stored procedures defined on a table.
NumberedStoredProcedureParameter The NumberedStoredProcedureParameter object represents a Microsoft SQL Server numbered stored procedure parameter.
NumberedStoredProcedureParameterCollection The NumberedStoredProcedureParameterCollection class represents a collection of NumberedStoredProcedureParameter objects that represent all the numbered stored procedure parameters defined on a table.
ObjectAlteredEventArgs The ObjectAlteredEventArgs object represents the arguments passed by the event raised when an object is altered.
ObjectCreatedEventArgs The ObjectCreatedEventArgs object represents the arguments passed by the event raised when an object is created.
ObjectDroppedEventArgs The ObjectDroppedEventArgs object represents the arguments passed by the event raised when an object is dropped.
ObjectEvent The ObjectEvent object represents the of Microsoft SQL Server object events that can be included in an object event set.
ObjectEventSet The ObjectEventSet object represents a Microsoft SQL Server set of object events.
ObjectPermission The ObjectPermission object represents a Microsoft SQL Server object permission.
ObjectPermissionInfo The ObjectPermissionInfo object represents information about a Microsoft SQL Server object permission.
ObjectPermissionSet The ObjectPermissionSet object represents a set of object permissions in Microsoft SQL Server.
ObjectProperty The ObjectProperty object specifies attributes of SQL Server Management Objects (SMO) object properties.
ObjectRenamedEventArgs The ObjectRenamedEventArgs object represents the arguments passed by the event raised when an object is renamed.
OleDbProviderSettings The OleDbProviderSettings object represents the setting for a Microsoft SQL Server OLE DB provider.
OleDbProviderSettingsCollection The OleDbProviderSettingsCollection class represents a collection of OleDbProviderSettings objects that represent all the OLE DB provider settings defined on the linked server.
OrderBy This class supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
Parameter The 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.
ParameterBase The ParameterBase class is a base class that is inherited by the Parameter class and the UserDefinedAggregate class and contains common features of both classes.
ParameterCollectionBase The ParameterCollectionBase class is a base class that is used in the construction of parameter collection classes.
PartitionFunction The PartitionFunction object provides programmatic access to partition functions.
PartitionFunctionCollection The PartitionFunctionCollection class represents a collection of PartitionFunction objects that represent all the partition functions defined on the instance of Microsoft SQL Server.
PartitionFunctionEvents The PartitionFunctionEvents object represents the settings required for Microsoft SQL Server partition function event notification.
PartitionFunctionParameter The PartitionFunctionParameter object provides programmatic access to partition function parameters.
PartitionFunctionParameterCollection The PartitionFunctionParameterCollection class represents a collection of PartitionFunctionParameter objects that represent all the partition function parameters defined on the partition function.
PartitionScheme The PartitionScheme object provides programmatic access to partition schemes.
PartitionSchemeCollection The PartitionSchemeCollection class represents a collection of PartitionScheme objects that represent all the partition schemes defined on the instance of Microsoft SQL Server.
PartitionSchemeEvents The PartitionSchemeEvents object represents the settings required for Microsoft SQL Server partition scheme event notification.
PartitionSchemeParameter The PartitionSchemeParameter object provides programmatic access to partition scheme parameters.
PartitionSchemeParameterCollection The PartitionSchemeParameterCollection class represents a collection of PartitionSchemeParameter objects that represent all the partition scheme parameters defined on the partition scheme.
Payload The Payload object represents a Microsoft SQL Server HTTP endpoint payload.
PercentCompleteEventArgs The PercentCompleteEventArgs object represents the arguments passed by the event raised when a process reaches a percent complete marker.
PermissionInfo The PermissionInfo class represents information regarding granted or denied privileges.
PermissionSetBase The PermissionSetBase class is a base class that is inherited by permission set classes.
ProgressReportEventArgs The 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.
Property The Property object provides programmatic access to the properties of all the SMO objects.
PropertyCannotBeRetrievedException The PropertyCannotBeRetrievedException class represents the exception raised when a property cannot be retrieved.
PropertyCollection The PropertyCollection class represents a collection of Property objects that represent all the properties defined on the parent object.
PropertyNotSetException The PropertyNotSetException class represents the exception raised when a property value has not been set.
PropertyReadOnlyException The PropertyReadOnlyException class represents the exception raised when an attempt is made to set a read-only property.
PropertyTypeMismatchException The PropertyTypeMismatchException class represents the exception raised when an attempt is made to set the property with a value that has the incorrect data type.
PropertyWriteException The PropertyWriteException class represents the exception raised when an error occurs when setting the value of a property.
Protocol The Protocol object provides programmatic access to the protocols supported by Microsoft SQL Server.
QueryNotSupportedEnumeratorException The QueryNotSupportedEnumeratorException class represents the exception raised when an attempt is made to request an enumerator query that is not supported.
RelocateFile The RelocateFile object is a programmatic tool that allows a file to be relocated.
Restore The Restore object provides programmatic access to restore operations.
Rule The Rule object provides programmatic access to a Microsoft SQL Server rule.
RuleCollection The RuleCollection class represents a collection of Rule objects that represent all the rules defined on the instance of Microsoft SQL Server.
Schema The Schema object represents an ownership context for a Microsoft SQL Server database object.
SchemaCollection The SchemaCollection class represents a collection of Schema objects that represent all the schemas on the referenced database.
SchemaCollectionBase The SchemaCollectionBase class is a base class that is inherited by the SchemaCollection class.
SchemaEvents The SchemaEvents object represents the settings required for Microsoft SQL Server schema event notification.
Scripter The Scripter object is the overall, top-level object for managing scripting operations.
ScriptingErrorEventArgs The ScriptingErrorEventArgs object provides programmatic access to the arguments used to report the errors that occur during scripting operations.
ScriptingOptions The ScriptingOptions object provides programmatic options to the options that can be set for scripting operations.
ScriptNameObjectBase The ScriptNameObjectBase is a base class that is inherited by classes that have the ability to use an alternative name used in scripting operations.
ScriptOption The ScriptOption object represents the Microsoft SQL Server script options that can be included in a scripting options set using the ScriptingOptions object.
ScriptSchemaObjectBase The ScriptSchemaObjectBase is a base class that is inherited by classes that have the ability to use an alternative name used in scripting operations.
Server The Server object represents an instance of Microsoft SQL Server.
ServerActiveDirectory The ServerActiveDirectory object provides programmatic access to the Active Directory functionality.
ServerDdlTrigger The ServerDdlTrigger object represents a Microsoft SQL Server data definition language (DDL) trigger.
ServerDdlTriggerCollection The ServerDdlTriggerCollection class represents a collection of ServerDdlTrigger objects that represent all the server data definition language (DDL) triggers defined on a table.
ServerDdlTriggerEvent The 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.
ServerDdlTriggerEventSet The ServerDdlTriggerEventSet object represents a set of Microsoft SQL Server server data definition language (DDL) trigger events.
ServerEvent The ServerEvent object represents the Microsoft SQL Server server events that can be included in a server event set.
ServerEventArgs The ServerEventArgs object provides programmatic access to the arguments used to report all types of events that occur on an instance of Microsoft SQL Server.
ServerEvents The ServerEvents object represents the settings required for Microsoft SQL Server server-level event notification.
ServerEventSet The ServerEventSet object represents a set of server events on an instance of Microsoft SQL Server.
ServerPermission The ServerPermission object represents a Microsoft SQL Server server-level permission.
ServerPermissionInfo The ServerPermissionInfo object represents information about a Microsoft SQL Server server-level permission.
ServerPermissionSet The ServerPermissionSet object represents a set of server permissions.
ServerProxyAccount The ServerProxyAccount class represents the implementation of a proxy account on an instance of Microsoft 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.
ServerRole The ServerRole object represents a Microsoft SQL Server security role.
ServerRoleCollection The ServerRoleCollection class represents a collection of ServerRole objects that represent all the server roles defined on a table.
ServerTraceEvent The ServerTraceEvent object represents the Microsoft SQL Server server trace events that can be included in a server trace event set.
ServerTraceEventSet The ServerTraceEventSet object represents a set server trace events.
ServiceBrokerPayload The ServiceBrokerPayload object represents a SQL Server Service Broker payload.
ServiceMasterKey The ServiceMasterKey object represents a Microsoft SQL Server service master key.
ServiceQueueEvent The ServiceQueueEvent object represents the Service Broker service queue events that can be included in a service queue event set.
ServiceQueueEventSet The ServiceQueueEventSet object represents a set of Microsoft SQL Server service queue events.
ServiceRequestException The ServiceRequestException class represents the exception raised when an error occurs during a service request.
Settings The Settings object represents a group of configurable settings on the instance of Microsoft SQL Server.
SimpleObjectCollectionBase The SimpleObjectCollectionBase class is a base class that is used in the construction of collection objects.
SmoApplication The SmoApplication class represents a Microsoft SQL Server Management Objects (SMO) application with respect to event management.
SmoApplication.SqlServerRegistrations The SmoApplication.SqlServerRegistrations class represents servers registered with an SmoApplication object.
SmoCollectionBase The SmoCollectionBase class is a base class that is used in the construction of SQL Server Management Objects (SMO) collection classes and contains members that are common to them.
SmoEventArgs The SmoEventArgs object provides programmatic access to the arguments used to report the events that occur in SQL Server Management Objects (SMO) applications.
SmoException The SmoException class represents the exception raised when an error occurs during a SQL Server Management Objects (SMO) operation.
SmoObjectBase The SmoObjectBase is a base class that is inherited by the SqlSmoObject class.
SoapMethodCollectionBase The 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.
SoapMethodObject The SoapMethodObject class provides programmatic access to the referenced SOAP method.
SoapPayload The SoapPayload object represents a Microsoft SQL Server SOAP payload.
SoapPayloadMethod The SoapPayloadMethod class represents a SOAP payload method for the referenced HTTP endpoint.
SoapPayloadMethodCollection The SoapPayloadMethodCollection class represents a collection of SoapPayloadMethod objects that represent all the SOAP payload methods defined on a table.
SortedListCollectionBase The SortedListCollectionBase class is a base class that is used in the construction of sorted list collection classes.
SqlAssembly The SqlAssembly class represents an assembly in the Microsoft .NET environment.
SqlAssemblyCollection The SqlAssemblyCollection class represents a collection of SqlAssembly objects that represent all the assemblies defined on a table.
SqlAssemblyEvent The SqlAssemblyEvent object represents the Microsoft SQL Server assembly events that can be included in an assembly event set.
SqlAssemblyEvents The SqlAssemblyEvents object represents the settings required for Microsoft SQL Server assembly event notification.
SqlAssemblyEventSet The SqlAssemblyEventSet object represents a set of assembly events.
SqlAssemblyFile The SqlAssemblyFile object represents an assembly file that stores an assembly.
SqlAssemblyFileCollection The SqlAssemblyFileCollection class represents a collection of SqlAssemblyFile objects that represent all the assembly files defined on a table.
SqlPropertyCollection The SqlPropertyCollection class is an abstract class used in the management of object properties.
SqlPropertyInfo The SqlPropertyInfo class is an abstract class used to store information about properties.
SqlSmoObject The SqlSmoObject object represents all Microsoft SQL Server objects.
Statistic The Statistic class represents a Microsoft SQL Server statistic counter.
StatisticCollection The StatisticCollection class represents a collection of Statistic objects that represent all the statistic counters defined on the table or view.
StatisticColumn The StatisticColumn object represents a column defined in a Microsoft SQL Server statistics counter.
StatisticColumnCollection The StatisticColumnCollection class represents a collection of StatisticColumn objects that represent all the statistic columns defined on a table.
StatisticEvents The StatisticEvents object represents the settings required for Microsoft SQL Server statistic counter event notification.
StoredProcedure The StoredProcedure object represents a Microsoft SQL Server stored procedure.
StoredProcedureCollection The StoredProcedureCollection class represents a collection of StoredProcedure objects that represent all the stored procedures defined on a table.
StoredProcedureEvent The StoredProcedureEvent object represents the Microsoft SQL Server stored procedure events that can be included in an stored procedure event set.
StoredProcedureEvents The StoredProcedureEvents object represents the settings required for Microsoft SQL Server stored procedure event notification.
StoredProcedureEventSet The StoredProcedureEventSet object represents a set of stored procedure events.
StoredProcedureParameter The StoredProcedureParameter object represents a Microsoft SQL Server stored procedure parameter.
StoredProcedureParameterCollection The StoredProcedureParameterCollection class represents a collection of StoredProcedureParameter objects that represent all the stored procedure parameters defined on a table.
SymmetricKey The SymmetricKey object represents a Microsoft SQL Server symmetric key.
SymmetricKeyCollection The SymmetricKeyCollection class represents a collection of SymmetricKey objects that represent all the symmetric keys on the referenced database.
SymmetricKeyEncryption The SymmetricKeyEncryption class represents the encryption type used when encrypting symmetric keys.
Synonym The Synonym object represents a Microsoft SQL Server synonym.
SynonymCollection The SynonymCollection class represents a collection of Synonym objects that represent all the synonyms on the referenced database.
SynonymEvents The SynonymEvents object represents the settings required for Microsoft SQL Server™ synonym event notification.
SystemDataType The SystemDataType object represents a supported system data type. The SystemDataTypeCollection represents all the supported system data types.
SystemDataTypeCollection The SystemDataTypeCollection class represents a collection of SystemDataType objects that represent all the system data types on the referenced database.
SystemMessage The SystemMessage object represents messages defined by the system.
SystemMessageCollection The SystemMessageCollection class represents a collection of SystemMessage objects that represent all the system messages on the instance of Microsoft SQL Server.
Table The Table object represents a Microsoft SQL Server table.
TableCollection The TableCollection class represents a collection of Table objects that represent all the tables on the referenced database.
TableEvent The TableEvent object represents the Microsoft SQL Server table events that can be included in a table event set.
TableEvents The TableEvents object represents the settings required for Microsoft SQL Server table event notification.
TableEventSet The TableEventSet object represents a set of table events.
TableViewBase The TableViewBase class is a base class used in the construction of the Table class and View class and therefore contains functionality that is common to both classes.
TcpProtocol The TcpProtocol object provides programmatic access to the protocols supported by Microsoft SQL Server.
Transfer The Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of Microsoft SQL Server.
Trigger The Trigger object represents a Microsoft SQL Server trigger.
TriggerCollection The TriggerCollection class represents a collection of Trigger objects that represent all the triggers defined on a table.
TriggerEvents The TriggerEvents object represents the settings required for Microsoft SQL Server trigger event notification.
UnknownPropertyEnumeratorException The UnknownPropertyEnumeratorException class represents the exception raised when a SQL Server Management Objects (SMO) operation encounters an unknown property enumerator.
UnknownPropertyException The UnknownPropertyException class represents the exception raised when a SQL Server Management Objects (SMO) operation encounters an unknown property.
UnknownTypeEnumeratorException The UnknownTypeEnumeratorException class represents the exception raised when a SQL Server Management Objects (SMO) operation encounters an unknown type enumerator.
UnsupportedFeatureException The UnsupportedFeatureException class represents the exception raised when a SQL Server Management Objects (SMO) operation encounters a request for an unsupported feature.
UnsupportedObjectNameException The UnsupportedObjectNameException class represents the exception raised when an SMO operation encounters an unsupported object name.
UnsupportedVersionException The UnsupportedVersionException class represents the exception raised when a SQL Server Management Objects (SMO) operation encounters an unsupported version of Microsoft SQL Server.
Urn The Urn object provides programmatic access to Uniform Resource Name (URN) addresses that uniquely identify Microsoft SQL Server objects.
UrnCollection The UrnCollection class represents a collection of Urn objects that represent Uniform Resource Name (URN) addresses.
User The User object represents a Microsoft SQL Server user.
UserCollection The UserCollection class represents a collection of User objects that represent all the database users defined on a database.
UserDefinedAggregate The UserDefinedAggregate object represents a Microsoft SQL Server user-defined aggregate.
UserDefinedAggregateCollection The UserDefinedAggregateCollection class represents a collection of UserDefinedAggregate objects that represent all the database user-defined aggregates defined on a database.
UserDefinedAggregateParameter The UserDefinedAggregateParameter object represents the parameters used with a user-defined aggregate.
UserDefinedAggregateParameterCollection The UserDefinedAggregateParameterCollection class represents a collection of UserDefinedAggregateParameter objects that represent all the user-defined aggregate parameters defined on a table.
UserDefinedDataType The UserDefinedDataType object represents a Microsoft SQL Server user-defined data type data type.
UserDefinedDataTypeCollection The UserDefinedDataTypeCollection class represents a collection of UserDefinedDataType objects that represent all the user-defined data types defined on a table.
UserDefinedFunction The UserDefinedFunction object represents a Microsoft SQL Server user-defined function.
UserDefinedFunctionCollection The UserDefinedFunctionCollection class represents a collection of UserDefinedFunction objects that represent all the user-defined functions defined on a table.
UserDefinedFunctionEvent The UserDefinedFunctionEvent object represents the Microsoft SQL Server user-defined function events that can be included in a user-defined function event set.
UserDefinedFunctionEvents The UserDefinedFunctionEvents object represents the settings required for Microsoft SQL Server user-defined function event notification.
UserDefinedFunctionEventSet The UserDefinedFunctionEventSet object represents a Microsoft SQL Server a set of user-defined function events.
UserDefinedFunctionParameter The UserDefinedFunctionParameter object represents a Microsoft SQL Server user-defined function parameter.
UserDefinedFunctionParameterCollection The UserDefinedFunctionParameterCollection class represents a collection of UserDefinedFunctionParameter objects that represent all the user-defined function parameters defined on a table.
UserDefinedMessage The UserDefinedMessage object represents a user-defined message.
UserDefinedMessageCollection The UserDefinedMessageCollection class represents a collection of UserDefinedMessage objects that represent all the user-defined messages defined on a table.
UserDefinedType The UserDefinedType is represents a alias data type that is based on .NET data types.
UserDefinedTypeCollection The UserDefinedTypeCollection class represents a collection of UserDefinedType objects that represent all the alias data types defined on a table.
UserDefinedTypeEvents The UserDefinedTypeEvents object represents the settings required for Microsoft SQL Server user-defined type event notification.
UserEvents The UserEvents object represents the settings required for Microsoft SQL Server database user event notification.
UserOptions The UserOptions object represents a set configurable server options that relate specifically to users.
VerifyCompleteEventArgs The VerifyCompleteEventArgs object provides programmatic access to the arguments used to report the details of the event that occurs when a backup verification operation completes.
View The View object represents a Microsoft SQL Server view.
ViewCollection The ViewCollection class represents a collection of View objects that represent all the views defined on a table.
ViewEvent The ViewEvent object represents the Microsoft SQL Server view events that can be included in a view event set.
ViewEvents The ViewEvents object represents the settings required for Microsoft SQL Server view event notification.
ViewEventSet The ViewEventSet object represents a set of view events.
WrongPropertyValueException The WrongPropertyValueException class represents the exception raised when a property is assigned the wrong value.
XmlSchemaCollection The 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.
XmlSchemaCollectionCollection The 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.
XmlUtility This class supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
XPathException The XPathException class represents the exception raised when a SQL Server Management Objects (SMO) operation encounters an error while handling an Xpath expression.
XPathExpression  
XPathExpressionBlock The XpathExpressionBlock object represents an Xpath expression block.

Interfaces

Interface Description
IColumnPermission The IColumnPermission class represents the interface that manages permissions for a specified column.
IExtendedProperties The IExtendedProperties class is an interface that represents the collection of extended properties associated with an object.
IObjectPermission The IObjectPermission class represents the interface used to set object permissions.
IScriptable The IScriptable class represents the interface used to create Transact-SQL scripts of SQL Server Management Objects (SMO) objects.
ITextObject The ITextObject class represents the interface that is used to implement text on objects.

Structures

Structure Description
DdlTextParserHeaderInfo This class supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.

Delegates

Delegate Description
PercentCompleteEventHandler The PercentCompleteEventHandler class represents the event handler that is used to handle percent complete events.
ProgressReportEventHandler The ProgressReportEventHandler class represents the event handler that is used to handle progress report events.
ScriptingErrorEventHandler The ScriptingErrorEventHandler class represents the event handler that is used to handle scripting errors.
ScriptingFilter This class supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
ServerEventHandler The ServerEventHandler class represents the event handler that is used to handle server errors.
SmoApplication.AnyObjectEventHandler The SmoApplication.AnyObjectEventHandler class represents the event handler that is used to handle events from any object.
SmoApplication.DatabaseEventHandler The SmoApplication.DatabaseEventHandler class represents the event handler that is used to handle database events.
SmoApplication.ObjectAlteredEventHandler The SmoApplication.ObjectAlteredEventHandler class represents the event handler that is used to handle events that occur when an object is altered.
SmoApplication.ObjectCreatedEventHandler The SmoApplication.ObjectCreatedEventHandler class represents the event handler that is used to handle events when an object is created.
SmoApplication.ObjectDroppedEventHandler The SmoApplication.ObjectDroppedEventHandler class represents the event handler that is used to handle events when an object is dropped.
SmoApplication.ObjectRenamedEventHandler The SmoApplication.ObjectRenamedEventHandler class represents the event handler that is used to handle events that occur when an object is renamed.
VerifyCompleteEventHandler The VerifyCompleteEventHandler class represents the event handler that is used to handle completion events.

Enumerations

Enumeration Description
ActivationExecutionContext The ActivationExecutionContext enumeration contains values that are used to specify the security context used by a procedure activated by a service queue.
AssemblyAlterOptions The 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.
AssemblySecurityLevel The AssemblySecurityLevel enumeration contains values that are used to specify the access rights for an assembly.
AsymmetricKeyEncryptionAlgorithm The AsymmetricKeyEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an asymmetric key.
AsymmetricKeySourceType The AsymmetricKeySourceType enumeration contains values that are used to specify the source type used to load an asymmetric key.
AttachOptions The AttachOptions enumeration contains values that are used to specify attach options.
AuditLevel The AuditLevel enumeration contains values that are used to specify the Microsoft SQL Server audit level setting.
BackupActionType The BackupActionType enumeration contains values that are used to specify the type of backup.
BackupDeviceType The BackupDeviceType enumeration contains values that are used to specify the backup device type.
BackupRestoreBase.AsyncOperation The BackupRestoreBase.AsyncOperation enumeration contains values that are used to specify which backup components are running asynchronously.
BackupSetFlag The BackupSetFlag enumeration contains values that are used to specify the purpose of the backup.
BackupSetType The BackupSetType enumeration contains values that are used to specify the backup type.
BackupTruncateLogType The BackupTruncateLogType enumeration contains values that are used to specify the truncate action taken on the log.
CatalogPopulationAction The CatalogPopulationAction enumeration contains values that are used to specify the method used to populate a full-text catalog.
CatalogPopulationStatus The CatalogPopulationStatus enumeration contains values that are used to specify the status of the full-text catalog.
CertificateSourceType The CertificateSourceType enumeration contains values that are used to specify the source of the certificate.
ChangeTracking The ChangeTracking enumeration contains values that are used to specify change tracking in a full-text index.
CompatibilityLevel The CompatibilityLevel enumeration is a list of constant values that specify the behavior that corresponds to a version of Microsoft SQL Server.
DatabaseDdlTriggerExecutionContext The DatabaseDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the database DDL trigger runs.
DatabaseEventType The DatabaseEventType enumeration is a list of constant values that specify the database event type.
DatabaseObjectTypes The DatabaseObjectTypes enumeration is a list of constant values that specifies the types of database object.
DatabasePermissionSetValue The DatabasePermissionSetValue enumeration is a list of constant values that specify all the database permissions.
DatabaseStatus The 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.
DatabaseUserAccess The DatabaseUserAccess enumeration is a list of constant values that specify the way in which user access can be restricted.
DependencyType The DependencyType enumeration is a list of constant values that specifies the direction of the dependency discovery operation.
DeviceType The DeviceType enumeration is a list of constant values that specify the various different types of devices supported by Microsoft SQL Server.
EndpointAuthenticationOrder The EndpointAuthenticationOrder enumeration contains values that are used to specify the authentication methods and order of preference for the endpoint connection.
EndpointEncryption The EndpointEncryption enumeration contains values that are used to specify the state of encryption on the endpoint.
EndpointEncryptionAlgorithm The EndpointEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an endpoint.
EndpointState The EndpointState enumeration is a list of constant values that specifies the state of the HTTP endpoint.
EndpointType The EndpointType enumeration is a list of constant values that specifies the type of HTTP endpoint.
EventType The EventType enumeration is a list of constant values that specify the various different types of events supported by Microsoft SQL Server.
ExecutionContext The 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.
ExecutionStatus The ExecutionStatus enumeration is a list of constant values that specify the status of an executing process.
FileGrowthType The FileGrowthType enumeration is a list of constant values that specify the method by which file growth is determined; by percentage amount or by a number of kilobytes.
FilterNode.Type This class supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
ForeignKeyAction The ForeignKeyAction enumeration is a list of constant values that specify the action taken when the primary key reference by a foreign key is updated.
FragmentationOption The FragmentationOption enumeration is a list of constant values that specify the levels of detail of collected fragmentation information.
HttpAuthenticationModes The HttpAuthenticationModes enumeration contains values that are used to specify the HTTP port for HTTP endpoints.
HttpPortTypes The HttpPortTypes enumeration contains values that are used to specify the type HTTP port.
ImplementationType The ImplementationType enumeration contains values that are used to specify the type of implementation for a stored procedure, a user-defined function, and other objects.
IndexEnableAction The IndexEnableAction enumeration contains values that are used to specify the action taken on an index when it is enabled after having been disabled.
IndexKeyType The IndexKeyType enumeration contains values that are used to specify the type of key on which the index is created.
IndexOperation The IndexOperation enumeration contains values that are used to specify index operations.
IndexPopulationAction The IndexPopulationAction enumeration contains values that are used to specify the type of Microsoft Search full-text index population.
IndexPopulationStatus The IndexPopulationStatus enumeration contains values that are used to specify the type of population in progress.
KeyEncryptionType The KeyEncryptionType enumeration is a list of constant values that specify the key encryption type.
LinkedTableType The LinkedTableType enumeration contains values that specify the type of table accessed on a linked server.
LinkFieldType The LinkFieldType enumeration contains values that specify the type of link field.
LockRequestStatus The LockRequestStatus enumeration contains constant values that specify the lock request status.
LoginCreateOptions The LoginCreateOptions enumeration contains values that are used to specify the password options when you create a logon.
LoginType The LoginType enumeration contains values that are used to specify the authentication type and the Windows account type.
LogReuseWaitStatus The LogReuseWaitStatus enumeration contains values that specify the current operation on which the reuse of transaction log space is waiting.
MediaTypes The 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.
MethodLoginType The MethodLoginType enumeration contains values that are used to specify the method used for logging on to the instance of SQL Server.
MethodXsdSchemaOption The MethodXsdSchemaOption enumeration contains values that specify the XSD schema returned for a SOAP method.
MirroringOption The MirroringOption enumeration contains values that specify the mirroring options for a database.
MirroringRole The MirroringRole enumeration contains values that specify the role the database plays in mirroring.
MirroringSafetyLevel The MirroringSafetyLevel enumeration contains values that specify the safety guarantee on updates to the mirrored database.
MirroringStatus The MirroringStatus enumeration contains values that specify the state of a database regarding mirroring.
MirroringWitnessStatus The MirroringWitnessStatus enumeration contains values that specify the state of the mirroring witness.
Month The Month enumeration contains constant values that specify the twelve calendar months.
NSActivationState The NSActivationState enumeration contains constant values that specify the activation state of Notification Services.
ObjectClass The ObjectClass enumeration contains values that specify the SQL Server Management Objects (SMO) class type.
ObjectPermissionSetValue The ObjectPermissionSetValue enumeration is a list of constant values that specify all the object permissions.
ObjectPropertyUsages The ObjectPropertyUsages enumeration contains constant values that specify the ways in which properties are used.
OrderBy.Direction This class supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
PageVerify The PageVerify enumeration contains constant values that specify the automatic page verification options for a database.
PerfMonMode The PerfMonMode enumeration contains values that are used to specify the polling behavior in Performance Monitor.
PermissionState The PermissionState enumeration contains values that specify the state of a permission.
PrincipalType The PrincipalType enumeration contains values that specify the type of user, role, or login.
PrivateKeyEncryptionType The PrivateKeyEncryptionType enumeration contains values that are used to specify the encryption types for a private key associated with a certificate or an asymmetric key.
PrivilegeTypes The PrivilegeTypes enumeration contains values that are used to specify the operations that the grantee can perform on the specified object when permission is granted.
ProtocolType The ProtocolType enumeration contains values that are used to specify the type of protocol.
RangeType The RangeType enumeration contains values that are used to specify the type range.
RecoveryModel The RecoveryModel enumeration contains values that are used to specify the type of recovery model.
RepairType The RepairType enumeration contains values that are used to specify the type of repair mode used by the database consistency check (DBCC) functions.
ReplicationOptions The ReplicationOptions enumeration contains values that are used to specify the replication settings for the referenced database.
ResourceUsage The ResourceUsage enumeration contains values that specify the relative operating system execution priority setting for the Microsoft Search service.
RestoreActionType The RestoreActionType enumeration contains values that are used to specify the type of action required during a data restore operation.
RestoreType The RestoreType enumeration contains values that specify the type of restore operation to perform.
ResultFormat The ResultFormat enumeration contains values that specify the format in which to return results for an HTTP endpoint.
RoleTypes The RoleTypes enumeration contains values that are used to specify the type of role.
SecondaryXmlIndexType The SecondaryXmlIndexType enumeration contains values that are used to specify the secondary XML index type.
ServerDdlTriggerExecutionContext The ServerDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the server DDL trigger runs.
ServerLoginMode The ServerLoginMode enumeration contains values that are used to specify the method used to connect to the instance of Microsoft SQL Server.
ServerMirroringRole The ServerMirroringRole enumeration contains values that are used to specify the role of the instance of Microsoft SQL Server when participating in mirroring.
ServerPermissionSetValue The ServerPermissionSetValue enumeration is a list of constant values that specify all the database permissions.
ShrinkMethod The ShrinkMethod enumeration contains values that are used to specify the method used shrink a database file.
SmoExceptionType The SmoExceptionType enumeration contains values that are used to specify the type of SQL Server Management Objects (SMO) exception.
SnapshotIsolationState The SnapshotIsolationState enumeration contains values that are used to specify the current state of snapshot isolation.
SortOrder This class supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
SqlDataType The SqlDataType enumeration contains values that are used to specify a Microsoft SQL Server data type.
SqlServerVersion The SqlServerVersion enumeration contains values that are used to specify the version of the referenced instance of Microsoft SQL Server.
SqlServerVersions The SqlServerVersions enumeration contains values that are used to specify the version of the referenced instance of Microsoft SQL Server.
SqlSmoState The SqlSmoState enumeration contains values that are used to specify the state of a SQL Server Management Objects (SMO) object.
SqlVerifyAction The SqlVerifyAction enumeration contains values that are used to specify the type of backup verification.
StatisticsScanType The 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.
StatisticsTarget The StatisticsTarget enumeration contains values that specify the type of statistic targeted for the update operation.
SymmetricKeyEncryptionAlgorithm The SymmetricKeyEncryptionAlgorithm enumeration contains values that specify the algorithm that is used to encrypt the symmetric key.
SymmetricKeyEncryptionType The SymmetricKeyEncryptionType enumeration contains constant values that specify the type of symmetric key encryption.
TerminationClause The TerminationClause enumeration contains constant values that specify the action taken when transactions are terminated.
TransactionTypes The TransactionTypes enumeration contains constant values that specify the method of recording transactions.
UserDefinedFunctionType The UserDefinedFunctionType enumeration is a list of constant values that specify the types of user-defined functions supported by Microsoft SQL Server.
UserDefinedTypeFormat The UserDefinedTypeFormat enumeration is a list of constant values that specify the formats used by user-defined types.
UserType The UserType enumeration contains constant values that specify the security type for the user.
WindowsLoginAccessType The WindowsLoginAccessType enumeration contains constant values that specify the type of access a Microsoft Windows login has to the instance of Microsoft SQL Server.
WsdlGeneratorOption The WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.
XmlDocumentConstraint The XmlDocumentConstraint enumeration contains constant values that specify the constraints imposed on an XML document.
XmlFormatOption The WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.
XmlTypeDerivation The XmlTypeDerivation enumeration contains constant values that specify the XML type derivation.
XmlTypeKind The XmlTypeKind enumeration contains constant values that specify the kind of XML component.
XPathExceptionCode  
XsdSchemaOption The XsdSchemaOption enumeration contains constant values that specify whether an inline schema for the method result is returned in the SOAP response.