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 (Datenbankmodul) 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.

Klassen

  Klasse Beschreibung
Öffentliche Klasse AbstractCollectionBase The AbstractCollectionBase object is a base class object that is used in the construction of collection objects.
Öffentliche Klasse ApplicationRole The ApplicationRole object represents a security role that is used to set access privileges from an application regardless of the user's permissions.
Öffentliche Klasse ApplicationRoleCollection The ApplicationRoleCollectionclass represents a collection of ApplicationRole objects that represent all the application roles on the referenced database.
Öffentliche Klasse ApplicationRoleEvents The ApplicationRoleEvents object represents the settings required for Microsoft SQL Server application role event notification.
Öffentliche Klasse ArrayListCollectionBase The ArrayListCollectionBase object represents a base class that is used in the construction of collections that are based on array lists.
Öffentliche Klasse AsymmetricKey The AsymmetricKey object represents a SQL Server asymmetric key.
Öffentliche Klasse AsymmetricKeyCollection The AsymmetricKeyCollection class represents a collection of AsymmetricKey objects that represent all the asymmetric keys on the referenced database.
Öffentliche Klasse AsyncStatus The AsyncStatus object represents the status of an asynchronous process.
Öffentliche Klasse Audit The Audit object represents a SQL Server audit log.
Öffentliche Klasse AuditCollection The AuditCollection class represents a collection of Audit objects that represent all the audits on the instance of SQL Server.
Öffentliche Klasse AuditExtender Adds methods and properties to the Audit object.
Öffentliche Klasse AuditSpecification The Column object represents a SQL Server column.
Öffentliche Klasse Backup The Backup object provides programmatic access to Microsoft SQL Server backup operations.
Öffentliche Klasse BackupDevice The BackupDevice object provides programmatic access to SQL Server backup devices.
Öffentliche Klasse BackupDeviceCollection The BackupDeviceCollection class represents a collection of BackupDevice objects that represent all the backup devices on an instance of SQL Server.
Öffentliche Klasse BackupDeviceItem The BackupDeviceItem object provides programmatic access to named SQL Server backup devices.
Öffentliche Klasse BackupDeviceList The BackupDeviceList object provides programmatic access to a list backup devices.
Öffentliche Klasse BackupRestoreBase The BackupRestoreBase class is a base class that represents functionality that is common to both backup and restore operations.
Öffentliche Klasse Certificate The Certificate object represents a SQL Server certificate.
Öffentliche Klasse CertificateCollection The CertificateCollection class represents a collection of Certificate objects that represent all the certificates on an instance of SQL Server.
Öffentliche Klasse CertificateEvents The CertificateEvents object represents the settings that are required for SQL Server Certificate event notification.
Öffentliche Klasse Check The Check object represents a Microsoft SQL Server check constraint.
Öffentliche Klasse CheckCollection The CheckCollection class represents a collection of Check objects that represent all the check constraints defined on the parent object.
Öffentliche Klasse CollectionNotAvailableException The CollectionNotAvailableException class is an exception that is raised when an attempt is made to retrieve a collection that is not available.
Öffentliche Klasse Column The Column object represents a SQL Server column.
Öffentliche Klasse ColumnCollection The ColumnCollection class represents a collection of Column objects that represent all the columns defined on a table.
Öffentliche Klasse ConfigProperty The ConfigProperty object contains information pertaining to a Microsoft SQL Server configuration option, such as maximum, minimum, current, and new values.
Öffentliche Klasse ConfigPropertyCollection The ConfigPropertyCollection class represents a collection of ConfigProperty objects that represent all the configuration properties defined on the instance of SQL Server.
Öffentliche Klasse Configuration The Configuration class contains the configuration information for the instance of SQL Server.
Öffentliche Klasse ConfigurationBase The ConfigurationBase class is a base class that represents configuration information for the instance of SQL Server.
Öffentliche Klasse Credential The Credential object represents a Microsoft SQL Server credential.
Öffentliche Klasse CredentialCollection The CredentialCollection class represents a collection of Credential objects that represent all the credentials defined on the instance of Microsoft SQL Server.
Öffentliche Klasse CryptographicProvider The CryptographicProvider object represents a SQL Server cryptographic provider.
Öffentliche Klasse CryptographicProviderCollection A collection of type CryptographicProviderCollection that represents a collection of CryptographicProviderr objects.
Öffentliche Klasse Database The Database object represents a SQL Server database.
Öffentliche Klasse DatabaseActiveDirectory The DatabaseActiveDirectory object provides programmatic access to the Active Directory settings for a database.
Öffentliche Klasse DatabaseAdapter Database Adapter type to be used as a management facet.
Öffentliche Klasse DatabaseAdapterBase Database adapter base.
Öffentliche Klasse DatabaseAuditSpecification The DatabaseAuditSpecification object represents an auditable event on the database.
Öffentliche Klasse DatabaseAuditSpecificationCollection The DatabaseAuditSpecificationCollection class represents a collection of DatabaseAuditSpecification objects that represent all the audit specifications defined on the database.
Öffentliche Klasse DatabaseAuditSpecificationExtender Adds methods and properties to the DatabaseAuditSpecification object.
Öffentliche Klasse DatabaseCollection The DatabaseCollection class represents a collection of Database objects that represent all the databases defined on the instance of SQL Server.
Öffentliche Klasse DatabaseDdlTrigger The DatabaseDdlTrigger object represents a SQL Server database data definition language (DDL) trigger.
Öffentliche Klasse DatabaseDdlTriggerCollection The DatabaseDdlTriggerCollection class represents a collection of DatabaseDdlTrigger objects that represent all the database data definition language (DDL) triggers defined on a table.
Öffentliche Klasse DatabaseDdlTriggerEvent The DatabaseDdlTriggerEvent object represents the SQL Server database DDL trigger events that can be included in a database DDL trigger event set.
Öffentliche Klasse DatabaseDdlTriggerEventSet The DatabaseDdlTriggerEventSet object represents a set of SQL Server database data definition language (DDL) trigger events.
Öffentliche Klasse DatabaseEncryptionKey Creates a database encryption key.
Öffentliche Klasse DatabaseEncryptionKeyExtender Extends the database encryption key class.
Öffentliche Klasse DatabaseEvent The DatabaseEvent object represents the SQL Server database events that can be included in a database event set.
Öffentliche Klasse DatabaseEventArgs The DatabaseEventArgs object represents the arguments passed by the event raised by the database.
Öffentliche Klasse DatabaseEvents The DatabaseEvents object represents the settings required for Microsoft SQL Server database event notification.
Öffentliche Klasse DatabaseEventSet The DatabaseEventSet object represents a SQL Server set of database events.
Öffentliche Klasse DatabaseFile The DatabaseFile object is a base class used in the construction of DataFile objects and LogFile objects.
Öffentliche Klasse DatabaseFileMappingsDictionary This class, which is inherited from Dictionary, maps database file paths from the source server to the corresponding target server location that the user specifies.
Öffentliche Klasse DatabaseMaintenanceAdapter The Database Maintenance facet has logical properties. It inherits from the DatabaseAdapter class.
Öffentliche Klasse DatabaseMapping The DatabaseMapping object represents a SQL Server database mapping.
Öffentliche Klasse DatabaseMirroringPayload The DatabaseMirroringPayload object represents database mirroring payload settings.
Öffentliche Klasse DatabaseOptions The DatabaseOptions object represents SQL Server database options.
Öffentliche Klasse DatabasePerformanceAdapter The Database Performance facet implements logical properties relevant to database performance management.
Öffentliche Klasse DatabasePermission The 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.
Öffentliche Klasse DatabasePermissionInfo The DatabasePermissionInfo object represents information about a SQL Server database permission.
Öffentliche Klasse DatabasePermissionSet The DatabasePermissionSet object represents a SQL Server set of database permissions.
Öffentliche Klasse DatabaseRole The DatabaseRole object represents a SQL Server database security role.
Öffentliche Klasse DatabaseRoleCollection The DatabaseRoleCollection class represents a collection of DatabaseRole objects that represent all the database roles defined on the parent database.
Öffentliche Klasse DatabaseSecurityAdapter Includes properties and methods that are used to expose the Database Security facet.
Öffentliche Klasse DatabaseSnapshotExtender Adds methods and properties to the DatabaseSnapshot object.
Öffentliche Klasse DataFile The DataFile object represents a Microsoft SQL Server data file.
Öffentliche Klasse DataFileCollection The DataFileCollection class represents a collection of DataFile objects that represent all the data files defined on the parent object.
Öffentliche Klasse DataType The DataType object represents a SQL Server data type.
Öffentliche Klasse DdlTriggerBase The DdlTriggerBase is a base class that is inherited by the DatabaseDdlTrigger object. This represents a SQL Server database data definition language (DDL) trigger.
Öffentliche Klasse Default The Default object represents a Microsoft SQL Server default.
Öffentliche Klasse DefaultCollection The DefaultCollection class represents a collection of Default objects.
Öffentliche Klasse DefaultConstraint The DefaultConstraint object represents a SQL Server default constraint.
Öffentliche Klasse DefaultRuleBase The DefaultRuleBase class is a base class that is inherited by the Rule class and the Default class.
Öffentliche Klasse DependencyCollection The DependencyCollection class represents a collection of Dependency objects that are used to derive the node classes in SMO scripting operations.
Öffentliche Klasse DependencyCollectionNode The DependencyCollectionNode class represents a node in the dependency collection that is derived during scripting operations.
Öffentliche Klasse DependencyNode The DependencyNode class represents a node that is defined by a URN address.
Öffentliche Klasse DependencyTree The DependencyTree object represents a tree structure that contains SQL Server objects and their hierarchical relationships to each other.
Öffentliche Klasse DependencyTreeNode The DependencyTreeNode class represents the child and sibling SQL Server objects within a DependencyTree object hierarchy.
Öffentliche Klasse DependencyWalker The 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.
Öffentliche Klasse Endpoint The Endpoint class represents an endpoint service that can listen natively for requests.
Öffentliche Klasse EndpointCollection The EndpointCollection class represents a collection of Endpoint objects that represent all the HTTP endpoints.
Öffentliche Klasse EndpointPayload The EndpointPayload object represents an endpoint payload.
Öffentliche Klasse EndpointProtocol The EndpointProtocol object represents an HTTP endpoint protocol.
Öffentliche Klasse EventProperty The EventProperty class represents a property of an event.
Öffentliche Klasse EventPropertyCollection The EventPropertyCollection object represents the properties of event objects.
Öffentliche Klasse EventSetBase The EventSetBase class is a base class that is used to derive the event set objects.
Öffentliche Klasse ExtendedProperty The ExtendedProperty object represents the extended properties that are defined for any object that has an ExtendedProperties collection property.
Öffentliche Klasse ExtendedPropertyCollection The ExtendedPropertyCollection class represents a collection of ExtendedPropertyCollectionobjects that represent all the extended properties.
Öffentliche Klasse ExtendedStoredProcedure The ExtendedStoredProcedure object represents an extended stored procedure on the instance of Microsoft SQL Server.
Öffentliche Klasse ExtendedStoredProcedureCollection The ExtendedStoredProcedureCollection class represents a collection of ExtendedStoredProcedure objects that represent all the extended stored procedures defined on the parent database.
Öffentliche Klasse FailedOperationException The FailedOperationException class represents the exception raised when an operation fails.
Öffentliche Klasse FileGroup The FileGroup object represents a SQL Server file group.
Öffentliche Klasse FileGroupCollection The FileGroupCollection class represents a collection of FileGroup objects that represent all the filegroups defined on the parent database.
Öffentliche Klasse ForeignKey The ForeignKey object represents a SQL Server foreign key.
Öffentliche Klasse ForeignKeyCollection The ForeignKeyCollection class represents a collection of ForeignKey objects that represent all the foreign keys defined on the parent object.
Öffentliche Klasse ForeignKeyColumn The ForeignKeyColumn object represents a SQL Server foreign key column.
Öffentliche Klasse ForeignKeyColumnCollection The ForeignKeyColumnCollection class represents a collection of ForeignKeyColumn objects that represent all the foreign key columns defined on the parent object.
Öffentliche Klasse FrequencyPair The FrequencyPair object is a utility that measures frequency by storing count and duration information.
Öffentliche Klasse FullTextCatalog The FullTextCatalog object represents a Microsoft Search full-text catalog.
Öffentliche Klasse FullTextCatalogCollection The FullTextCatalogCollection class represents a collection of FullTextCatalog objects that represent all the full-text catalogs defined on the parent object.
Öffentliche Klasse FullTextIndex The FullTextIndex object represents a Microsoft Search full-text index.
Öffentliche Klasse FullTextIndexColumn The FullTextIndexColumn object represents a Microsoft Search full-text index column.
Öffentliche Klasse FullTextIndexColumnCollection The FullTextIndexColumnCollection class represents a collection of FullTextIndexColumn objects that represent all the full-text index columns defined on the parent object.
Öffentliche Klasse FullTextService The FullTextService object allows programmatic access to the Microsoft Search full-text settings.
Öffentliche Klasse FullTextStopList The FullTextStopList object represents a full-text stop list.
Öffentliche Klasse FullTextStopListCollection The FullTextStopListCollection class represents a collection of FullTextStopList objects that represent all the full-text stop lists that are defined on the parent database.
Öffentliche Klasse HttpProtocol The HttpProtocol object represents an HTTP protocol on an instance of Microsoft SQL Server.
Öffentliche Klasse Index The Index object represents a SQL Server index.
Öffentliche Klasse IndexCollection The IndexCollection class represents a collection of Index objects that represent all the indexes defined on the instance of SQL Server.
Öffentliche Klasse IndexedColumn The IndexedColumn object represents a SQL Server column that is participating in an index.
Öffentliche Klasse IndexedColumnCollection The IndexedColumnCollection class represents a collection of IndexedColumn objects that represent all the indexed columns defined on the instance of SQL Server.
Öffentliche Klasse IndexEvents The IndexEvents object represents the settings that are required for SQL Server index event notification.
Öffentliche Klasse Information The 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.
Öffentliche Klasse InternalSmoErrorException The InternalSmoErrorException class represents the exception raised when an error occurs during the internal phase of a SMO operation.
Öffentliche Klasse InvalidSmoOperationException The InvalidSmoOperationException class represents the exception raised when an SMO operation is not valid.
Öffentliche Klasse InvalidVersionSmoOperationException The InvalidVersionSmoOperationException class represents the exception raised when the version is not valid on an SMO operation.
Öffentliche Klasse JobScheduleCollectionBase The JobScheduleCollectionBase class represents a base class that is used in the construction of the JobScheduleCollection class.
Öffentliche Klasse Language A 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.
Öffentliche Klasse LanguageCollection The LanguageCollection class represents a collection of Language objects that represent all the languages which are defined on the instance of SQL Server.
Öffentliche Klasse LinkedServer A 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.
Öffentliche Klasse LinkedServerCollection The LinkedServerCollection class represents a collection of LinkedServer objects that represent all the linked servers registered on the instance of SQL Server.
Öffentliche Klasse LinkedServerLogin The LinkedServerLogin object represents a SQL Server logon account that has permission to connect to the linked server.
Öffentliche Klasse LinkedServerLoginCollection The LinkedServerLoginCollection class represents a collection of LinkedServerLogin objects that represent all the linked server logins defined on the linked server.
Öffentliche Klasse LogFile The LogFile object represents a SQL Server log file.
Öffentliche Klasse LogFileCollection The LogFileCollection class represents a collection of LogFile objects that represent all the log files defined on the instance of Microsoft SQL Server.
Öffentliche Klasse Login The 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.
Öffentliche Klasse LoginCollection The LoginCollection class represents a collection of Login objects that represent all the login accounts defined on the instance of SQL Server.
Öffentliche Klasse LoginEvents The LoginEvents object represents the settings required for SQL Server login event notification.
Öffentliche Klasse MasterKey The MasterKey object represents a SQL Server database master key.
Öffentliche Klasse MessageCollectionBase The MessageCollectionBase class is a base class that is used in the construction of message collection classes.
Öffentliche Klasse MessageObjectBase The MessageObjectBase class is a base class that is inherited by message classes.
Öffentliche Klasse MissingObjectException The MissingObjectException class represents the exception raised when an object is missing.
Öffentliche Klasse NamedSmoObject The NamedSmoObject object represents a named SMO object.
Öffentliche Klasse NumberedObjectCollectionBase The NumberedObjectCollectionBase class is a base class that represents common functionality for collections of numbered objects, such as the NumberedStoredProcedure object.
Öffentliche Klasse NumberedStoredProcedure The NumberedStoredProcedure class represents a Microsoft SQL Server numbered stored procedure.
Öffentliche Klasse NumberedStoredProcedureCollection The NumberedStoredProcedureCollection class represents a collection of NumberedStoredProcedure objects that represent all the numbered stored procedures defined on a table.
Öffentliche Klasse NumberedStoredProcedureParameter The NumberedStoredProcedureParameter object represents a SQL Server numbered stored procedure parameter.
Öffentliche Klasse NumberedStoredProcedureParameterCollection
Öffentliche Klasse ObjectAlteredEventArgs The ObjectAlteredEventArgs object represents the arguments that are passed by the event that is raised when an object is altered.
Öffentliche Klasse ObjectCreatedEventArgs The ObjectCreatedEventArgs object represents the arguments that are passed by the event that is raised when an object is created.
Öffentliche Klasse ObjectDroppedEventArgs The ObjectDroppedEventArgs object represents the arguments that are passed by the event that is raised when an object is dropped.
Öffentliche Klasse ObjectEvent The ObjectEvent object represents the of SQL Server object events that can be included in an object event set.
Öffentliche Klasse ObjectEventSet The ObjectEventSet object represents a SQL Server set of object events.
Öffentliche Klasse ObjectPermission The ObjectPermission object represents a SQL Server object permission.
Öffentliche Klasse ObjectPermissionInfo The ObjectPermissionInfo object represents information about a SQL Server object permission.
Öffentliche Klasse ObjectPermissionSet The ObjectPermissionSet object represents a set of object permissions in Microsoft SQL Server.
Öffentliche Klasse ObjectRenamedEventArgs The ObjectRenamedEventArgs object represents the arguments passed by the event raised when an object is renamed.
Öffentliche Klasse OleDbProviderSettings The OleDbProviderSettings object represents the setting for a SQL Server OLE DB provider.
Öffentliche Klasse OleDbProviderSettingsCollection The OleDbProviderSettingsCollection class represents a collection of OleDbProviderSettings objects that represent all the OLE DB provider settings defined on the linked server.
Öffentliche Klasse OrderColumn OrderColumn 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.
Öffentliche Klasse OrderColumnCollection Represents a collection of OrderColumn.
Öffentliche Klasse 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.
Öffentliche Klasse ParameterBase The ParameterBase class is a base class that is inherited by the Parameter class and the UserDefinedAggregate class. It contains common features of both classes.
Öffentliche Klasse ParameterCollectionBase The ParameterCollectionBase class is a base class that is used in the construction of parameter collection classes.
Öffentliche Klasse PartitionFunction The PartitionFunction object provides programmatic access to partition functions.
Öffentliche Klasse PartitionFunctionCollection The PartitionFunctionCollection class represents a collection of PartitionFunction objects that represent all the partition functions defined on the instance of SQL Server.
Öffentliche Klasse PartitionFunctionEvents The PartitionFunctionEvents object represents the settings required for SQL Server partition function event notification.
Öffentliche Klasse PartitionFunctionParameter The PartitionFunctionParameter object provides programmatic access to partition function parameters.
Öffentliche Klasse PartitionFunctionParameterCollection The PartitionFunctionParameterCollection class represents a collection of PartitionFunctionParameter objects that represent all the partition function parameters defined on the partition function.
Öffentliche Klasse PartitionNumberedObjectCollectionBase The PartitionNumberedObjectCollectionBase is a base class that is inherited by the PhysicalPartitionCollection class.
Öffentliche Klasse PartitionScheme The PartitionScheme object provides programmatic access to partition schemes.
Öffentliche Klasse PartitionSchemeCollection The PartitionSchemeCollection class represents a collection of PartitionScheme objects that represent all the partition schemes defined on the instance of SQL Server.
Öffentliche Klasse PartitionSchemeEvents The PartitionSchemeEvents object represents the settings required for Microsoft SQL Server partition scheme event notification.
Öffentliche Klasse PartitionSchemeParameter The PartitionSchemeParameter object provides programmatic access to partition scheme parameters.
Öffentliche Klasse PartitionSchemeParameterCollection The PartitionSchemeParameterCollection class represents a collection of PartitionSchemeParameter objects that represent all the partition scheme parameters defined on the partition scheme.
Öffentliche Klasse Payload The Payload object represents a SQL Server HTTP endpoint payload.
Öffentliche Klasse PercentCompleteEventArgs The PercentCompleteEventArgs object represents the arguments passed by the event raised when a process reaches a percent complete marker.
Öffentliche Klasse PerformanceCounters A PerformanceCounters object represents a performance counter that is used to trace the performance of the instance of SQL Server.
Öffentliche Klasse PermissionInfo The PermissionInfo class represents information regarding granted or denied privileges.
Öffentliche Klasse PermissionSetBase The PermissionSetBase class is a base class that is inherited by permission set classes.
Öffentliche Klasse PhysicalPartition The PhysicalPartition object represents the physical partition where the data and meta data is stored for a SQL Server object.
Öffentliche Klasse PhysicalPartitionCollection The PhysicalPartitionCollection class represents a collection of PhysicalPartition objects that represent all the physical partitions that are defined on an object.
Öffentliche Klasse PlanGuide Creates a plan guide object: PlanGuide
Öffentliche Klasse PlanGuideCollection Collection of plan guide objects.
Öffentliche Klasse PlanGuideExtender Extends the Property set for a Plan Guide
Öffentliche Klasse 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.
Öffentliche Klasse Property The Property object provides programmatic access to the properties of all the SMO objects.
Öffentliche Klasse PropertyCannotBeRetrievedException The PropertyCannotBeRetrievedException class represents the exception raised when a property cannot be retrieved.
Öffentliche Klasse PropertyCollection The PropertyCollection class represents a collection of Property objects that represent all the properties defined on the parent object.
Öffentliche Klasse PropertyNotSetException The PropertyNotSetException class represents the exception that is raised when a property value has not been set.
Öffentliche Klasse PropertyReadOnlyException The PropertyReadOnlyException class represents the exception that is raised when an attempt is made to set a read-only property.
Öffentliche Klasse 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.
Öffentliche Klasse PropertyWriteException The PropertyWriteException class represents the exception that is raised when an error occurs when setting the value of a property.
Öffentliche Klasse Protocol The Protocol object provides programmatic access to the protocols supported by SQL Server.
Öffentliche Klasse RelocateFile The RelocateFile object is a programmatic tool that lets a file be relocated.
Öffentliche Klasse ResourceGovernor ResourceGovernor class.
Öffentliche Klasse ResourcePool Resource Pool Class
Öffentliche Klasse ResourcePoolCollection Represents a collection of Resource Pools.
Öffentliche Klasse Restore The Restore object provides programmatic access to restore operations.
Öffentliche Klasse Rule The Rule object provides programmatic access to a SQL Server rule.
Öffentliche Klasse RuleCollection The RuleCollection class represents a collection of Rule objects that represent all the rules defined on the instance of SQL Server.
Öffentliche Klasse Schema The Schema object represents an ownership context for a SQL Server database object.
Öffentliche Klasse SchemaCollection The SchemaCollection class represents a collection of Schema objects that represent all the schemas on the referenced database.
Öffentliche Klasse SchemaCollectionBase The SchemaCollectionBase class is a base class that is inherited by the SchemaCollection class.
Öffentliche Klasse SchemaEvents The SchemaEvents object represents the settings required for SQL Server schema event notification.
Öffentliche Klasse Scripter The Scripter object is the overall, top-level object for managing scripting operations.
Öffentliche Klasse ScriptingErrorEventArgs The ScriptingErrorEventArgs object provides programmatic access to the arguments used to report the errors that occur during scripting operations.
Öffentliche Klasse ScriptingOptions The ScriptingOptions object provides programmatic options to the options that can be set for scripting operations.
Öffentliche Klasse ScriptNameObjectBase The ScriptNameObjectBase is a base class that is inherited by classes that can use an alternative name that is used in scripting operations.
Öffentliche Klasse ScriptOption The ScriptOption object represents the SQL Server script options that can be included in scripting options that are set by using the ScriptingOptions object.
Öffentliche Klasse ScriptSchemaObjectBase The ScriptSchemaObjectBase is a base class that is inherited by classes that can use an alternative name used in scripting operations.
Öffentliche Klasse Server The Server object represents an instance of SQL Server.
Öffentliche Klasse ServerActiveDirectory The ServerActiveDirectory object provides programmatic access to the Active Directory functionality.
Öffentliche Klasse ServerAdapter This class aggregates otherwise hidden server properties.
Öffentliche Klasse ServerAdapterBase A ServerAdapterBase object is a base class that is used in the construction of the ServerAdapter class.
Öffentliche Klasse ServerAuditSpecification The ServerAuditSpecification object represents an auditable event on the instance of SQL Server.
Öffentliche Klasse ServerAuditSpecificationCollection The ServerAuditSpecificationCollection class represents a collection of ServerAuditSpecification objects that represent all the audit specifications defined on the server.
Öffentliche Klasse ServerAuditSpecificationExtender Adds methods and properties to the ServerAuditSpecification object.
Öffentliche Klasse ServerConfigurationAdapter
Öffentliche Klasse ServerDdlTrigger The ServerDdlTrigger object represents a SQL Server data definition language (DDL) trigger.
Öffentliche Klasse ServerDdlTriggerCollection The ServerDdlTriggerCollection class represents a collection of ServerDdlTrigger objects that represent all the server data definition language (DDL) triggers defined on a table.
Öffentliche Klasse 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.
Öffentliche Klasse ServerDdlTriggerEventSet The ServerDdlTriggerEventSet object represents a set of SQL Server server data definition language (DDL) trigger events.
Öffentliche Klasse ServerEvent The ServerEvent object represents the SQL Server server events that can be included in a server event set.
Öffentliche Klasse ServerEventArgs The 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.
Öffentliche Klasse ServerEvents The ServerEvents object represents the settings required for SQL Server server-level event notification.
Öffentliche Klasse ServerEventSet The ServerEventSet object represents a set of server events on an instance of SQL Server.
Öffentliche Klasse ServerPermission The ServerPermission object represents a SQL Server server-level permission.
Öffentliche Klasse ServerPermissionInfo The ServerPermissionInfo object represents information about a SQL Server server-level permission.
Öffentliche Klasse ServerPermissionSet The ServerPermissionSet object represents a set of server permissions.
Öffentliche Klasse ServerProxyAccount The 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.
Öffentliche Klasse ServerRole The ServerRole object represents a Microsoft SQL Server security role.
Öffentliche Klasse ServerRoleCollection The ServerRoleCollection class represents a collection of ServerRole objects that represent all the server roles that are defined on a table.
Öffentliche Klasse ServerSecurityAdapter A security facet that extends ServerAdapterBase.
Öffentliche Klasse ServerSetupAdapter A ServerSetupAdapter object represents a server setup adapter.
Öffentliche Klasse ServerSurfaceAreaAdapter A ServerSurfaceAreaAdapter object represents a server surface area adapter.
Öffentliche Klasse ServerTraceEvent The ServerTraceEvent object represents the SQL Server server trace events that can be included in a server trace event set.
Öffentliche Klasse ServerTraceEventSet The ServerTraceEventSet object represents a set server trace events.
Öffentliche Klasse ServiceBrokerPayload The ServiceBrokerPayload object represents a SQL Server Service Broker payload.
Öffentliche Klasse ServiceMasterKey The ServiceMasterKey object represents a Microsoft SQL Server service master key.
Öffentliche Klasse ServiceQueueEvent The ServiceQueueEvent object represents the Service Broker service queue events that can be included in a service queue event set.
Öffentliche Klasse ServiceQueueEventSet The ServiceQueueEventSet object represents a set of SQL Server service queue events.
Öffentliche Klasse ServiceRequestException The ServiceRequestException class represents the exception that is raised when an error occurs during a service request.
Öffentliche Klasse Settings The Settings object represents a group of configurable settings on the instance of SQL Server.
Öffentliche Klasse SimpleObjectCollectionBase The SimpleObjectCollectionBase class is a base class that is used in the construction of collection objects.
Öffentliche Klasse SmoApplication The SmoApplication class represents an SMO application with respect to event management.
Öffentliche Klasse SmoCollectionBase The SmoCollectionBase class is a base class that is used in the construction of SMO collection classes and contains members that are common to them.
Öffentliche Klasse SmoDmfAdapter Implements Evaluate(IBaseManagementFacet)
Öffentliche Klasse SmoEventArgs The SmoEventArgs object provides programmatic access to the arguments used to report the events that occur in SMO applications.
Öffentliche Klasse SmoException The SmoException class represents the exception that is raised when an error occurs during an SMO operation.
Öffentliche Klasse SmoObjectBase The SmoObjectBase is a base class that is inherited by the SqlSmoObject class.
Öffentliche Klasse SmoObjectExtender< (Of < ( <'T> ) > ) >
Öffentliche Klasse 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.
Öffentliche Klasse SoapMethodObject The SoapMethodObject class provides programmatic access to the referenced SOAP method.
Öffentliche Klasse SoapPayload The SoapPayload object represents a SQL Server SOAP payload.
Öffentliche Klasse SoapPayloadMethod The SoapPayloadMethod class represents a SOAP payload method for the referenced HTTP endpoint.
Öffentliche Klasse SoapPayloadMethodCollection The SoapPayloadMethodCollection class represents a collection of SoapPayloadMethod objects that represent all the SOAP payload methods defined on a table.
Öffentliche Klasse SortedListCollectionBase The SortedListCollectionBase class is a base class that is used in the construction of sorted list collection classes.
Öffentliche Klasse SqlAssembly The SqlAssembly class represents an assembly in the Microsoft .NET environment.
Öffentliche Klasse SqlAssemblyCollection The SqlAssemblyCollection class represents a collection of SqlAssembly objects that represent all the assemblies defined on a table.
Öffentliche Klasse SqlAssemblyEvent The SqlAssemblyEvent object represents the SQL Server assembly events that can be included in an assembly event set.
Öffentliche Klasse SqlAssemblyEvents The SqlAssemblyEvents object represents the settings that are required for SQL Server assembly event notification.
Öffentliche Klasse SqlAssemblyEventSet The SqlAssemblyEventSet object represents a set of assembly events.
Öffentliche Klasse SqlAssemblyFile The SqlAssemblyFile object represents an assembly file that stores an assembly.
Öffentliche Klasse SqlAssemblyFileCollection The SqlAssemblyFileCollection class represents a collection of SqlAssemblyFile objects that represent all the assembly files that are defined on a table.
Öffentliche Klasse SqlPropertyCollection The SqlPropertyCollection class is an abstract class that is used in the management of object properties.
Öffentliche Klasse SqlPropertyInfo The SqlPropertyInfo class is an abstract class used to store information about properties.
Öffentliche Klasse SqlServerRegistrations Veraltet. Represents registered instances of SQL Server.
Öffentliche Klasse SqlSmoObject The SqlSmoObject object represents all SQL Server objects.
Öffentliche Klasse Statistic The Statistic class represents a SQL Server statistic counter.
Öffentliche Klasse StatisticCollection The StatisticCollection class represents a collection of Statistic objects that represent all the statistic counters defined on the table or view.
Öffentliche Klasse StatisticColumn The StatisticColumn object represents a column defined in a SQL Server statistics counter.
Öffentliche Klasse StatisticColumnCollection The StatisticColumnCollection class represents a collection of StatisticColumn objects that represent all the statistic columns defined on a table.
Öffentliche Klasse StatisticEvents The StatisticEvents object represents the settings required for SQL Server statistic counter event notification.
Öffentliche Klasse StoredProcedure The StoredProcedure object represents a SQL Server stored procedure.
Öffentliche Klasse StoredProcedureCollection The StoredProcedureCollection class represents a collection of StoredProcedure objects that represent all the stored procedures that are defined on a table.
Öffentliche Klasse StoredProcedureEvent The StoredProcedureEvent object represents the SQL Server stored procedure events that can be included in an stored procedure event set.
Öffentliche Klasse StoredProcedureEvents The StoredProcedureEvents object represents the settings that are required for SQL Server stored procedure event notification.
Öffentliche Klasse StoredProcedureEventSet The StoredProcedureEventSet object represents a set of stored procedure events.
Öffentliche Klasse StoredProcedureParameter The StoredProcedureParameter object represents a SQL Server stored procedure parameter.
Öffentliche Klasse StoredProcedureParameterCollection The StoredProcedureParameterCollection class represents a collection of StoredProcedureParameter objects that represent all the stored procedure parameters defined on a table.
Öffentliche Klasse SymmetricKey The SymmetricKey object represents a SQL Server symmetric key.
Öffentliche Klasse SymmetricKeyCollection The SymmetricKeyCollection class represents a collection of SymmetricKey objects that represent all the symmetric keys on the referenced database.
Öffentliche Klasse SymmetricKeyEncryption The SymmetricKeyEncryption class represents the encryption type used when encrypting symmetric keys.
Öffentliche Klasse Synonym The Synonym object represents a SQL Server synonym.
Öffentliche Klasse SynonymCollection The SynonymCollection class represents a collection of Synonym objects that represent all the synonyms on the referenced database.
Öffentliche Klasse SynonymEvents The SynonymEvents object represents the settings that are required for SQL Server synonym event notification.
Öffentliche Klasse SystemDataType The SystemDataType object represents a supported system data type. The SystemDataTypeCollection represents all the supported system data types.
Öffentliche Klasse SystemDataTypeCollection The SystemDataTypeCollection class represents a collection of SystemDataType objects that represent all the system data types on the referenced database.
Öffentliche Klasse SystemMessage The SystemMessage object represents messages defined by the system.
Öffentliche Klasse SystemMessageCollection The SystemMessageCollection class represents a collection of SystemMessage objects that represent all the system messages on the instance of SQL Server.
Öffentliche Klasse Table The Table object represents a SQL Server table.
Öffentliche Klasse TableCollection The TableCollection class represents a collection of Table objects that represent all the tables on the referenced database.
Öffentliche Klasse TableEvent The TableEvent object represents the SQL Server table events that can be included in a table event set.
Öffentliche Klasse TableEvents The TableEvents object represents the settings required for SQL Server table event notification.
Öffentliche Klasse TableEventSet The TableEventSet object represents a set of table events.
Öffentliche Klasse TableViewBase The 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.
Öffentliche Klasse TableViewTableTypeBase Base class for table view types.
Öffentliche Klasse TcpProtocol The TcpProtocol object provides programmatic access to the protocols supported by Microsoft SQL Server.
Öffentliche Klasse Transfer The Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.
Öffentliche Klasse Trigger The Trigger object represents a SQL Server trigger.
Öffentliche Klasse TriggerCollection The TriggerCollection class represents a collection of Trigger objects that represent all the triggers defined on a table.
Öffentliche Klasse TriggerEvents The TriggerEvents object represents the settings that are required for SQL Server trigger event notification.
Öffentliche Klasse UnknownPropertyException The UnknownPropertyException class represents the exception that is raised when an SMO operation encounters an unknown property.
Öffentliche Klasse UnsupportedFeatureException The UnsupportedFeatureException class represents the exception raised when an SMO operation encounters a request for an unsupported feature.
Öffentliche Klasse UnsupportedObjectNameException The UnsupportedObjectNameException class represents the exception that is raised when an SMO operation encounters an unsupported object name.
Öffentliche Klasse UnsupportedVersionException The UnsupportedVersionException class represents the exception raised when an SMO operation encounters an unsupported version of SQL Server.
Öffentliche Klasse UrnCollection The UrnCollection class represents a collection of Urn objects that represent Uniform Resource Name (URN) addresses.
Öffentliche Klasse User The User object represents a SQL Server user.
Öffentliche Klasse UserCollection The UserCollection class represents a collection of User objects that represent all the database users defined on a database.
Öffentliche Klasse UserDefinedAggregate The UserDefinedAggregate object represents a SQL Server user-defined aggregate.
Öffentliche Klasse UserDefinedAggregateCollection The UserDefinedAggregateCollection class represents a collection of UserDefinedAggregate objects that represent all the database user-defined aggregates that are defined on a database.
Öffentliche Klasse UserDefinedAggregateParameter The UserDefinedAggregateParameter object represents the parameters that are used with a user-defined aggregate.
Öffentliche Klasse UserDefinedAggregateParameterCollection The UserDefinedAggregateParameterCollection class represents a collection of UserDefinedAggregateParameter objects that represent all the user-defined aggregate parameters that are defined on a table.
Öffentliche Klasse UserDefinedDataType The UserDefinedDataType object represents a SQL Server user-defined data type.
Öffentliche Klasse UserDefinedDataTypeCollection The UserDefinedDataTypeCollection class represents a collection of UserDefinedDataType objects that represent all the user-defined data types defined on a table.
Öffentliche Klasse UserDefinedFunction The UserDefinedFunction object represents a SQL Server user-defined function.
Öffentliche Klasse UserDefinedFunctionCollection The UserDefinedFunctionCollection class represents a collection of UserDefinedFunction objects that represent all the user-defined functions that are defined on a table.
Öffentliche Klasse UserDefinedFunctionEvent The UserDefinedFunctionEvent object represents the SQL Server user-defined function events that can be included in a user-defined function event set.
Öffentliche Klasse UserDefinedFunctionEvents The UserDefinedFunctionEvents object represents the settings that are required for SQL Server user-defined function event notification.
Öffentliche Klasse UserDefinedFunctionEventSet The UserDefinedFunctionEventSet object represents a SQL Server set of user-defined function events.
Öffentliche Klasse UserDefinedFunctionParameter The UserDefinedFunctionParameter object represents a SQL Server user-defined function parameter.
Öffentliche Klasse UserDefinedFunctionParameterCollection The UserDefinedFunctionParameterCollection class represents a collection of UserDefinedFunctionParameter objects that represent all the user-defined function parameters that are defined on a table.
Öffentliche Klasse UserDefinedMessage The UserDefinedMessage object represents a user-defined message.
Öffentliche Klasse UserDefinedMessageCollection The UserDefinedMessageCollection class represents a collection of UserDefinedMessage objects that represent all the user-defined messages defined on a table.
Öffentliche Klasse UserDefinedTableType The UserDefinedTableType object represents a SQL Server user-defined table type data type.
Öffentliche Klasse UserDefinedTableTypeCollection The UserDefinedTableTypeCollection class represents a collection of UserDefinedTableType objects that represent all the user-defined table types that are defined on a database.
Öffentliche Klasse UserDefinedType The UserDefinedType represents an alias data type that is based on .NET data types.
Öffentliche Klasse UserDefinedTypeCollection The UserDefinedTypeCollection class represents a collection of UserDefinedType objects that represent all the alias data types that are defined on a table.
Öffentliche Klasse UserDefinedTypeEvents The UserDefinedTypeEvents object represents the settings required for SQL Server user-defined type event notification.
Öffentliche Klasse UserEvents The UserEvents object represents the settings that are required for SQL Server database user event notification.
Öffentliche Klasse UserOptions The UserOptions object represents a set configurable server options that relate specifically to users.
Öffentliche Klasse 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.
Öffentliche Klasse View The View object represents a SQL Server view.
Öffentliche Klasse ViewCollection The ViewCollection class represents a collection of View objects that represent all the views defined on a table.
Öffentliche Klasse ViewEvent The ViewEvent object represents the SQL Server view events that can be included in a view event set.
Öffentliche Klasse ViewEvents The ViewEvents object represents the settings that are required for SQL Server view event notification.
Öffentliche Klasse ViewEventSet The ViewEventSet object represents a set of view events.
Öffentliche Klasse WorkloadGroup
Öffentliche Klasse WorkloadGroupCollection Initializes a workload group.
Öffentliche Klasse WrongPropertyValueException The WrongPropertyValueException class represents the exception that is raised when a property is assigned the wrong value.
Öffentliche Klasse 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.
Öffentliche Klasse 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.

Strukturen

  Struktur Beschreibung
Öffentliche Struktur AuditSpecificationDetail The AuditSpecificationDetail object represents a SQL Server audit specification detail required when creating an audit.
Öffentliche Struktur DdlTextParserHeaderInfo This class supports the SMO infrastructure and is not intended to be used directly from your code.

Schnittstellen

  Schnittstelle Beschreibung
Öffentliche Schnittstelle IColumnPermission The IColumnPermission class represents the interface that manages permissions for a specified column.
Öffentliche Schnittstelle IDatabaseMaintenanceFacet Interface that defined methods and properties for the database maintenance facet.
Öffentliche Schnittstelle IDatabaseOptions Interface with properties that expose database options.
Öffentliche Schnittstelle IDatabasePerformanceFacet
Öffentliche Schnittstelle IDatabaseSecurityFacet Security facet interface.
Öffentliche Schnittstelle IExtendedProperties The IExtendedProperties class is an interface that represents the collection of extended properties associated with an object.
Öffentliche Schnittstelle ILoginOptions The ILoginOptions class is an interface that represents a collection of options associated with a login.
Öffentliche Schnittstelle IMultipartNameFacet Interface to deal with object names containing both the object and the schema.
Öffentliche Schnittstelle INameFacet Represents the name facet interface.
Öffentliche Schnittstelle IObjectPermission The IObjectPermission class represents the interface used to set object permissions.
Öffentliche Schnittstelle IScriptable The IScriptable class represents the interface used to create Transact-SQL scripts of SMO objects.
Öffentliche Schnittstelle IServerAuditFacet Interface that identifies audit facet members.
Öffentliche Schnittstelle IServerConfigurationFacet Contains configuration information for the interface based on Configuration
Öffentliche Schnittstelle IServerInformation An interface based on the Information type properties.
Öffentliche Schnittstelle IServerPerformanceFacet An interface for the performance facet.
Öffentliche Schnittstelle IServerSecurityFacet An interface that defines members for the SeverSecurityFacet.
Öffentliche Schnittstelle IServerSettings An interface for SQL Server 2008 Policy-Based Management that is based on Settings.
Öffentliche Schnittstelle IServerSetupFacet Represents the Policy-Based Management facet interface for setting up an instance of SQL Server.
Öffentliche Schnittstelle ISurfaceAreaFacet An interface that defines surface area facet members.
Öffentliche Schnittstelle ITableOptions The ITableOptions class is an interface that represents a collection of options that is associated with a table.
Öffentliche Schnittstelle ITextObject The ITextObject class represents the interface that is used to implement text on objects.
Öffentliche Schnittstelle IViewOptions The IViewOptions class is an interface that represents a collection of options that is associated with a view.

Delegaten

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

Enumerationen

  Enumeration Beschreibung
Öffentliche Enumeration ActivationExecutionContext The ActivationExecutionContext enumeration contains values that specify the security context used by a procedure. These procedures are activated by a service queue.
Öffentliche Enumeration 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.
Öffentliche Enumeration AssemblySecurityLevel The AssemblySecurityLevel enumeration contains values that are used to specify the access rights for an assembly.
Öffentliche Enumeration AsymmetricKeyEncryptionAlgorithm The AsymmetricKeyEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an asymmetric key.
Öffentliche Enumeration AsymmetricKeySourceType The AsymmetricKeySourceType enumeration contains values that are used to specify the source type used to load an asymmetric key.
Öffentliche Enumeration AttachOptions The AttachOptions enumeration contains values that are used to specify attach options.
Öffentliche Enumeration AuditActionType The AuditActionType enumeration contains values that are used to specify the audit action types.
Öffentliche Enumeration AuditDestinationType The AuditDestination enumeration contains values that are used to specify the destination, to which the results of a SQL Server Audit are sent.
Öffentliche Enumeration AuditFileSizeUnit The AuditFileSizeUnit enumeration contains values that are used to specify the unit that specifies the size of the audit file.
Öffentliche Enumeration AuditLevel The AuditLevel enumeration contains values that are used to specify the SQL Server audit level setting.
Öffentliche Enumeration AuditStatusType The AuditStatusType enumeration contains values that are used to specify the status of the audit.
Öffentliche Enumeration BackupActionType The BackupActionType enumeration contains values that are used to specify the type of backup.
Öffentliche Enumeration BackupCompressionOptions The BackupCompressionOptions enumeration contains values that are used to specify the backup compression option.
Öffentliche Enumeration BackupDeviceType The BackupDeviceType enumeration contains values that are used to specify the backup device type.
Geschützte Enumeration BackupRestoreBase. . :: . .AsyncOperation The BackupRestoreBase..::..AsyncOperation enumeration contains values that are used to specify which backup components are running asynchronously.
Öffentliche Enumeration BackupSetFlag The BackupSetFlag enumeration contains values that are used to specify the purpose of the backup.
Öffentliche Enumeration BackupSetType The BackupSetType enumeration contains values that are used to specify the backup type.
Öffentliche Enumeration BackupTruncateLogType The BackupTruncateLogType enumeration contains values that are used to specify the truncate action taken on the log.
Öffentliche Enumeration CatalogPopulationAction The CatalogPopulationAction enumeration contains values that are used to specify the method used to populate a full-text catalog.
Öffentliche Enumeration CatalogPopulationStatus The CatalogPopulationStatus enumeration contains values that are used to specify the status of the full-text catalog.
Öffentliche Enumeration CertificateSourceType The CertificateSourceType enumeration contains values that are used to specify the source of the certificate.
Öffentliche Enumeration ChangeTracking The ChangeTracking enumeration contains values that are used to specify change tracking in a full-text index.
Öffentliche Enumeration CollationVersion The CollationVersion enumeration contains values that specify the collation versions.
Öffentliche Enumeration CompatibilityLevel The CompatibilityLevel enumeration is a list of constant values that specify the behavior that corresponds to a version of SQL Server.
Öffentliche Enumeration CreateDispositionType The CreateDispositionType enumeration contains values that are used to specify the source of the symmetric key.
Öffentliche Enumeration DatabaseDdlTriggerExecutionContext The DatabaseDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the database DDL trigger runs.
Öffentliche Enumeration DatabaseEncryptionAlgorithm Specifies the algorithm used to encrypt the database encryption key
Öffentliche Enumeration DatabaseEncryptionState
Öffentliche Enumeration DatabaseEncryptionType The DatabaseEncryptionType enumeration contains values that are used to specify the encryption types.
Öffentliche Enumeration DatabaseEventType The DatabaseEventType enumeration is a list of constant values that specify the database event type.
Öffentliche Enumeration DatabaseObjectTypes The DatabaseObjectTypes enumeration is a list of constant values that specifies the types of database object.
Öffentliche Enumeration DatabasePermissionSetValue The DatabasePermissionSetValue enumeration is a list of constant values that specify all the database permissions.
Öffentliche Enumeration 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.
Öffentliche Enumeration DatabaseUserAccess The DatabaseUserAccess enumeration is a list of constant values that specify how user access can be restricted.
Öffentliche Enumeration DataCompressionType The DataCompressionType enumeration contains values that are used to specify the type of data compression used to store data on the physical partition.
Öffentliche Enumeration DependencyType The DependencyType enumeration is a list of constant values that specifies the direction of the dependency discovery operation.
Öffentliche Enumeration DeviceType The DeviceType enumeration is a list of constant values that specify the various different types of devices supported by SQL Server.
Öffentliche Enumeration Edition The Edition enumeration is a list of constant values that specify the various different types of devices that are supported by SQL Server.
Öffentliche Enumeration EndpointAuthenticationOrder The EndpointAuthenticationOrder enumeration contains values that are used to specify the authentication methods and order of preference for the endpoint connection.
Öffentliche Enumeration EndpointEncryption The EndpointEncryption enumeration contains values that are used to specify the state of encryption on the endpoint.
Öffentliche Enumeration EndpointEncryptionAlgorithm The EndpointEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an endpoint.
Öffentliche Enumeration EndpointState The EndpointState enumeration is a list of constant values that specifies the state of the HTTP endpoint.
Öffentliche Enumeration EndpointType The EndpointType enumeration is a list of constant values that specifies the type of HTTP endpoint.
Öffentliche Enumeration EventType The EventType enumeration is a list of constant values that specify the various different types of events that are supported by SQL Server.
Öffentliche Enumeration 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.
Öffentliche Enumeration ExecutionStatus The ExecutionStatus enumeration is a list of constant values that specify the status of an executing process.
Öffentliche Enumeration FileGrowthType The FileGrowthType enumeration is a list of constant values that specify whether file growth is determined by percentage amount or by KB.
Öffentliche Enumeration FilestreamAccessLevelType The FilestreamAccessLevelType enumeration contains values that are used to specify the type of access permitted on file stream operations.
Öffentliche Enumeration FileStreamEffectiveLevel The FileStreamEffectiveLevel enumeration contains values that are used to specify the file stream level.
Öffentliche Enumeration FileStreamLevel The FileStreamLevel enumeration contains values that are used to specify the file stream level.
Öffentliche Enumeration ForeignKeyAction The 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.
Öffentliche Enumeration FragmentationOption The FragmentationOption enumeration is a list of constant values that specify the levels of detail of collected fragmentation information.
Öffentliche Enumeration FullTextCatalogUpgradeOption The FullTextCatalogUpgradeOption enumeration contains values that are used to specify the action taken when the full-text catalog is upgraded.
Öffentliche Enumeration HttpAuthenticationModes The HttpAuthenticationModes enumeration contains values that specify the HTTP port for HTTP endpoints.
Öffentliche Enumeration HttpPortTypes The HttpPortTypes enumeration contains values that are used to specify the type HTTP port.
Öffentliche Enumeration 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.
Öffentliche Enumeration IndexEnableAction The 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.
Öffentliche Enumeration IndexKeyType The IndexKeyType enumeration contains values that are used to specify the type of key on which the index is created.
Öffentliche Enumeration IndexOperation The IndexOperation enumeration contains values that are used to specify index operations.
Öffentliche Enumeration IndexPopulationAction The IndexPopulationAction enumeration contains values that are used to specify the type of Microsoft Search full-text index population.
Öffentliche Enumeration IndexPopulationStatus The IndexPopulationStatus enumeration contains values that are used to specify the type of population in progress.
Öffentliche Enumeration InDoubtTransactionResolutionType
Öffentliche Enumeration KeyEncryptionType The KeyEncryptionType enumeration is a list of constant values that specify the key encryption type.
Öffentliche Enumeration LinkedTableType The LinkedTableType enumeration contains values that specify the type of table accessed on a linked server.
Öffentliche Enumeration LinkFieldType The LinkFieldType enumeration contains values that specify the type of link field.
Öffentliche Enumeration LockEscalationType An enumeration that lists lock escalation types.
Öffentliche Enumeration LockRequestStatus The LockRequestStatus enumeration contains constant values that specify the lock request status.
Öffentliche Enumeration LoginCreateOptions The LoginCreateOptions enumeration contains values that are used to specify the password options when you create a logon.
Öffentliche Enumeration LoginType The LoginType enumeration contains values that are used to specify the authentication type and the Windows account type.
Öffentliche Enumeration LogReuseWaitStatus The LogReuseWaitStatus enumeration contains values that specify the current operation on which the reuse of transaction log space is waiting.
Öffentliche Enumeration MappedClassType
Öffentliche Enumeration 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.
Öffentliche Enumeration MethodLoginType The MethodLoginType enumeration contains values that are used to specify the method used for logging on to the instance of SQL Server.
Öffentliche Enumeration MethodXsdSchemaOption The MethodXsdSchemaOption enumeration contains values that specify the XSD schema returned for a SOAP method.
Öffentliche Enumeration MirroringOption The MirroringOption enumeration contains values that specify the mirroring options for a database.
Öffentliche Enumeration MirroringRole The MirroringRole enumeration contains values that specify the role the database plays in mirroring.
Öffentliche Enumeration MirroringSafetyLevel The MirroringSafetyLevel enumeration contains values that specify the safety guarantee on updates to the mirrored database.
Öffentliche Enumeration MirroringStatus The MirroringStatus enumeration contains values that specify the state of a database regarding mirroring.
Öffentliche Enumeration MirroringWitnessStatus The MirroringWitnessStatus enumeration contains values that specify the state of the mirroring witness.
Öffentliche Enumeration Month The Month enumeration contains constant values that specify the twelve calendar months.
Öffentliche Enumeration NSActivationState The NSActivationState enumeration contains constant values that specify the activation state of Notification Services.
Öffentliche Enumeration ObjectClass The ObjectClass enumeration contains values that specify the SMO class type.
Öffentliche Enumeration ObjectPermissionSetValue The ObjectPermissionSetValue enumeration is a list of constant values that specify all the object permissions.
Öffentliche Enumeration OnFailureAction The OnFailureAction enumeration contains values that specify the action to be taken when an audit fails.
Öffentliche Enumeration PageVerify The PageVerify enumeration contains constant values that specify the automatic page verification options for a database.
Öffentliche Enumeration PerfMonMode The PerfMonMode enumeration contains values that are used to specify the polling behavior in Performance Monitor.
Öffentliche Enumeration PermissionState The PermissionState enumeration contains values that specify the state of a permission.
Öffentliche Enumeration PlanGuideType
Öffentliche Enumeration PrincipalType The PrincipalType enumeration contains values that specify the type of user, role, or login.
Öffentliche Enumeration 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.
Öffentliche Enumeration 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.
Öffentliche Enumeration ProtocolType The ProtocolType enumeration contains values that are used to specify the type of protocol.
Öffentliche Enumeration ProviderAuthenticationType Specifies the type of authentication supported by Cryptographic Provider.
Öffentliche Enumeration RangeType The RangeType enumeration contains values that are used to specify the type range.
Öffentliche Enumeration RecoveryModel The RecoveryModel enumeration contains values that are used to specify the type of recovery model.
Öffentliche Enumeration RepairOptions The RepairOptions enumeration contains values that are used to specify the repair options that are used when checking data in a table.
Öffentliche Enumeration RepairStructure The RepairRepairStructure enumeration contains values that are used to specify the type of repair options used when checking data in a table.
Öffentliche Enumeration RepairType The RepairType enumeration contains values that are used to specify the type of repair mode used by the database consistency check (DBCC) functions.
Öffentliche Enumeration ReplicationOptions The ReplicationOptions enumeration contains values that are used to specify the replication settings for the referenced database.
Öffentliche Enumeration ResourceUsage The ResourceUsage enumeration contains values that specify the relative operating system execution priority setting for the Microsoft Search service.
Öffentliche Enumeration RestoreActionType The RestoreActionType enumeration contains values that are used to specify the type of action that is required during a data restore operation.
Öffentliche Enumeration RestoreType The RestoreType enumeration contains values that specify the type of restore operation to perform.
Öffentliche Enumeration ResultFormat The ResultFormat enumeration contains values that specify the format in which to return results for an HTTP endpoint.
Öffentliche Enumeration RetentionPeriodUnits
Öffentliche Enumeration RoleTypes The RoleTypes enumeration contains values that are used to specify the type of role.
Öffentliche Enumeration SecondaryXmlIndexType The SecondaryXmlIndexType enumeration contains values that are used to specify the secondary XML index type.
Öffentliche Enumeration ServerDdlTriggerExecutionContext The ServerDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the server DDL trigger runs.
Öffentliche Enumeration ServerLoginMode The ServerLoginMode enumeration contains values that are used to specify the method used to connect to the instance of SQL Server.
Öffentliche Enumeration ServerMirroringRole The ServerMirroringRole enumeration contains values that are used to specify the role of the instance of SQL Server when participating in mirroring.
Öffentliche Enumeration ServerPermissionSetValue The ServerPermissionSetValue enumeration is a list of constant values that specify all the database permissions.
Öffentliche Enumeration ServerStatus The ServerStatus enumeration contains values that are used to specify the status of the instance of SQL Server.
Öffentliche Enumeration ServerType The ServerType enumeration contains values that are used to specify whether the server is part of a multi-server administration matrix.
Öffentliche Enumeration ServiceStartMode The ServiceStartMode enumeration contains values that are used to specify the method that is used to start a service.
Öffentliche Enumeration ShrinkMethod The ShrinkMethod enumeration contains values that are used to specify the method that is used shrink a database file.
Öffentliche Enumeration SmoExceptionType The SmoExceptionType enumeration contains values that are used to specify the type of SMO exception.
Öffentliche Enumeration SnapshotIsolationState The SnapshotIsolationState enumeration contains values that are used to specify the current state of snapshot isolation.
Öffentliche Enumeration SortOrder The SortOrder enumeration contains values that specify how objects are sorted in an enumerated list.
Öffentliche Enumeration SpatialGeoLevelSize
Öffentliche Enumeration SpatialIndexType
Öffentliche Enumeration SqlDataType The SqlDataType enumeration contains values that are used to specify a SQL Server data type.
Öffentliche Enumeration SqlServerVersion The SqlServerVersion enumeration contains values that are used to specify the version of the referenced instance of SQL Server.
Öffentliche Enumeration SqlServerVersions The SqlServerVersions enumeration contains values that are used to specify the version of the referenced instance of SQL Server.
Öffentliche Enumeration SqlSmoState The SqlSmoState enumeration contains values that are used to specify the state of an SMO object.
Öffentliche Enumeration SqlVerifyAction The SqlVerifyAction enumeration contains values that are used to specify the type of backup verification.
Öffentliche Enumeration 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.
Öffentliche Enumeration StatisticsTarget The StatisticsTarget enumeration contains values that specify the type of statistic that is targeted for the update operation.
Öffentliche Enumeration StopListOption The StopListOption enumeration contains values that are used to specify the way in which a new stop list is created.
Öffentliche Enumeration SymmetricKeyEncryptionAlgorithm The SymmetricKeyEncryptionAlgorithm enumeration contains values that specify the algorithm that is used to encrypt the symmetric key.
Öffentliche Enumeration SymmetricKeyEncryptionType The SymmetricKeyEncryptionType enumeration contains constant values that specify the type of symmetric key encryption.
Öffentliche Enumeration SynonymBaseType The SynonymBaseType enumeration contains constant values that specify the type of synonym.
Öffentliche Enumeration TerminationClause The TerminationClause enumeration contains constant values that specify the action taken when transactions are terminated.
Öffentliche Enumeration TransactionTypes The TransactionTypes enumeration contains constant values that specify the method of recording transactions.
Öffentliche Enumeration UrnIdOption
Öffentliche Enumeration UserDefinedFunctionType The UserDefinedFunctionType enumeration is a list of constant values that specify the types of user-defined functions that are supported by SQL Server.
Öffentliche Enumeration UserDefinedTypeFormat The UserDefinedTypeFormat enumeration is a list of constant values that specify the formats used by user-defined types.
Öffentliche Enumeration UserType The UserType enumeration contains constant values that specify the security type for the user.
Öffentliche Enumeration WindowsLoginAccessType The WindowsLoginAccessType enumeration contains constant values that specify the type of access a Windows login has to the instance of SQL Server.
Öffentliche Enumeration WorkloadGroupImportance The WorkloadGroupImportance enumeration contains values that specify the importance of workload groups.
Öffentliche Enumeration WsdlGeneratorOption The WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.
Öffentliche Enumeration XmlDocumentConstraint The XmlDocumentConstraint enumeration contains constant values that specify the constraints imposed on an XML document.
Öffentliche Enumeration XmlFormatOption The WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.
Öffentliche Enumeration XmlTypeDerivation The XmlTypeDerivation enumeration contains constant values that specify the XML type derivation.
Öffentliche Enumeration XmlTypeKind The XmlTypeKind enumeration contains constant values that specify the kind of XML component.
Öffentliche Enumeration XsdSchemaOption The XsdSchemaOption enumeration contains constant values that specify whether an inline schema for the method result is returned in the SOAP response.