Export (0) Print
Expand All
Expand Minimize
2 out of 4 rated this helpful - Rate this topic

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.

  ClassDescription
Public classAbstractCollectionBaseThe AbstractCollectionBase object is a base class object that is used in the construction of collection objects.
Public classApplicationRoleThe ApplicationRole object represents a security role that is used to set access privileges from an application regardless of the user's permissions.
Public classApplicationRoleCollectionThe ApplicationRoleCollectionclass represents a collection of ApplicationRole objects that represent all the application roles on the referenced database.
Public classApplicationRoleEventsThe ApplicationRoleEvents object represents the settings required for Microsoft SQL Server application role event notification.
Public classArrayListCollectionBaseThe ArrayListCollectionBase object represents a base class that is used in the construction of collections that are based on array lists.
Public classAsymmetricKeyThe AsymmetricKey object represents a SQL Server asymmetric key.
Public classAsymmetricKeyCollectionThe AsymmetricKeyCollection class represents a collection of AsymmetricKey objects that represent all the asymmetric keys on the referenced database.
Public classAsyncStatusThe AsyncStatus object represents the status of an asynchronous process.
Public classAuditThe Audit object represents a SQL Server audit log.
Public classAuditCollectionThe AuditCollection class represents a collection of Audit objects that represent all the audits on the instance of SQL Server.
Public classAuditExtenderAdds methods and properties to the Audit object.
Public classAuditSpecificationThe Column object represents a SQL Server column.
Public classBackupThe Backup object provides programmatic access to Microsoft SQL Server backup operations.
Public classBackupDeviceThe BackupDevice object provides programmatic access to SQL Server backup devices.
Public classBackupDeviceCollectionThe BackupDeviceCollection class represents a collection of BackupDevice objects that represent all the backup devices on an instance of SQL Server.
Public classBackupDeviceItemThe BackupDeviceItem object provides programmatic access to named SQL Server backup devices.
Public classBackupDeviceListThe BackupDeviceList object provides programmatic access to a list backup devices.
Public classBackupRestoreBaseThe BackupRestoreBase class is a base class that represents functionality that is common to both backup and restore operations.
Public classCertificateThe Certificate object represents a SQL Server certificate.
Public classCertificateCollectionThe CertificateCollection class represents a collection of Certificate objects that represent all the certificates on an instance of SQL Server.
Public classCertificateEventsThe CertificateEvents object represents the settings that are required for SQL Server Certificate event notification.
Public classCheckThe Check object represents a Microsoft SQL Server check constraint.
Public classCheckCollectionThe CheckCollection class represents a collection of Check objects that represent all the check constraints defined on the parent object.
Public classCollectionNotAvailableExceptionThe CollectionNotAvailableException class is an exception that is raised when an attempt is made to retrieve a collection that is not available.
Public classColumnThe Column object represents a SQL Server column.
Public classColumnCollectionThe ColumnCollection class represents a collection of Column objects that represent all the columns defined on a table.
Public classConfigPropertyThe ConfigProperty object contains information pertaining to a Microsoft SQL Server configuration option, such as maximum, minimum, current, and new values.
Public classConfigPropertyCollectionThe ConfigPropertyCollection class represents a collection of ConfigProperty objects that represent all the configuration properties defined on the instance of SQL Server.
Public classConfigurationThe Configuration class contains the configuration information for the instance of SQL Server.
Public classConfigurationBaseThe ConfigurationBase class is a base class that represents configuration information for the instance of SQL Server.
Public classCredentialThe Credential object represents a Microsoft SQL Server credential.
Public classCredentialCollectionThe CredentialCollection class represents a collection of Credential objects that represent all the credentials defined on the instance of Microsoft SQL Server.
Public classCryptographicProviderThe CryptographicProvider object represents a SQL Server cryptographic provider.
Public classCryptographicProviderCollectionA collection of type CryptographicProviderCollection that represents a collection of CryptographicProviderr objects.
Public classDatabaseThe Database object represents a SQL Server database.
Public classDatabaseActiveDirectoryThe DatabaseActiveDirectory object provides programmatic access to the Active Directory settings for a database.
Public classDatabaseAdapterDatabase Adapter type to be used as a management facet.
Public classDatabaseAdapterBaseDatabase adapter base.
Public classDatabaseAuditSpecificationThe DatabaseAuditSpecification object represents an auditable event on the database.
Public classDatabaseAuditSpecificationCollectionThe DatabaseAuditSpecificationCollection class represents a collection of DatabaseAuditSpecification objects that represent all the audit specifications defined on the database.
Public classDatabaseAuditSpecificationExtenderAdds methods and properties to the DatabaseAuditSpecification object.
Public classDatabaseCollectionThe DatabaseCollection class represents a collection of Database objects that represent all the databases defined on the instance of SQL Server.
Public classDatabaseDdlTriggerThe DatabaseDdlTrigger object represents a SQL Server database data definition language (DDL) trigger.
Public classDatabaseDdlTriggerCollectionThe DatabaseDdlTriggerCollection class represents a collection of DatabaseDdlTrigger objects that represent all the database data definition language (DDL) triggers defined on a table.
Public classDatabaseDdlTriggerEventThe DatabaseDdlTriggerEvent object represents the SQL Server database DDL trigger events that can be included in a database DDL trigger event set.
Public classDatabaseDdlTriggerEventSetThe DatabaseDdlTriggerEventSet object represents a set of SQL Server database data definition language (DDL) trigger events.
Public classDatabaseEncryptionKeyCreates a database encryption key.
Public classDatabaseEncryptionKeyExtenderExtends the database encryption key class.
Public classDatabaseEventThe DatabaseEvent object represents the SQL Server database events that can be included in a database event set.
Public classDatabaseEventArgsThe DatabaseEventArgs object represents the arguments passed by the event raised by the database.
Public classDatabaseEventsThe DatabaseEvents object represents the settings required for Microsoft SQL Server database event notification.
Public classDatabaseEventSetThe DatabaseEventSet object represents a SQL Server set of database events.
Public classDatabaseFileThe DatabaseFile object is a base class used in the construction of DataFile objects and LogFile objects.
Public classDatabaseFileMappingsDictionaryThis class, which is inherited from Dictionary, maps database file paths from the source server to the corresponding target server location that the user specifies.
Public classDatabaseMaintenanceAdapterThe Database Maintenance facet has logical properties. It inherits from the DatabaseAdapter class.
Public classDatabaseMappingThe DatabaseMapping object represents a SQL Server database mapping.
Public classDatabaseMirroringPayloadThe DatabaseMirroringPayload object represents database mirroring payload settings.
Public classDatabaseOptionsThe DatabaseOptions object represents SQL Server database options.
Public classDatabasePerformanceAdapterThe Database Performance facet implements logical properties relevant to database performance management.
Public classDatabasePermissionThe 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.
Public classDatabasePermissionInfoThe DatabasePermissionInfo object represents information about a SQL Server database permission.
Public classDatabasePermissionSetThe DatabasePermissionSet object represents a SQL Server set of database permissions.
Public classDatabaseRoleThe DatabaseRole object represents a SQL Server database security role.
Public classDatabaseRoleCollectionThe DatabaseRoleCollection class represents a collection of DatabaseRole objects that represent all the database roles defined on the parent database.
Public classDatabaseSecurityAdapterIncludes properties and methods that are used to expose the Database Security facet.
Public classDatabaseSnapshotExtenderAdds methods and properties to the DatabaseSnapshot object.
Public classDataFileThe DataFile object represents a Microsoft SQL Server data file.
Public classDataFileCollectionThe DataFileCollection class represents a collection of DataFile objects that represent all the data files defined on the parent object.
Public classDataTypeThe DataType object represents a SQL Server data type.
Public classDdlTriggerBaseThe DdlTriggerBase is a base class that is inherited by the DatabaseDdlTrigger object. This represents a SQL Server database data definition language (DDL) trigger.
Public classDefaultThe Default object represents a Microsoft SQL Server default.
Public classDefaultCollectionThe DefaultCollection class represents a collection of Default objects.
Public classDefaultConstraintThe DefaultConstraint object represents a SQL Server default constraint.
Public classDefaultRuleBaseThe DefaultRuleBase class is a base class that is inherited by the Rule class and the Default class.
Public classDependencyCollectionThe DependencyCollection class represents a collection of Dependency objects that are used to derive the node classes in SMO scripting operations.
Public classDependencyCollectionNodeThe DependencyCollectionNode class represents a node in the dependency collection that is derived during scripting operations.
Public classDependencyNodeThe DependencyNode class represents a node that is defined by a URN address.
Public classDependencyTreeThe DependencyTree object represents a tree structure that contains SQL Server objects and their hierarchical relationships to each other.
Public classDependencyTreeNodeThe DependencyTreeNode class represents the child and sibling SQL Server objects within a DependencyTree object hierarchy.
Public classDependencyWalkerThe 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.
Public classEndpointThe Endpoint class represents an endpoint service that can listen natively for requests.
Public classEndpointCollectionThe EndpointCollection class represents a collection of Endpoint objects that represent all the HTTP endpoints.
Public classEndpointPayloadThe EndpointPayload object represents an endpoint payload.
Public classEndpointProtocolThe EndpointProtocol object represents an HTTP endpoint protocol.
Public classEventPropertyThe EventProperty class represents a property of an event.
Public classEventPropertyCollectionThe EventPropertyCollection object represents the properties of event objects.
Public classEventSetBaseThe EventSetBase class is a base class that is used to derive the event set objects.
Public classExtendedPropertyThe ExtendedProperty object represents the extended properties that are defined for any object that has an ExtendedProperties collection property.
Public classExtendedPropertyCollectionThe ExtendedPropertyCollection class represents a collection of ExtendedPropertyCollectionobjects that represent all the extended properties.
Public classExtendedStoredProcedureThe ExtendedStoredProcedure object represents an extended stored procedure on the instance of Microsoft SQL Server.
Public classExtendedStoredProcedureCollectionThe ExtendedStoredProcedureCollection class represents a collection of ExtendedStoredProcedure objects that represent all the extended stored procedures defined on the parent database.
Public classFailedOperationExceptionThe FailedOperationException class represents the exception raised when an operation fails.
Public classFileGroupThe FileGroup object represents a SQL Server file group.
Public classFileGroupCollectionThe FileGroupCollection class represents a collection of FileGroup objects that represent all the filegroups defined on the parent database.
Public classForeignKeyThe ForeignKey object represents a SQL Server foreign key.
Public classForeignKeyCollectionThe ForeignKeyCollection class represents a collection of ForeignKey objects that represent all the foreign keys defined on the parent object.
Public classForeignKeyColumnThe ForeignKeyColumn object represents a SQL Server foreign key column.
Public classForeignKeyColumnCollectionThe ForeignKeyColumnCollection class represents a collection of ForeignKeyColumn objects that represent all the foreign key columns defined on the parent object.
Public classFrequencyPairThe FrequencyPair object is a utility that measures frequency by storing count and duration information.
Public classFullTextCatalogThe FullTextCatalog object represents a Microsoft Search full-text catalog.
Public classFullTextCatalogCollectionThe FullTextCatalogCollection class represents a collection of FullTextCatalog objects that represent all the full-text catalogs defined on the parent object.
Public classFullTextIndexThe FullTextIndex object represents a Microsoft Search full-text index.
Public classFullTextIndexColumnThe FullTextIndexColumn object represents a Microsoft Search full-text index column.
Public classFullTextIndexColumnCollectionThe FullTextIndexColumnCollection class represents a collection of FullTextIndexColumn objects that represent all the full-text index columns defined on the parent object.
Public classFullTextServiceThe FullTextService object allows programmatic access to the Microsoft Search full-text settings.
Public classFullTextStopListThe FullTextStopList object represents a full-text stop list.
Public classFullTextStopListCollectionThe FullTextStopListCollection class represents a collection of FullTextStopList objects that represent all the full-text stop lists that are defined on the parent database.
Public classHttpProtocolThe HttpProtocol object represents an HTTP protocol on an instance of Microsoft SQL Server.
Public classIndexThe Index object represents a SQL Server index.
Public classIndexCollectionThe IndexCollection class represents a collection of Index objects that represent all the indexes defined on the instance of SQL Server.
Public classIndexedColumnThe IndexedColumn object represents a SQL Server column that is participating in an index.
Public classIndexedColumnCollectionThe IndexedColumnCollection class represents a collection of IndexedColumn objects that represent all the indexed columns defined on the instance of SQL Server.
Public classIndexEventsThe IndexEvents object represents the settings that are required for SQL Server index event notification.
Public classInformationThe 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.
Public classInternalSmoErrorExceptionThe InternalSmoErrorException class represents the exception raised when an error occurs during the internal phase of a SMO operation.
Public classInvalidSmoOperationExceptionThe InvalidSmoOperationException class represents the exception raised when an SMO operation is not valid.
Public classInvalidVersionSmoOperationExceptionThe InvalidVersionSmoOperationException class represents the exception raised when the version is not valid on an SMO operation.
Public classJobScheduleCollectionBaseThe JobScheduleCollectionBase class represents a base class that is used in the construction of the JobScheduleCollection class.
Public classLanguageA 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.
Public classLanguageCollectionThe LanguageCollection class represents a collection of Language objects that represent all the languages which are defined on the instance of SQL Server.
Public classLinkedServerA 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.
Public classLinkedServerCollectionThe LinkedServerCollection class represents a collection of LinkedServer objects that represent all the linked servers registered on the instance of SQL Server.
Public classLinkedServerLoginThe LinkedServerLogin object represents a SQL Server logon account that has permission to connect to the linked server.
Public classLinkedServerLoginCollectionThe LinkedServerLoginCollection class represents a collection of LinkedServerLogin objects that represent all the linked server logins defined on the linked server.
Public classLogFileThe LogFile object represents a SQL Server log file.
Public classLogFileCollectionThe LogFileCollection class represents a collection of LogFile objects that represent all the log files defined on the instance of Microsoft SQL Server.
Public classLoginThe 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.
Public classLoginCollectionThe LoginCollection class represents a collection of Login objects that represent all the login accounts defined on the instance of SQL Server.
Public classLoginEventsThe LoginEvents object represents the settings required for SQL Server login event notification.
Public classMasterKeyThe MasterKey object represents a SQL Server database master key.
Public classMessageCollectionBaseThe MessageCollectionBase class is a base class that is used in the construction of message collection classes.
Public classMessageObjectBaseThe MessageObjectBase class is a base class that is inherited by message classes.
Public classMissingObjectExceptionThe MissingObjectException class represents the exception raised when an object is missing.
Public classNamedSmoObjectThe NamedSmoObject object represents a named SMO object.
Public classNumberedObjectCollectionBaseThe NumberedObjectCollectionBase class is a base class that represents common functionality for collections of numbered objects, such as the NumberedStoredProcedure object.
Public classNumberedStoredProcedureThe NumberedStoredProcedure class represents a Microsoft SQL Server numbered stored procedure.
Public classNumberedStoredProcedureCollectionThe NumberedStoredProcedureCollection class represents a collection of NumberedStoredProcedure objects that represent all the numbered stored procedures defined on a table.
Public classNumberedStoredProcedureParameterThe NumberedStoredProcedureParameter object represents a SQL Server numbered stored procedure parameter.
Public classNumberedStoredProcedureParameterCollection
Public classObjectAlteredEventArgsThe ObjectAlteredEventArgs object represents the arguments that are passed by the event that is raised when an object is altered.
Public classObjectCreatedEventArgsThe ObjectCreatedEventArgs object represents the arguments that are passed by the event that is raised when an object is created.
Public classObjectDroppedEventArgsThe ObjectDroppedEventArgs object represents the arguments that are passed by the event that is raised when an object is dropped.
Public classObjectEventThe ObjectEvent object represents the of SQL Server object events that can be included in an object event set.
Public classObjectEventSetThe ObjectEventSet object represents a SQL Server set of object events.
Public classObjectPermissionThe ObjectPermission object represents a SQL Server object permission.
Public classObjectPermissionInfoThe ObjectPermissionInfo object represents information about a SQL Server object permission.
Public classObjectPermissionSetThe ObjectPermissionSet object represents a set of object permissions in Microsoft SQL Server.
Public classObjectRenamedEventArgsThe ObjectRenamedEventArgs object represents the arguments passed by the event raised when an object is renamed.
Public classOleDbProviderSettingsThe OleDbProviderSettings object represents the setting for a SQL Server OLE DB provider.
Public classOleDbProviderSettingsCollectionThe OleDbProviderSettingsCollection class represents a collection of OleDbProviderSettings objects that represent all the OLE DB provider settings defined on the linked server.
Public classOrderColumnOrderColumn 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.
Public classOrderColumnCollectionRepresents a collection of OrderColumn.
Public classParameterThe 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.
Public classParameterBaseThe ParameterBase class is a base class that is inherited by the Parameter class and the UserDefinedAggregate class. It contains common features of both classes.
Public classParameterCollectionBaseThe ParameterCollectionBase class is a base class that is used in the construction of parameter collection classes.
Public classPartitionFunctionThe PartitionFunction object provides programmatic access to partition functions.
Public classPartitionFunctionCollectionThe PartitionFunctionCollection class represents a collection of PartitionFunction objects that represent all the partition functions defined on the instance of SQL Server.
Public classPartitionFunctionEventsThe PartitionFunctionEvents object represents the settings required for SQL Server partition function event notification.
Public classPartitionFunctionParameterThe PartitionFunctionParameter object provides programmatic access to partition function parameters.
Public classPartitionFunctionParameterCollectionThe PartitionFunctionParameterCollection class represents a collection of PartitionFunctionParameter objects that represent all the partition function parameters defined on the partition function.
Public classPartitionNumberedObjectCollectionBaseThe PartitionNumberedObjectCollectionBase is a base class that is inherited by the PhysicalPartitionCollection class.
Public classPartitionSchemeThe PartitionScheme object provides programmatic access to partition schemes.
Public classPartitionSchemeCollectionThe PartitionSchemeCollection class represents a collection of PartitionScheme objects that represent all the partition schemes defined on the instance of SQL Server.
Public classPartitionSchemeEventsThe PartitionSchemeEvents object represents the settings required for Microsoft SQL Server partition scheme event notification.
Public classPartitionSchemeParameterThe PartitionSchemeParameter object provides programmatic access to partition scheme parameters.
Public classPartitionSchemeParameterCollectionThe PartitionSchemeParameterCollection class represents a collection of PartitionSchemeParameter objects that represent all the partition scheme parameters defined on the partition scheme.
Public classPayloadThe Payload object represents a SQL Server HTTP endpoint payload.
Public classPercentCompleteEventArgsThe PercentCompleteEventArgs object represents the arguments passed by the event raised when a process reaches a percent complete marker.
Public classPerformanceCountersA PerformanceCounters object represents a performance counter that is used to trace the performance of the instance of SQL Server.
Public classPermissionInfoThe PermissionInfo class represents information regarding granted or denied privileges.
Public classPermissionSetBaseThe PermissionSetBase class is a base class that is inherited by permission set classes.
Public classPhysicalPartitionThe PhysicalPartition object represents the physical partition where the data and meta data is stored for a SQL Server object.
Public classPhysicalPartitionCollectionThe PhysicalPartitionCollection class represents a collection of PhysicalPartition objects that represent all the physical partitions that are defined on an object.
Public classPlanGuideCreates a plan guide object: PlanGuide
Public classPlanGuideCollectionCollection of plan guide objects.
Public classPlanGuideExtenderExtends the Property set for a Plan Guide
Public classProgressReportEventArgsThe 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.
Public classPropertyThe Property object provides programmatic access to the properties of all the SMO objects.
Public classPropertyCannotBeRetrievedExceptionThe PropertyCannotBeRetrievedException class represents the exception raised when a property cannot be retrieved.
Public classPropertyCollectionThe PropertyCollection class represents a collection of Property objects that represent all the properties defined on the parent object.
Public classPropertyNotSetExceptionThe PropertyNotSetException class represents the exception that is raised when a property value has not been set.
Public classPropertyReadOnlyExceptionThe PropertyReadOnlyException class represents the exception that is raised when an attempt is made to set a read-only property.
Public classPropertyTypeMismatchExceptionThe PropertyTypeMismatchException class represents the exception raised when an attempt is made to set the property with a value that has the incorrect data type.
Public classPropertyWriteExceptionThe PropertyWriteException class represents the exception that is raised when an error occurs when setting the value of a property.
Public classProtocolThe Protocol object provides programmatic access to the protocols supported by SQL Server.
Public classRelocateFileThe RelocateFile object is a programmatic tool that lets a file be relocated.
Public classResourceGovernorResourceGovernor class.
Public classResourcePoolResource Pool Class
Public classResourcePoolCollectionRepresents a collection of Resource Pools.
Public classRestoreThe Restore object provides programmatic access to restore operations.
Public classRuleThe Rule object provides programmatic access to a SQL Server rule.
Public classRuleCollectionThe RuleCollection class represents a collection of Rule objects that represent all the rules defined on the instance of SQL Server.
Public classSchemaThe Schema object represents an ownership context for a SQL Server database object.
Public classSchemaCollectionThe SchemaCollection class represents a collection of Schema objects that represent all the schemas on the referenced database.
Public classSchemaCollectionBaseThe SchemaCollectionBase class is a base class that is inherited by the SchemaCollection class.
Public classSchemaEventsThe SchemaEvents object represents the settings required for SQL Server schema event notification.
Public classScripterThe Scripter object is the overall, top-level object for managing scripting operations.
Public classScriptingErrorEventArgsThe ScriptingErrorEventArgs object provides programmatic access to the arguments used to report the errors that occur during scripting operations.
Public classScriptingOptionsThe ScriptingOptions object provides programmatic options to the options that can be set for scripting operations.
Public classScriptNameObjectBaseThe ScriptNameObjectBase is a base class that is inherited by classes that can use an alternative name that is used in scripting operations.
Public classScriptOptionThe ScriptOption object represents the SQL Server script options that can be included in scripting options that are set by using the ScriptingOptions object.
Public classScriptSchemaObjectBaseThe ScriptSchemaObjectBase is a base class that is inherited by classes that can use an alternative name used in scripting operations.
Public classServerThe Server object represents an instance of SQL Server.
Public classServerActiveDirectoryThe ServerActiveDirectory object provides programmatic access to the Active Directory functionality.
Public classServerAdapterThis class aggregates otherwise hidden server properties.
Public classServerAdapterBaseA ServerAdapterBase object is a base class that is used in the construction of the ServerAdapter class.
Public classServerAuditSpecificationThe ServerAuditSpecification object represents an auditable event on the instance of SQL Server.
Public classServerAuditSpecificationCollectionThe ServerAuditSpecificationCollection class represents a collection of ServerAuditSpecification objects that represent all the audit specifications defined on the server.
Public classServerAuditSpecificationExtenderAdds methods and properties to the ServerAuditSpecification object.
Public classServerConfigurationAdapter
Public classServerDdlTriggerThe ServerDdlTrigger object represents a SQL Server data definition language (DDL) trigger.
Public classServerDdlTriggerCollectionThe ServerDdlTriggerCollection class represents a collection of ServerDdlTrigger objects that represent all the server data definition language (DDL) triggers defined on a table.
Public classServerDdlTriggerEventThe 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.
Public classServerDdlTriggerEventSetThe ServerDdlTriggerEventSet object represents a set of SQL Server server data definition language (DDL) trigger events.
Public classServerEventThe ServerEvent object represents the SQL Server server events that can be included in a server event set.
Public classServerEventArgsThe 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.
Public classServerEventsThe ServerEvents object represents the settings required for SQL Server server-level event notification.
Public classServerEventSetThe ServerEventSet object represents a set of server events on an instance of SQL Server.
Public classServerPermissionThe ServerPermission object represents a SQL Server server-level permission.
Public classServerPermissionInfoThe ServerPermissionInfo object represents information about a SQL Server server-level permission.
Public classServerPermissionSetThe ServerPermissionSet object represents a set of server permissions.
Public classServerProxyAccountThe 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.
Public classServerRoleThe ServerRole object represents a Microsoft SQL Server security role.
Public classServerRoleCollectionThe ServerRoleCollection class represents a collection of ServerRole objects that represent all the server roles that are defined on a table.
Public classServerSecurityAdapterA security facet that extends ServerAdapterBase.
Public classServerSetupAdapterA ServerSetupAdapter object represents a server setup adapter.
Public classServerSurfaceAreaAdapterA ServerSurfaceAreaAdapter object represents a server surface area adapter.
Public classServerTraceEventThe ServerTraceEvent object represents the SQL Server server trace events that can be included in a server trace event set.
Public classServerTraceEventSetThe ServerTraceEventSet object represents a set server trace events.
Public classServiceBrokerPayloadThe ServiceBrokerPayload object represents a SQL Server Service Broker payload.
Public classServiceMasterKeyThe ServiceMasterKey object represents a Microsoft SQL Server service master key.
Public classServiceQueueEventThe ServiceQueueEvent object represents the Service Broker service queue events that can be included in a service queue event set.
Public classServiceQueueEventSetThe ServiceQueueEventSet object represents a set of SQL Server service queue events.
Public classServiceRequestExceptionThe ServiceRequestException class represents the exception that is raised when an error occurs during a service request.
Public classSettingsThe Settings object represents a group of configurable settings on the instance of SQL Server.
Public classSimpleObjectCollectionBaseThe SimpleObjectCollectionBase class is a base class that is used in the construction of collection objects.
Public classSmoApplicationThe SmoApplication class represents an SMO application with respect to event management.
Public classSmoCollectionBaseThe SmoCollectionBase class is a base class that is used in the construction of SMO collection classes and contains members that are common to them.
Public classSmoDmfAdapterImplements Evaluate(IBaseManagementFacet)
Public classSmoEventArgsThe SmoEventArgs object provides programmatic access to the arguments used to report the events that occur in SMO applications.
Public classSmoExceptionThe SmoException class represents the exception that is raised when an error occurs during an SMO operation.
Public classSmoObjectBaseThe SmoObjectBase is a base class that is inherited by the SqlSmoObject class.
Public classSmoObjectExtender<T>
Public classSoapMethodCollectionBaseThe 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.
Public classSoapMethodObjectThe SoapMethodObject class provides programmatic access to the referenced SOAP method.
Public classSoapPayloadThe SoapPayload object represents a SQL Server SOAP payload.
Public classSoapPayloadMethodThe SoapPayloadMethod class represents a SOAP payload method for the referenced HTTP endpoint.
Public classSoapPayloadMethodCollectionThe SoapPayloadMethodCollection class represents a collection of SoapPayloadMethod objects that represent all the SOAP payload methods defined on a table.
Public classSortedListCollectionBaseThe SortedListCollectionBase class is a base class that is used in the construction of sorted list collection classes.
Public classSqlAssemblyThe SqlAssembly class represents an assembly in the Microsoft .NET environment.
Public classSqlAssemblyCollectionThe SqlAssemblyCollection class represents a collection of SqlAssembly objects that represent all the assemblies defined on a table.
Public classSqlAssemblyEventThe SqlAssemblyEvent object represents the SQL Server assembly events that can be included in an assembly event set.
Public classSqlAssemblyEventsThe SqlAssemblyEvents object represents the settings that are required for SQL Server assembly event notification.
Public classSqlAssemblyEventSetThe SqlAssemblyEventSet object represents a set of assembly events.
Public classSqlAssemblyFileThe SqlAssemblyFile object represents an assembly file that stores an assembly.
Public classSqlAssemblyFileCollectionThe SqlAssemblyFileCollection class represents a collection of SqlAssemblyFile objects that represent all the assembly files that are defined on a table.
Public classSqlPropertyCollectionThe SqlPropertyCollection class is an abstract class that is used in the management of object properties.
Public classSqlPropertyInfoThe SqlPropertyInfo class is an abstract class used to store information about properties.
Public classSqlServerRegistrations Obsolete. Represents registered instances of SQL Server.
Public classSqlSmoObjectThe SqlSmoObject object represents all SQL Server objects.
Public classStatisticThe Statistic class represents a SQL Server statistic counter.
Public classStatisticCollectionThe StatisticCollection class represents a collection of Statistic objects that represent all the statistic counters defined on the table or view.
Public classStatisticColumnThe StatisticColumn object represents a column defined in a SQL Server statistics counter.
Public classStatisticColumnCollectionThe StatisticColumnCollection class represents a collection of StatisticColumn objects that represent all the statistic columns defined on a table.
Public classStatisticEventsThe StatisticEvents object represents the settings required for SQL Server statistic counter event notification.
Public classStoredProcedureThe StoredProcedure object represents a SQL Server stored procedure.
Public classStoredProcedureCollectionThe StoredProcedureCollection class represents a collection of StoredProcedure objects that represent all the stored procedures that are defined on a table.
Public classStoredProcedureEventThe StoredProcedureEvent object represents the SQL Server stored procedure events that can be included in an stored procedure event set.
Public classStoredProcedureEventsThe StoredProcedureEvents object represents the settings that are required for SQL Server stored procedure event notification.
Public classStoredProcedureEventSetThe StoredProcedureEventSet object represents a set of stored procedure events.
Public classStoredProcedureParameterThe StoredProcedureParameter object represents a SQL Server stored procedure parameter.
Public classStoredProcedureParameterCollectionThe StoredProcedureParameterCollection class represents a collection of StoredProcedureParameter objects that represent all the stored procedure parameters defined on a table.
Public classSymmetricKeyThe SymmetricKey object represents a SQL Server symmetric key.
Public classSymmetricKeyCollectionThe SymmetricKeyCollection class represents a collection of SymmetricKey objects that represent all the symmetric keys on the referenced database.
Public classSymmetricKeyEncryptionThe SymmetricKeyEncryption class represents the encryption type used when encrypting symmetric keys.
Public classSynonymThe Synonym object represents a SQL Server synonym.
Public classSynonymCollectionThe SynonymCollection class represents a collection of Synonym objects that represent all the synonyms on the referenced database.
Public classSynonymEventsThe SynonymEvents object represents the settings that are required for SQL Server synonym event notification.
Public classSystemDataTypeThe SystemDataType object represents a supported system data type. The SystemDataTypeCollection represents all the supported system data types.
Public classSystemDataTypeCollectionThe SystemDataTypeCollection class represents a collection of SystemDataType objects that represent all the system data types on the referenced database.
Public classSystemMessageThe SystemMessage object represents messages defined by the system.
Public classSystemMessageCollectionThe SystemMessageCollection class represents a collection of SystemMessage objects that represent all the system messages on the instance of SQL Server.
Public classTableThe Table object represents a SQL Server table.
Public classTableCollectionThe TableCollection class represents a collection of Table objects that represent all the tables on the referenced database.
Public classTableEventThe TableEvent object represents the SQL Server table events that can be included in a table event set.
Public classTableEventsThe TableEvents object represents the settings required for SQL Server table event notification.
Public classTableEventSetThe TableEventSet object represents a set of table events.
Public classTableViewBaseThe 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.
Public classTableViewTableTypeBaseBase class for table view types.
Public classTcpProtocolThe TcpProtocol object provides programmatic access to the protocols supported by Microsoft SQL Server.
Public classTransferThe Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.
Public classTriggerThe Trigger object represents a SQL Server trigger.
Public classTriggerCollectionThe TriggerCollection class represents a collection of Trigger objects that represent all the triggers defined on a table.
Public classTriggerEventsThe TriggerEvents object represents the settings that are required for SQL Server trigger event notification.
Public classUnknownPropertyExceptionThe UnknownPropertyException class represents the exception that is raised when an SMO operation encounters an unknown property.
Public classUnsupportedFeatureExceptionThe UnsupportedFeatureException class represents the exception raised when an SMO operation encounters a request for an unsupported feature.
Public classUnsupportedObjectNameExceptionThe UnsupportedObjectNameException class represents the exception that is raised when an SMO operation encounters an unsupported object name.
Public classUnsupportedVersionExceptionThe UnsupportedVersionException class represents the exception raised when an SMO operation encounters an unsupported version of SQL Server.
Public classUrnCollectionThe UrnCollection class represents a collection of Urn objects that represent Uniform Resource Name (URN) addresses.
Public classUserThe User object represents a SQL Server user.
Public classUserCollectionThe UserCollection class represents a collection of User objects that represent all the database users defined on a database.
Public classUserDefinedAggregateThe UserDefinedAggregate object represents a SQL Server user-defined aggregate.
Public classUserDefinedAggregateCollectionThe UserDefinedAggregateCollection class represents a collection of UserDefinedAggregate objects that represent all the database user-defined aggregates that are defined on a database.
Public classUserDefinedAggregateParameterThe UserDefinedAggregateParameter object represents the parameters that are used with a user-defined aggregate.
Public classUserDefinedAggregateParameterCollectionThe UserDefinedAggregateParameterCollection class represents a collection of UserDefinedAggregateParameter objects that represent all the user-defined aggregate parameters that are defined on a table.
Public classUserDefinedDataTypeThe UserDefinedDataType object represents a SQL Server user-defined data type.
Public classUserDefinedDataTypeCollectionThe UserDefinedDataTypeCollection class represents a collection of UserDefinedDataType objects that represent all the user-defined data types defined on a table.
Public classUserDefinedFunctionThe UserDefinedFunction object represents a SQL Server user-defined function.
Public classUserDefinedFunctionCollectionThe UserDefinedFunctionCollection class represents a collection of UserDefinedFunction objects that represent all the user-defined functions that are defined on a table.
Public classUserDefinedFunctionEventThe UserDefinedFunctionEvent object represents the SQL Server user-defined function events that can be included in a user-defined function event set.
Public classUserDefinedFunctionEventsThe UserDefinedFunctionEvents object represents the settings that are required for SQL Server user-defined function event notification.
Public classUserDefinedFunctionEventSetThe UserDefinedFunctionEventSet object represents a SQL Server set of user-defined function events.
Public classUserDefinedFunctionParameterThe UserDefinedFunctionParameter object represents a SQL Server user-defined function parameter.
Public classUserDefinedFunctionParameterCollectionThe UserDefinedFunctionParameterCollection class represents a collection of UserDefinedFunctionParameter objects that represent all the user-defined function parameters that are defined on a table.
Public classUserDefinedMessageThe UserDefinedMessage object represents a user-defined message.
Public classUserDefinedMessageCollectionThe UserDefinedMessageCollection class represents a collection of UserDefinedMessage objects that represent all the user-defined messages defined on a table.
Public classUserDefinedTableTypeThe UserDefinedTableType object represents a SQL Server user-defined table type data type.
Public classUserDefinedTableTypeCollectionThe UserDefinedTableTypeCollection class represents a collection of UserDefinedTableType objects that represent all the user-defined table types that are defined on a database.
Public classUserDefinedTypeThe UserDefinedType represents an alias data type that is based on .NET data types.
Public classUserDefinedTypeCollectionThe UserDefinedTypeCollection class represents a collection of UserDefinedType objects that represent all the alias data types that are defined on a table.
Public classUserDefinedTypeEventsThe UserDefinedTypeEvents object represents the settings required for SQL Server user-defined type event notification.
Public classUserEventsThe UserEvents object represents the settings that are required for SQL Server database user event notification.
Public classUserOptionsThe UserOptions object represents a set configurable server options that relate specifically to users.
Public classVerifyCompleteEventArgsThe VerifyCompleteEventArgs object provides programmatic access to the arguments used to report the details of the event that occurs when a backup verification operation completes.
Public classViewThe View object represents a SQL Server view.
Public classViewCollectionThe ViewCollection class represents a collection of View objects that represent all the views defined on a table.
Public classViewEventThe ViewEvent object represents the SQL Server view events that can be included in a view event set.
Public classViewEventsThe ViewEvents object represents the settings that are required for SQL Server view event notification.
Public classViewEventSetThe ViewEventSet object represents a set of view events.
Public classWorkloadGroup
Public classWorkloadGroupCollectionInitializes a workload group.
Public classWrongPropertyValueExceptionThe WrongPropertyValueException class represents the exception that is raised when a property is assigned the wrong value.
Public classXmlSchemaCollectionThe 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.
Public classXmlSchemaCollectionCollectionThe 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.
  StructureDescription
Public structureAuditSpecificationDetailThe AuditSpecificationDetail object represents a SQL Server audit specification detail required when creating an audit.
Public structureDdlTextParserHeaderInfoThis class supports the SMO infrastructure and is not intended to be used directly from your code.
  InterfaceDescription
Public interfaceIColumnPermissionThe IColumnPermission class represents the interface that manages permissions for a specified column.
Public interfaceIDatabaseMaintenanceFacetInterface that defined methods and properties for the database maintenance facet.
Public interfaceIDatabaseOptionsInterface with properties that expose database options.
Public interfaceIDatabasePerformanceFacet
Public interfaceIDatabaseSecurityFacetSecurity facet interface.
Public interfaceIExtendedPropertiesThe IExtendedProperties class is an interface that represents the collection of extended properties associated with an object.
Public interfaceILoginOptionsThe ILoginOptions class is an interface that represents a collection of options associated with a login.
Public interfaceIMultipartNameFacetInterface to deal with object names containing both the object and the schema.
Public interfaceINameFacetRepresents the name facet interface.
Public interfaceIObjectPermissionThe IObjectPermission class represents the interface used to set object permissions.
Public interfaceIScriptableThe IScriptable class represents the interface used to create Transact-SQL scripts of SMO objects.
Public interfaceIServerAuditFacetInterface that identifies audit facet members.
Public interfaceIServerConfigurationFacetContains configuration information for the interface based on Configuration
Public interfaceIServerInformationAn interface based on the Information type properties.
Public interfaceIServerPerformanceFacetAn interface for the performance facet.
Public interfaceIServerSecurityFacetAn interface that defines members for the SeverSecurityFacet.
Public interfaceIServerSettingsAn interface for SQL Server 2008 Policy-Based Management that is based on Settings.
Public interfaceIServerSetupFacetRepresents the Policy-Based Management facet interface for setting up an instance of SQL Server.
Public interfaceISurfaceAreaFacetAn interface that defines surface area facet members.
Public interfaceITableOptionsThe ITableOptions class is an interface that represents a collection of options that is associated with a table.
Public interfaceITextObjectThe ITextObject class represents the interface that is used to implement text on objects.
Public interfaceIViewOptionsThe IViewOptions class is an interface that represents a collection of options that is associated with a view.
  DelegateDescription
Public delegatePercentCompleteEventHandlerThe PercentCompleteEventHandler class represents the event handler that is used to handle percent complete events.
Public delegateProgressReportEventHandlerThe ProgressReportEventHandler class represents the event handler that is used to handle progress report events.
Public delegateScriptingErrorEventHandlerThe ScriptingErrorEventHandler class represents the event handler that is used to handle scripting errors.
Public delegateScriptingFilterThis class supports the SMO infrastructure and is not intended to be used directly from your code.
Public delegateServerEventHandlerThe ServerEventHandler class represents the event handler that is used to handle server errors.
Public delegateSmoApplication.AnyObjectEventHandlerThe SmoApplication.AnyObjectEventHandler class represents the event handler that is used to handle events from any object.
Public delegateSmoApplication.DatabaseEventHandlerThe SmoApplication.DatabaseEventHandler class represents the event handler that handles database events.
Public delegateSmoApplication.ObjectAlteredEventHandlerThe SmoApplication.ObjectAlteredEventHandler class represents the event handler that is used to handle events that occur when an object is altered.
Public delegateSmoApplication.ObjectCreatedEventHandlerThe SmoApplication.ObjectCreatedEventHandler class represents the event handler that is used to handle events when an object is created.
Public delegateSmoApplication.ObjectDroppedEventHandlerThe SmoApplication.ObjectDroppedEventHandler class represents the event handler that is used to handle events when an object is dropped.
Public delegateSmoApplication.ObjectRenamedEventHandlerThe SmoApplication.ObjectRenamedEventHandler class represents the event handler that handles events that occur when an object is renamed.
Public delegateVerifyCompleteEventHandlerThe VerifyCompleteEventHandler class represents the event handler that handles completion events.
  EnumerationDescription
Public enumerationActivationExecutionContextThe ActivationExecutionContext enumeration contains values that specify the security context used by a procedure. These procedures are activated by a service queue.
Public enumerationAssemblyAlterOptionsThe 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.
Public enumerationAssemblySecurityLevelThe AssemblySecurityLevel enumeration contains values that are used to specify the access rights for an assembly.
Public enumerationAsymmetricKeyEncryptionAlgorithmThe AsymmetricKeyEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an asymmetric key.
Public enumerationAsymmetricKeySourceTypeThe AsymmetricKeySourceType enumeration contains values that are used to specify the source type used to load an asymmetric key.
Public enumerationAttachOptionsThe AttachOptions enumeration contains values that are used to specify attach options.
Public enumerationAuditActionTypeThe AuditActionType enumeration contains values that are used to specify the audit action types.
Public enumerationAuditDestinationTypeThe AuditDestination enumeration contains values that are used to specify the destination, to which the results of a SQL Server Audit are sent.
Public enumerationAuditFileSizeUnitThe AuditFileSizeUnit enumeration contains values that are used to specify the unit that specifies the size of the audit file.
Public enumerationAuditLevelThe AuditLevel enumeration contains values that are used to specify the SQL Server audit level setting.
Public enumerationAuditStatusTypeThe AuditStatusType enumeration contains values that are used to specify the status of the audit.
Public enumerationBackupActionTypeThe BackupActionType enumeration contains values that are used to specify the type of backup.
Public enumerationBackupCompressionOptionsThe BackupCompressionOptions enumeration contains values that are used to specify the backup compression option.
Public enumerationBackupDeviceTypeThe BackupDeviceType enumeration contains values that are used to specify the backup device type.
Protected enumerationBackupRestoreBase.AsyncOperationThe BackupRestoreBase.AsyncOperation enumeration contains values that are used to specify which backup components are running asynchronously.
Public enumerationBackupSetFlagThe BackupSetFlag enumeration contains values that are used to specify the purpose of the backup.
Public enumerationBackupSetTypeThe BackupSetType enumeration contains values that are used to specify the backup type.
Public enumerationBackupTruncateLogTypeThe BackupTruncateLogType enumeration contains values that are used to specify the truncate action taken on the log.
Public enumerationCatalogPopulationActionThe CatalogPopulationAction enumeration contains values that are used to specify the method used to populate a full-text catalog.
Public enumerationCatalogPopulationStatusThe CatalogPopulationStatus enumeration contains values that are used to specify the status of the full-text catalog.
Public enumerationCertificateSourceTypeThe CertificateSourceType enumeration contains values that are used to specify the source of the certificate.
Public enumerationChangeTrackingThe ChangeTracking enumeration contains values that are used to specify change tracking in a full-text index.
Public enumerationCollationVersionThe CollationVersion enumeration contains values that specify the collation versions.
Public enumerationCompatibilityLevelThe CompatibilityLevel enumeration is a list of constant values that specify the behavior that corresponds to a version of SQL Server.
Public enumerationCreateDispositionTypeThe CreateDispositionType enumeration contains values that are used to specify the source of the symmetric key.
Public enumerationDatabaseDdlTriggerExecutionContextThe DatabaseDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the database DDL trigger runs.
Public enumerationDatabaseEncryptionAlgorithmSpecifies the algorithm used to encrypt the database encryption key
Public enumerationDatabaseEncryptionState
Public enumerationDatabaseEncryptionTypeThe DatabaseEncryptionType enumeration contains values that are used to specify the encryption types.
Public enumerationDatabaseEventTypeThe DatabaseEventType enumeration is a list of constant values that specify the database event type.
Public enumerationDatabaseObjectTypesThe DatabaseObjectTypes enumeration is a list of constant values that specifies the types of database object.
Public enumerationDatabasePermissionSetValueThe DatabasePermissionSetValue enumeration is a list of constant values that specify all the database permissions.
Public enumerationDatabaseStatusThe 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.
Public enumerationDatabaseUserAccessThe DatabaseUserAccess enumeration is a list of constant values that specify how user access can be restricted.
Public enumerationDataCompressionTypeThe DataCompressionType enumeration contains values that are used to specify the type of data compression used to store data on the physical partition.
Public enumerationDependencyTypeThe DependencyType enumeration is a list of constant values that specifies the direction of the dependency discovery operation.
Public enumerationDeviceTypeThe DeviceType enumeration is a list of constant values that specify the various different types of devices supported by SQL Server.
Public enumerationEditionThe Edition enumeration is a list of constant values that specify the various different types of devices that are supported by SQL Server.
Public enumerationEndpointAuthenticationOrderThe EndpointAuthenticationOrder enumeration contains values that are used to specify the authentication methods and order of preference for the endpoint connection.
Public enumerationEndpointEncryptionThe EndpointEncryption enumeration contains values that are used to specify the state of encryption on the endpoint.
Public enumerationEndpointEncryptionAlgorithmThe EndpointEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an endpoint.
Public enumerationEndpointStateThe EndpointState enumeration is a list of constant values that specifies the state of the HTTP endpoint.
Public enumerationEndpointTypeThe EndpointType enumeration is a list of constant values that specifies the type of HTTP endpoint.
Public enumerationEventTypeThe EventType enumeration is a list of constant values that specify the various different types of events that are supported by SQL Server.
Public enumerationExecutionContextThe 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.
Public enumerationExecutionStatusThe ExecutionStatus enumeration is a list of constant values that specify the status of an executing process.
Public enumerationFileGrowthTypeThe FileGrowthType enumeration is a list of constant values that specify whether file growth is determined by percentage amount or by KB.
Public enumerationFilestreamAccessLevelTypeThe FilestreamAccessLevelType enumeration contains values that are used to specify the type of access permitted on file stream operations.
Public enumerationFileStreamEffectiveLevelThe FileStreamEffectiveLevel enumeration contains values that are used to specify the file stream level.
Public enumerationFileStreamLevelThe FileStreamLevel enumeration contains values that are used to specify the file stream level.
Public enumerationForeignKeyActionThe 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.
Public enumerationFragmentationOptionThe FragmentationOption enumeration is a list of constant values that specify the levels of detail of collected fragmentation information.
Public enumerationFullTextCatalogUpgradeOptionThe FullTextCatalogUpgradeOption enumeration contains values that are used to specify the action taken when the full-text catalog is upgraded.
Public enumerationHttpAuthenticationModesThe HttpAuthenticationModes enumeration contains values that specify the HTTP port for HTTP endpoints.
Public enumerationHttpPortTypesThe HttpPortTypes enumeration contains values that are used to specify the type HTTP port.
Public enumerationImplementationTypeThe ImplementationType enumeration contains values that are used to specify the type of implementation for a stored procedure, a user-defined function, and other objects.
Public enumerationIndexEnableActionThe 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.
Public enumerationIndexKeyTypeThe IndexKeyType enumeration contains values that are used to specify the type of key on which the index is created.
Public enumerationIndexOperationThe IndexOperation enumeration contains values that are used to specify index operations.
Public enumerationIndexPopulationActionThe IndexPopulationAction enumeration contains values that are used to specify the type of Microsoft Search full-text index population.
Public enumerationIndexPopulationStatusThe IndexPopulationStatus enumeration contains values that are used to specify the type of population in progress.
Public enumerationInDoubtTransactionResolutionType
Public enumerationKeyEncryptionTypeThe KeyEncryptionType enumeration is a list of constant values that specify the key encryption type.
Public enumerationLinkedTableTypeThe LinkedTableType enumeration contains values that specify the type of table accessed on a linked server.
Public enumerationLinkFieldTypeThe LinkFieldType enumeration contains values that specify the type of link field.
Public enumerationLockEscalationTypeAn enumeration that lists lock escalation types.
Public enumerationLockRequestStatusThe LockRequestStatus enumeration contains constant values that specify the lock request status.
Public enumerationLoginCreateOptionsThe LoginCreateOptions enumeration contains values that are used to specify the password options when you create a logon.
Public enumerationLoginTypeThe LoginType enumeration contains values that are used to specify the authentication type and the Windows account type.
Public enumerationLogReuseWaitStatusThe LogReuseWaitStatus enumeration contains values that specify the current operation on which the reuse of transaction log space is waiting.
Public enumerationMappedClassType
Public enumerationMediaTypesThe 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.
Public enumerationMethodLoginTypeThe MethodLoginType enumeration contains values that are used to specify the method used for logging on to the instance of SQL Server.
Public enumerationMethodXsdSchemaOptionThe MethodXsdSchemaOption enumeration contains values that specify the XSD schema returned for a SOAP method.
Public enumerationMirroringOptionThe MirroringOption enumeration contains values that specify the mirroring options for a database.
Public enumerationMirroringRoleThe MirroringRole enumeration contains values that specify the role the database plays in mirroring.
Public enumerationMirroringSafetyLevelThe MirroringSafetyLevel enumeration contains values that specify the safety guarantee on updates to the mirrored database.
Public enumerationMirroringStatusThe MirroringStatus enumeration contains values that specify the state of a database regarding mirroring.
Public enumerationMirroringWitnessStatusThe MirroringWitnessStatus enumeration contains values that specify the state of the mirroring witness.
Public enumerationMonthThe Month enumeration contains constant values that specify the twelve calendar months.
Public enumerationNSActivationStateThe NSActivationState enumeration contains constant values that specify the activation state of Notification Services.
Public enumerationObjectClassThe ObjectClass enumeration contains values that specify the SMO class type.
Public enumerationObjectPermissionSetValueThe ObjectPermissionSetValue enumeration is a list of constant values that specify all the object permissions.
Public enumerationOnFailureActionThe OnFailureAction enumeration contains values that specify the action to be taken when an audit fails.
Public enumerationPageVerifyThe PageVerify enumeration contains constant values that specify the automatic page verification options for a database.
Public enumerationPerfMonModeThe PerfMonMode enumeration contains values that are used to specify the polling behavior in Performance Monitor.
Public enumerationPermissionStateThe PermissionState enumeration contains values that specify the state of a permission.
Public enumerationPlanGuideType
Public enumerationPrincipalTypeThe PrincipalType enumeration contains values that specify the type of user, role, or login.
Public enumerationPrivateKeyEncryptionTypeThe PrivateKeyEncryptionType enumeration contains values that are used to specify the encryption types for a private key associated with a certificate or an asymmetric key.
Public enumerationPrivilegeTypesThe PrivilegeTypes enumeration contains values that are used to specify the operations that the grantee can perform on the specified object when permission is granted.
Public enumerationProtocolTypeThe ProtocolType enumeration contains values that are used to specify the type of protocol.
Public enumerationProviderAuthenticationTypeSpecifies the type of authentication supported by Cryptographic Provider.
Public enumerationRangeTypeThe RangeType enumeration contains values that are used to specify the type range.
Public enumerationRecoveryModelThe RecoveryModel enumeration contains values that are used to specify the type of recovery model.
Public enumerationRepairOptionsThe RepairOptions enumeration contains values that are used to specify the repair options that are used when checking data in a table.
Public enumerationRepairStructureThe RepairRepairStructure enumeration contains values that are used to specify the type of repair options used when checking data in a table.
Public enumerationRepairTypeThe RepairType enumeration contains values that are used to specify the type of repair mode used by the database consistency check (DBCC) functions.
Public enumerationReplicationOptionsThe ReplicationOptions enumeration contains values that are used to specify the replication settings for the referenced database.
Public enumerationResourceUsageThe ResourceUsage enumeration contains values that specify the relative operating system execution priority setting for the Microsoft Search service.
Public enumerationRestoreActionTypeThe RestoreActionType enumeration contains values that are used to specify the type of action that is required during a data restore operation.
Public enumerationRestoreTypeThe RestoreType enumeration contains values that specify the type of restore operation to perform.
Public enumerationResultFormatThe ResultFormat enumeration contains values that specify the format in which to return results for an HTTP endpoint.
Public enumerationRetentionPeriodUnits
Public enumerationRoleTypesThe RoleTypes enumeration contains values that are used to specify the type of role.
Public enumerationSecondaryXmlIndexTypeThe SecondaryXmlIndexType enumeration contains values that are used to specify the secondary XML index type.
Public enumerationServerDdlTriggerExecutionContextThe ServerDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the server DDL trigger runs.
Public enumerationServerLoginModeThe ServerLoginMode enumeration contains values that are used to specify the method used to connect to the instance of SQL Server.
Public enumerationServerMirroringRoleThe ServerMirroringRole enumeration contains values that are used to specify the role of the instance of SQL Server when participating in mirroring.
Public enumerationServerPermissionSetValueThe ServerPermissionSetValue enumeration is a list of constant values that specify all the database permissions.
Public enumerationServerStatusThe ServerStatus enumeration contains values that are used to specify the status of the instance of SQL Server.
Public enumerationServerTypeThe ServerType enumeration contains values that are used to specify whether the server is part of a multi-server administration matrix.
Public enumerationServiceStartModeThe ServiceStartMode enumeration contains values that are used to specify the method that is used to start a service.
Public enumerationShrinkMethodThe ShrinkMethod enumeration contains values that are used to specify the method that is used shrink a database file.
Public enumerationSmoExceptionTypeThe SmoExceptionType enumeration contains values that are used to specify the type of SMO exception.
Public enumerationSnapshotIsolationStateThe SnapshotIsolationState enumeration contains values that are used to specify the current state of snapshot isolation.
Public enumerationSortOrderThe SortOrder enumeration contains values that specify how objects are sorted in an enumerated list.
Public enumerationSpatialGeoLevelSize
Public enumerationSpatialIndexType
Public enumerationSqlDataTypeThe SqlDataType enumeration contains values that are used to specify a SQL Server data type.
Public enumerationSqlServerVersionThe SqlServerVersion enumeration contains values that are used to specify the version of the referenced instance of SQL Server.
Public enumerationSqlServerVersionsThe SqlServerVersions enumeration contains values that are used to specify the version of the referenced instance of SQL Server.
Public enumerationSqlSmoStateThe SqlSmoState enumeration contains values that are used to specify the state of an SMO object.
Public enumerationSqlVerifyActionThe SqlVerifyAction enumeration contains values that are used to specify the type of backup verification.
Public enumerationStatisticsScanTypeThe 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.
Public enumerationStatisticsTargetThe StatisticsTarget enumeration contains values that specify the type of statistic that is targeted for the update operation.
Public enumerationStopListOptionThe StopListOption enumeration contains values that are used to specify the way in which a new stop list is created.
Public enumerationSymmetricKeyEncryptionAlgorithmThe SymmetricKeyEncryptionAlgorithm enumeration contains values that specify the algorithm that is used to encrypt the symmetric key.
Public enumerationSymmetricKeyEncryptionTypeThe SymmetricKeyEncryptionType enumeration contains constant values that specify the type of symmetric key encryption.
Public enumerationSynonymBaseTypeThe SynonymBaseType enumeration contains constant values that specify the type of synonym.
Public enumerationTerminationClauseThe TerminationClause enumeration contains constant values that specify the action taken when transactions are terminated.
Public enumerationTransactionTypesThe TransactionTypes enumeration contains constant values that specify the method of recording transactions.
Public enumerationUrnIdOption
Public enumerationUserDefinedFunctionTypeThe UserDefinedFunctionType enumeration is a list of constant values that specify the types of user-defined functions that are supported by SQL Server.
Public enumerationUserDefinedTypeFormatThe UserDefinedTypeFormat enumeration is a list of constant values that specify the formats used by user-defined types.
Public enumerationUserTypeThe UserType enumeration contains constant values that specify the security type for the user.
Public enumerationWindowsLoginAccessTypeThe WindowsLoginAccessType enumeration contains constant values that specify the type of access a Windows login has to the instance of SQL Server.
Public enumerationWorkloadGroupImportanceThe WorkloadGroupImportance enumeration contains values that specify the importance of workload groups.
Public enumerationWsdlGeneratorOptionThe WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.
Public enumerationXmlDocumentConstraintThe XmlDocumentConstraint enumeration contains constant values that specify the constraints imposed on an XML document.
Public enumerationXmlFormatOptionThe WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.
Public enumerationXmlTypeDerivationThe XmlTypeDerivation enumeration contains constant values that specify the XML type derivation.
Public enumerationXmlTypeKindThe XmlTypeKind enumeration contains constant values that specify the kind of XML component.
Public enumerationXsdSchemaOptionThe XsdSchemaOption enumeration contains constant values that specify whether an inline schema for the method result is returned in the SOAP response.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.