(0) exportieren Drucken
Alle erweitern
Erweitern Minimieren

Microsoft.SqlServer.Management.Smo-Namespace

The Microsoft.SqlServer.Management.Smo namespace contains classes that represent the core SQL Server Database Engine (Datenbankmodul) objects. These include instances, databases, tables, stored procedures, and views.

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 the SQL Server Database Engine (Datenbankmodul) has been established by using a Server object variable, objects on the instance 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 Database Engine (Datenbankmodul). 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.

Most of the classes Microsoft.SqlServer.Management.Smo namespace resides in the Microsoft.SqlServer.Smo.dll and Microsoft.SqlServer.SmoExtended.dll files. 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 four files to access all of 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 the SQL Server Database Engine (Datenbankmodul).

  • View and modify instance settings and configuration options.

  • View and modify database objects.

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

  • Script databases dependencies.

  • Perform database maintenance tasks, such as backup and restore operations.

  • Transfer database schemas and data.

  KlasseBeschreibung
Öffentliche KlasseAbstractCollectionBaseThe AbstractCollectionBase object is a base class object that is used in the construction of collection objects.
Öffentliche KlasseAffinityInfoThe AffinityInfo object represents the Affinity settings for all CPUs and NUMA nodes on an Instance of SQL Server. Access to the AffinityInfo object is provided though the Server object.
Öffentliche KlasseApplicationRoleThe ApplicationRole object represents a security role that is used to set access privileges from an application regardless of the user's permissions.
Öffentliche KlasseApplicationRoleCollectionThe ApplicationRoleCollectionclass represents a collection of ApplicationRole objects that represent all the application roles on the referenced database.
Öffentliche KlasseApplicationRoleEventsThe ApplicationRoleEvents object represents the settings required for Microsoft SQL Server application role event notification.
Öffentliche KlasseArrayListCollectionBaseThe ArrayListCollectionBase object represents a base class that is used in the construction of collections that are based on array lists.
Öffentliche KlasseAsymmetricKeyThe AsymmetricKey object represents a SQL Server asymmetric key.
Öffentliche KlasseAsymmetricKeyCollectionThe AsymmetricKeyCollection class represents a collection of AsymmetricKey objects that represent all the asymmetric keys on the referenced database.
Öffentliche KlasseAsyncStatusThe AsyncStatus object represents the status of an asynchronous process.
Öffentliche KlasseAuditThe Audit object represents a SQL Server audit log.
Öffentliche KlasseAuditCollectionThe AuditCollection class represents a collection of Audit objects that represent all the audits on the instance of SQL Server.
Öffentliche KlasseAuditExtenderAdds methods and properties to the Audit object.
Öffentliche KlasseAuditSpecificationThe AuditSpecification class defines the audit groups and specifies the server audit that they belong to.
Öffentliche KlasseBackupThe Backup object provides programmatic access to Microsoft SQL Server backup operations.
Öffentliche KlasseBackupDeviceThe BackupDevice object provides programmatic access to SQL Server backup devices.
Öffentliche KlasseBackupDeviceCollectionThe BackupDeviceCollection class represents a collection of BackupDevice objects that represent all the backup devices on an instance of SQL Server.
Öffentliche KlasseBackupDeviceItemThe BackupDeviceItem object provides programmatic access to named SQL Server backup devices.
Öffentliche KlasseBackupDeviceListThe BackupDeviceList object provides programmatic access to a list backup devices.
Öffentliche KlasseBackupRestoreBaseThe BackupRestoreBase class is a base class that represents functionality that is common to both backup and restore operations.
Öffentliche KlasseCertificateThe Certificate object represents a SQL Server certificate.
Öffentliche KlasseCertificateCollectionThe CertificateCollection class represents a collection of Certificate objects that represent all the certificates on an instance of SQL Server.
Öffentliche KlasseCertificateEventsThe CertificateEvents object represents the settings that are required for SQL Server Certificate event notification.
Öffentliche KlasseCheckThe Check object represents a SQL Server check constraint. 
Öffentliche KlasseCheckCollectionThe CheckCollection class represents a collection of Check objects that represent all the check constraints defined on the parent object.
Öffentliche KlasseCollectionNotAvailableExceptionThe CollectionNotAvailableException class is an exception that is raised when an attempt is made to retrieve a collection that is not available.
Öffentliche KlasseColumnDas Column-Objekt stellt eine SQL Server-Spalte dar.
Öffentliche KlasseColumnCollectionThe ColumnCollection class represents a collection of Column objects that represent all the columns defined on a table.
Öffentliche KlasseConfigPropertyThe ConfigProperty object contains information pertaining to a Microsoft SQL Server configuration option, such as maximum, minimum, current, and new values.
Öffentliche KlasseConfigPropertyCollectionThe ConfigPropertyCollection class represents a collection of ConfigProperty objects that represent all the configuration properties defined on the instance of SQL Server.
Öffentliche KlasseConfigurationDie Configuration-Klasse enthält die Konfigurationsinformationen für die SQL Server-Instanz.
Öffentliche KlasseConfigurationBaseThe ConfigurationBase class is a base class that represents configuration information for the instance of SQL Server.
Öffentliche KlasseCpuThe Cpu class contains information about one CPU on an instance of SQL Server.
Öffentliche KlasseCpuCollectionThe CpuCollection class represents a collection of Cpu objects that represent all the CPUs that are defined on an instance of SQL Server.
Öffentliche KlasseCredentialThe Credential object represents a Microsoft SQL Server credential.
Öffentliche KlasseCredentialCollectionThe CredentialCollection class represents a collection of Credential objects that represent all the credentials defined on the instance of Microsoft SQL Server.
Öffentliche KlasseCryptographicProviderThe CryptographicProvider object represents a SQL Server cryptographic provider.
Öffentliche KlasseCryptographicProviderCollectionA collection of type CryptographicProviderCollection that represents a collection of CryptographicProviderr objects.
Öffentliche KlasseDatabaseDas Database-Objekt stellt eine SQL Server-Datenbank dar.
Öffentliche KlasseDatabaseActiveDirectoryThe DatabaseActiveDirectory object provides programmatic access to the Active Directory settings for a database.
Öffentliche KlasseDatabaseAdapterDatabase Adapter type to be used as a management facet.
Öffentliche KlasseDatabaseAdapterBaseDatabase adapter base.
Öffentliche KlasseDatabaseAuditSpecificationThe DatabaseAuditSpecification object represents an auditable event on the database.
Öffentliche KlasseDatabaseAuditSpecificationCollectionThe DatabaseAuditSpecificationCollection class represents a collection of DatabaseAuditSpecification objects that represent all the audit specifications defined on the database.
Öffentliche KlasseDatabaseAuditSpecificationExtenderAdds methods and properties to the DatabaseAuditSpecification object.
Öffentliche KlasseDatabaseCollectionThe DatabaseCollection class represents a collection of Database objects that represent all the databases defined on the instance of SQL Server.
Öffentliche KlasseDatabaseDdlTriggerThe DatabaseDdlTrigger object represents a SQL Server database data definition language (DDL) trigger.
Öffentliche KlasseDatabaseDdlTriggerCollectionThe DatabaseDdlTriggerCollection class represents a collection of DatabaseDdlTrigger objects that represent all the database data definition language (DDL) triggers defined on a table.
Öffentliche KlasseDatabaseDdlTriggerEventThe DatabaseDdlTriggerEvent object represents the SQL Server database DDL trigger events that can be included in a database DDL trigger event set.
Öffentliche KlasseDatabaseDdlTriggerEventSetThe DatabaseDdlTriggerEventSet object represents a set of SQL Server database data definition language (DDL) trigger events.
Öffentliche KlasseDatabaseEncryptionKeyCreates a database encryption key.
Öffentliche KlasseDatabaseEncryptionKeyExtenderExtends the database encryption key class.
Öffentliche KlasseDatabaseEventThe DatabaseEvent object represents the SQL Server database events that can be included in a database event set.
Öffentliche KlasseDatabaseEventArgsThe DatabaseEventArgs object represents the arguments passed by the event raised by the database.
Öffentliche KlasseDatabaseEventsThe DatabaseEvents object represents the settings required for Microsoft SQL Server database event notification.
Öffentliche KlasseDatabaseEventSetThe DatabaseEventSet object represents a SQL Server set of database events.
Öffentliche KlasseDatabaseFileThe DatabaseFile object is a base class used in the construction of DataFile objects and LogFile objects.
Öffentliche KlasseDatabaseFileMappingsDictionaryThis 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 KlasseDatabaseMaintenanceAdapterThe Database Maintenance facet has logical properties. It inherits from the DatabaseAdapter class.
Öffentliche KlasseDatabaseMappingThe DatabaseMapping object represents a SQL Server database mapping.
Öffentliche KlasseDatabaseMirroringPayloadThe DatabaseMirroringPayload object represents database mirroring payload settings.
Öffentliche KlasseDatabaseOptionsThe DatabaseOptions object represents SQL Server database options.
Öffentliche KlasseDatabasePerformanceAdapterThe Database Performance facet implements logical properties relevant to database performance management.
Öffentliche KlasseDatabasePermissionThe 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 KlasseDatabasePermissionInfoThe DatabasePermissionInfo object represents information about a SQL Server database permission.
Öffentliche KlasseDatabasePermissionSetDas DatabasePermissionSet-Objekt stellt einen SQL Server-Satz von Datenbankberechtigungen dar.
Öffentliche KlasseDatabaseRoleThe DatabaseRole object represents a SQL Server database security role.
Öffentliche KlasseDatabaseRoleCollectionThe DatabaseRoleCollection class represents a collection of DatabaseRole objects that represent all the database roles defined on the parent database.
Öffentliche KlasseDatabaseSecurityAdapterIncludes properties and methods that are used to expose the Database Security facet.
Öffentliche KlasseDatabaseSnapshotExtenderAdds methods and properties to the DatabaseSnapshot object.
Öffentliche KlasseDataFileThe DataFile object represents a SQL Server data file.
Öffentliche KlasseDataFileCollectionThe DataFileCollection class represents a collection of DataFile objects that represent all the data files defined on the parent object.
Öffentliche KlasseDataTypeThe DataType object represents a SQL Server data type.
Öffentliche KlasseDdlTriggerBaseThe DdlTriggerBase is a base class that is inherited by the DatabaseDdlTrigger object. This represents a SQL Server database data definition language (DDL) trigger.
Öffentliche KlasseDefaultThe Default object represents a SQL Server default.
Öffentliche KlasseDefaultCollectionThe DefaultCollection class represents a collection of Default objects.
Öffentliche KlasseDefaultConstraintThe DefaultConstraint object represents a SQL Server default constraint.
Öffentliche KlasseDefaultRuleBaseThe DefaultRuleBase class is a base class that is inherited by the Rule class and the Default class.
Öffentliche KlasseDependencyCollectionThe DependencyCollection class represents a collection of Dependency objects that are used to derive the node classes in SMO scripting operations.
Öffentliche KlasseDependencyCollectionNodeThe DependencyCollectionNode class represents a node in the dependency collection that is derived during scripting operations.
Öffentliche KlasseDependencyNodeThe DependencyNode class represents a node that is defined by a URN address.
Öffentliche KlasseDependencyTreeThe DependencyTree object represents a tree structure that contains SQL Server objects and their hierarchical relationships to each other.
Öffentliche KlasseDependencyTreeNodeThe DependencyTreeNode class represents the child and sibling SQL Server objects within a DependencyTree object hierarchy.
Öffentliche KlasseDependencyWalkerThe 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 KlasseEndpointThe Endpoint class represents an endpoint service that can listen natively for requests.
Öffentliche KlasseEndpointCollectionThe EndpointCollection class represents a collection of Endpoint objects that represent all the HTTP endpoints.
Öffentliche KlasseEndpointPayloadThe EndpointPayload object represents an endpoint payload.
Öffentliche KlasseEndpointProtocolThe EndpointProtocol object represents an HTTP endpoint protocol.
Öffentliche KlasseEventPropertyThe EventProperty class represents a property of an event.
Öffentliche KlasseEventPropertyCollectionThe EventPropertyCollection object represents the properties of event objects.
Öffentliche KlasseEventSetBaseThe EventSetBase class is a base class that is used to derive the event set objects.
Öffentliche KlasseExtendedPropertyThe ExtendedProperty object represents the extended properties that are defined for any object that has an ExtendedProperties collection property.
Öffentliche KlasseExtendedPropertyCollectionThe ExtendedPropertyCollection class represents a collection of ExtendedPropertyCollectionobjects that represent all the extended properties.
Öffentliche KlasseExtendedStoredProcedureThe ExtendedStoredProcedure object represents an extended stored procedure on the instance of Microsoft SQL Server.
Öffentliche KlasseExtendedStoredProcedureCollectionThe ExtendedStoredProcedureCollection class represents a collection of ExtendedStoredProcedure objects that represent all the extended stored procedures defined on the parent database.
Öffentliche KlasseFailedOperationExceptionDie FailedOperationException-Klasse stellt die Ausnahme dar, die bei einem fehlerhaften Vorgang ausgelöst wird. . Ausnahmen werden ausgelöst bei Fehlern in den Datenbankvorgängen CREATE, DROP, ALTER, SCRIPT, REFRESH und RENAME. Diese Ausnahme kann auch ausgelöst werden, wenn eine der öffentlichen Methoden in SMO einen Fehler aufweist.
Öffentliche KlasseFileGroupDas FileGroup-Objekt stellt eine SQL Server-Dateigruppe dar. Weitere Informationen zu Dateigruppen finden Sie unter Verwenden von Dateigruppen und Dateien zur Speicherung von Daten.
Öffentliche KlasseFileGroupCollectionThe FileGroupCollection class represents a collection of FileGroup objects that represent all the filegroups defined on the parent database.
Öffentliche KlasseForeignKeyThe ForeignKey object represents a SQL Server foreign key.
Öffentliche KlasseForeignKeyCollectionThe ForeignKeyCollection class represents a collection of ForeignKey objects that represent all the foreign keys defined on the parent object.
Öffentliche KlasseForeignKeyColumnThe ForeignKeyColumn object represents a SQL Server foreign key column.
Öffentliche KlasseForeignKeyColumnCollectionThe ForeignKeyColumnCollection class represents a collection of ForeignKeyColumn objects that represent all the foreign key columns defined on the parent object.
Öffentliche KlasseFrequencyPairThe FrequencyPair object is a utility that measures frequency by storing count and duration information.
Öffentliche KlasseFullTextCatalogThe FullTextCatalog object represents a Microsoft Search full-text catalog.
Öffentliche KlasseFullTextCatalogCollectionThe FullTextCatalogCollection class represents a collection of FullTextCatalog objects that represent all the full-text catalogs defined on the parent object.
Öffentliche KlasseFullTextIndexThe FullTextIndex object represents a Microsoft Search full-text index.
Öffentliche KlasseFullTextIndexColumnThe FullTextIndexColumn object represents a Microsoft Search full-text index column.
Öffentliche KlasseFullTextIndexColumnCollectionThe FullTextIndexColumnCollection class represents a collection of FullTextIndexColumn objects that represent all the full-text index columns defined on the parent object.
Öffentliche KlasseFullTextServiceThe FullTextService object allows programmatic access to the Microsoft Search full-text settings.
Öffentliche KlasseFullTextStopListThe FullTextStopList object represents a full-text stop list.
Öffentliche KlasseFullTextStopListCollectionThe FullTextStopListCollection class represents a collection of FullTextStopList objects that represent all the full-text stop lists that are defined on the parent database.
Öffentliche KlasseHttpProtocolThe HttpProtocol object represents an HTTP protocol on an instance of Microsoft SQL Server.
Öffentliche KlasseIndexThe Index object represents a SQL Server index.
Öffentliche KlasseIndexCollectionThe IndexCollection class represents a collection of Index objects that represent all the indexes defined on the instance of SQL Server.
Öffentliche KlasseIndexedColumnThe IndexedColumn object represents a SQL Server column that is participating in an index. 
Öffentliche KlasseIndexedColumnCollectionThe IndexedColumnCollection class represents a collection of IndexedColumn objects that represent all the indexed columns defined on the instance of SQL Server.
Öffentliche KlasseIndexEventsThe IndexEvents object represents the settings that are required for SQL Server index event notification.
Öffentliche KlasseInformationThe 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 KlasseInternalSmoErrorExceptionThe InternalSmoErrorException class represents the exception raised when an error occurs during the internal phase of a SMO operation.
Öffentliche KlasseInvalidSmoOperationExceptionThe InvalidSmoOperationException class represents the exception raised when an SMO operation is not valid.
Öffentliche KlasseInvalidVersionSmoOperationExceptionThe InvalidVersionSmoOperationException class represents the exception raised when the version is not valid on an SMO operation.
Öffentliche KlasseJobScheduleCollectionBaseThe JobScheduleCollectionBase class represents a base class that is used in the construction of the JobScheduleCollection class.
Öffentliche KlasseLanguageA 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 KlasseLanguageCollectionThe LanguageCollection class represents a collection of Language objects that represent all the languages which are defined on the instance of SQL Server.
Öffentliche KlasseLinkedServerA 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 KlasseLinkedServerCollectionThe LinkedServerCollection class represents a collection of LinkedServer objects that represent all the linked servers registered on the instance of SQL Server.
Öffentliche KlasseLinkedServerLoginThe LinkedServerLogin object represents a SQL Server logon account that has permission to connect to the linked server.
Öffentliche KlasseLinkedServerLoginCollectionThe LinkedServerLoginCollection class represents a collection of LinkedServerLogin objects that represent all the linked server logins defined on the linked server.
Öffentliche KlasseLogFileThe LogFile object represents a SQL Server log file.
Öffentliche KlasseLogFileCollectionThe LogFileCollection class represents a collection of LogFile objects that represent all the log files defined on the instance of Microsoft SQL Server.
Öffentliche KlasseLoginThe 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 KlasseLoginCollectionThe LoginCollection class represents a collection of Login objects that represent all the login accounts defined on the instance of SQL Server.
Öffentliche KlasseLoginEventsThe LoginEvents object represents the settings required for SQL Server login event notification.
Öffentliche KlasseMasterKeyThe MasterKey object represents a SQL Server database master key.
Öffentliche KlasseMessageCollectionBaseDie MessageCollectionBase-Klasse ist eine Basisklasse, die zur Erstellung von Meldungsauflistungsklassen verwendet wird.
Öffentliche KlasseMessageObjectBaseThe MessageObjectBase class is a base class that is inherited by message classes.
Öffentliche KlasseMissingObjectExceptionThe MissingObjectException class represents the exception raised when an object is missing.
Öffentliche KlasseNamedSmoObjectThe NamedSmoObject object represents a named SMO object.
Öffentliche KlasseNumaNodeThe NumaNode object represents the settings for a NUMA node on an instance of SQL Server.
Öffentliche KlasseNumaNodeCollectionThe NumaNodeCollection object contains information about one NUMA node on an instance of SQL Server.
Öffentliche KlasseNumberedObjectCollectionBaseThe NumberedObjectCollectionBase class is a base class that represents common functionality for collections of numbered objects, such as the NumberedStoredProcedure object.
Öffentliche KlasseNumberedStoredProcedureThe NumberedStoredProcedure class represents a Microsoft SQL Server numbered stored procedure.
Öffentliche KlasseNumberedStoredProcedureCollectionThe NumberedStoredProcedureCollection class represents a collection of NumberedStoredProcedure objects that represent all the numbered stored procedures defined on a table.
Öffentliche KlasseNumberedStoredProcedureParameterThe NumberedStoredProcedureParameter object represents a SQL Server numbered stored procedure parameter.
Öffentliche KlasseNumberedStoredProcedureParameterCollectionDie NumberedStoredProcedureParameterCollection-Klasse stellt eine Auflistung von NumberedStoredProcedure-Objekten dar, die alle im übergeordneten Objekt definierten, nummerierten gespeicherten Prozeduren darstellen.
Öffentliche KlasseObjectAlteredEventArgsThe ObjectAlteredEventArgs object represents the arguments that are passed by the event that is raised when an object is altered.
Öffentliche KlasseObjectCreatedEventArgsThe ObjectCreatedEventArgs object represents the arguments that are passed by the event that is raised when an object is created.
Öffentliche KlasseObjectDroppedEventArgsThe ObjectDroppedEventArgs object represents the arguments that are passed by the event that is raised when an object is dropped.
Öffentliche KlasseObjectEventThe ObjectEvent object represents the of SQL Server object events that can be included in an object event set.
Öffentliche KlasseObjectEventSetThe ObjectEventSet object represents a SQL Server set of object events.
Öffentliche KlasseObjectPermissionThe ObjectPermission object represents a SQL Server object permission.
Öffentliche KlasseObjectPermissionInfoThe ObjectPermissionInfo object represents information about a SQL Server object permission.
Öffentliche KlasseObjectPermissionSetThe ObjectPermissionSet object represents a set of object permissions in Microsoft SQL Server.
Öffentliche KlasseObjectRenamedEventArgsThe ObjectRenamedEventArgs object represents the arguments passed by the event raised when an object is renamed.
Öffentliche KlasseOleDbProviderSettingsThe OleDbProviderSettings object represents the setting for a SQL Server OLE DB provider.
Öffentliche KlasseOleDbProviderSettingsCollectionThe OleDbProviderSettingsCollection class represents a collection of OleDbProviderSettings objects that represent all the OLE DB provider settings defined on the linked server.
Öffentliche KlasseOrderColumnOrderColumn 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 KlasseOrderColumnCollectionRepresents a collection of OrderColumn.
Öffentliche KlasseParameterThe 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 KlasseParameterBaseThe 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 KlasseParameterCollectionBaseThe ParameterCollectionBase class is a base class that is used in the construction of parameter collection classes.
Öffentliche KlassePartitionFunctionThe PartitionFunction object provides programmatic access to partition functions.
Öffentliche KlassePartitionFunctionCollectionThe PartitionFunctionCollection class represents a collection of PartitionFunction objects that represent all the partition functions defined on the instance of SQL Server.
Öffentliche KlassePartitionFunctionEventsThe PartitionFunctionEvents object represents the settings required for SQL Server partition function event notification.
Öffentliche KlassePartitionFunctionParameterThe PartitionFunctionParameter object provides programmatic access to partition function parameters.
Öffentliche KlassePartitionFunctionParameterCollectionThe PartitionFunctionParameterCollection class represents a collection of PartitionFunctionParameter objects that represent all the partition function parameters defined on the partition function.
Öffentliche KlassePartitionNumberedObjectCollectionBasePartitionNumberedObjectCollectionBase ist eine Basisklasse, die von der PhysicalPartitionCollection-Klasse geerbt wird.
Öffentliche KlassePartitionSchemeThe PartitionScheme object provides programmatic access to partition schemes.
Öffentliche KlassePartitionSchemeCollectionThe PartitionSchemeCollection class represents a collection of PartitionScheme objects that represent all the partition schemes defined on the instance of SQL Server.
Öffentliche KlassePartitionSchemeEventsThe PartitionSchemeEvents object represents the settings required for Microsoft SQL Server partition scheme event notification.
Öffentliche KlassePartitionSchemeParameterThe PartitionSchemeParameter object provides programmatic access to partition scheme parameters.
Öffentliche KlassePartitionSchemeParameterCollectionThe PartitionSchemeParameterCollection class represents a collection of PartitionSchemeParameter objects that represent all the partition scheme parameters defined on the partition scheme.
Öffentliche KlassePayloadThe Payload object represents a SQL Server HTTP endpoint payload.
Öffentliche KlassePercentCompleteEventArgsThe PercentCompleteEventArgs object represents the arguments passed by the event raised when a process reaches a percent complete marker.
Öffentliche KlassePerformanceCountersA PerformanceCounters object represents a performance counter that is used to trace the performance of the instance of SQL Server.
Öffentliche KlassePermissionInfoDie PermissionInfo-Klasse stellt Informationen zu gewährten oder verweigerten Berechtigungen bereit.
Öffentliche KlassePermissionSetBaseDie PermissionSetBase-Klasse ist eine Basisklasse, die von Berechtigungssatzklassen geerbt wird.
Öffentliche KlassePhysicalPartitionThe PhysicalPartition object represents the physical partition where the data and meta data is stored for a SQL Server object.
Öffentliche KlassePhysicalPartitionCollectionThe PhysicalPartitionCollection class represents a collection of PhysicalPartition objects that represent all the physical partitions that are defined on an object.
Öffentliche KlassePlanGuideCreates a plan guide object: PlanGuide
Öffentliche KlassePlanGuideCollectionCollection of plan guide objects.
Öffentliche KlassePlanGuideExtenderExtends the Property set for a Plan Guide
Öffentliche KlasseProgressReportEventArgsThe 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 KlassePropertyDas Property-Objekt ermöglicht programmgesteuerten Zugriff auf die Eigenschaften aller SMO-Objekte.
Öffentliche KlassePropertyCannotBeRetrievedExceptionThe PropertyCannotBeRetrievedException class represents the exception raised when a property cannot be retrieved.
Öffentliche KlassePropertyCollectionThe PropertyCollection class represents a collection of Property objects that represent all the properties defined on the parent object.
Öffentliche KlassePropertyNotSetExceptionThe PropertyNotSetException class represents the exception that is raised when a property value has not been set.
Öffentliche KlassePropertyReadOnlyExceptionThe PropertyReadOnlyException class represents the exception that is raised when an attempt is made to set a read-only property.
Öffentliche KlassePropertyTypeMismatchExceptionThe 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 KlassePropertyWriteExceptionThe PropertyWriteException class represents the exception that is raised when an error occurs when setting the value of a property.
Öffentliche KlasseProtocolThe Protocol object provides programmatic access to the protocols supported by SQL Server.
Öffentliche KlasseRelocateFileThe RelocateFile object is a programmatic tool that lets a file be relocated.
Öffentliche KlasseResourceGovernorResourceGovernor class.
Öffentliche KlasseResourcePoolResource Pool Class
Öffentliche KlasseResourcePoolCollectionRepresents a collection of Resource Pools.
Öffentliche KlasseRestoreThe Restore object provides programmatic access to restore operations.
Öffentliche KlasseRuleThe Rule object provides programmatic access to a SQL Server rule.
Öffentliche KlasseRuleCollectionThe RuleCollection class represents a collection of Rule objects that represent all the rules defined on the instance of SQL Server.
Öffentliche KlasseSchemaThe Schema object represents an ownership context for a SQL Server database object.
Öffentliche KlasseSchemaCollectionThe SchemaCollection class represents a collection of Schema objects that represent all the schemas on the referenced database.
Öffentliche KlasseSchemaCollectionBaseThe SchemaCollectionBase class is a base class that is inherited by the SchemaCollection class.
Öffentliche KlasseSchemaCustomResolverRepresents a diagram of a COM-based resolver.
Öffentliche KlasseSchemaEventsThe SchemaEvents object represents the settings required for SQL Server schema event notification.
Öffentliche KlasseScripterThe Scripter object is the overall, top-level object for managing scripting operations.
Öffentliche KlasseScriptingErrorEventArgsThe ScriptingErrorEventArgs object provides programmatic access to the arguments used to report the errors that occur during scripting operations.
Öffentliche KlasseScriptingOptionsThe ScriptingOptions object provides programmatic options to the options that can be set for scripting operations.
Öffentliche KlasseScriptNameObjectBaseThe ScriptNameObjectBase is a base class inherited by classes that can use an alternative name used in scripting operations.
Öffentliche KlasseScriptOptionDas ScriptOption-Objekt stellt die SQL Server-Skriptoptionen dar, die in Optionen zur Skripterstellung enthalten sein können, die mit dem ScriptingOptions-Objekt festgelegt werden.
Öffentliche KlasseScriptSchemaObjectBaseScriptSchemaObjectBase ist eine Basisklasse, die von Klassen geerbt wird, die einen alternativen, in Skriptvorgängen verwendeten Namen verwenden können.
Öffentliche KlasseServerDas Server-Objekt stellt eine SQL Server-Instanz dar.
Öffentliche KlasseServerActiveDirectoryThe ServerActiveDirectory object provides programmatic access to the Active Directory functionality.
Öffentliche KlasseServerAdapterThis class aggregates otherwise hidden server properties.
Öffentliche KlasseServerAdapterBaseA ServerAdapterBase object is a base class that is used in the construction of the ServerAdapter class.
Öffentliche KlasseServerAuditSpecificationThe ServerAuditSpecification object represents an auditable event on the instance of SQL Server.
Öffentliche KlasseServerAuditSpecificationCollectionThe ServerAuditSpecificationCollection class represents a collection of ServerAuditSpecification objects that represent all the audit specifications defined on the server.
Öffentliche KlasseServerAuditSpecificationExtenderAdds methods and properties to the ServerAuditSpecification object.
Öffentliche KlasseServerConfigurationAdapterExposes methods to refresh and alter server configuration properties.
Öffentliche KlasseServerDdlTriggerThe ServerDdlTrigger object represents a SQL Server data definition language (DDL) trigger.
Öffentliche KlasseServerDdlTriggerCollectionThe ServerDdlTriggerCollection class represents a collection of ServerDdlTrigger objects that represent all the server data definition language (DDL) triggers defined on a table.
Öffentliche KlasseServerDdlTriggerEventThe ServerDdlTriggerEvent object represents the Microsoft SQL Server data definition language (DDL) trigger events that can be included in a server DDL trigger event set.
Öffentliche KlasseServerDdlTriggerEventSetThe ServerDdlTriggerEventSet object represents a set of SQL Server server data definition language (DDL) trigger events.
Öffentliche KlasseServerEventThe ServerEvent object represents the SQL Server server events that can be included in a server event set.
Öffentliche KlasseServerEventArgsThe 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 KlasseServerEventsThe ServerEvents object represents the settings required for SQL Server server-level event notification.
Öffentliche KlasseServerEventSetThe ServerEventSet object represents a set of server events on an instance of SQL Server.
Öffentliche KlasseServerPermissionThe ServerPermission object represents a SQL Server server-level permission.
Öffentliche KlasseServerPermissionInfoThe ServerPermissionInfo object represents information about a SQL Server server-level permission.
Öffentliche KlasseServerPermissionSetThe ServerPermissionSet object represents a set of server permissions.
Öffentliche KlasseServerProxyAccountThe 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 KlasseServerRoleThe ServerRole object represents a Microsoft SQL Server security role.
Öffentliche KlasseServerRoleCollectionThe ServerRoleCollection class represents a collection of ServerRole objects that represent all the server roles that are defined on a table.
Öffentliche KlasseServerSecurityAdapterA security facet that extends ServerAdapterBase.
Öffentliche KlasseServerSelectionAdapterProvides selection options for an instance of SQL Server.
Öffentliche KlasseServerSetupAdapterA ServerSetupAdapter object represents a server setup adapter.
Öffentliche KlasseServerSurfaceAreaAdapterA ServerSurfaceAreaAdapter object represents a server surface area adapter.
Öffentliche KlasseServerTraceEventThe ServerTraceEvent object represents the SQL Server server trace events that can be included in a server trace event set.
Öffentliche KlasseServerTraceEventSetThe ServerTraceEventSet object represents a set server trace events.
Öffentliche KlasseServiceBrokerPayloadThe ServiceBrokerPayload object represents a SQL Server Service Broker payload.
Öffentliche KlasseServiceMasterKeyThe ServiceMasterKey object represents a Microsoft SQL Server service master key.
Öffentliche KlasseServiceQueueEventThe ServiceQueueEvent object represents the Service Broker service queue events that can be included in a service queue event set.
Öffentliche KlasseServiceQueueEventSetThe ServiceQueueEventSet object represents a set of SQL Server service queue events.
Öffentliche KlasseServiceRequestExceptionThe ServiceRequestException class represents the exception that is raised when an error occurs during a service request.
Öffentliche KlasseSettingsDas Settings-Objekt stellt eine Gruppe konfigurierbarer Einstellungen für die SQL Server-Instanz dar.
Öffentliche KlasseSfcDependencyExceptionThe SfcDependencyException class represents an exception thrown by an SFC dependency operation fails.
Öffentliche KlasseSimpleObjectCollectionBaseThe SimpleObjectCollectionBase class is a base class that is used in the construction of collection objects.
Öffentliche KlasseSmoApplicationThe SmoApplication class represents an SMO application with respect to event management.
Öffentliche KlasseSmoCollectionBaseThe 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 KlasseSmoDmfAdapterImplements Evaluate(IBaseManagementFacet)
Öffentliche KlasseSmoEventArgsThe SmoEventArgs object provides programmatic access to the arguments used to report the events that occur in SMO applications.
Öffentliche KlasseSmoExceptionThe SmoException class represents the exception that is raised when an error occurs during an SMO operation.
Öffentliche KlasseSmoObjectBaseThe SmoObjectBase is a base class that is inherited by the SqlSmoObject class.
Öffentliche KlasseSmoObjectExtender<(Of <(<'T>)>)>The SmoObjectExtender<(Of <(<'T>)>)> class adds methods and properties to an SqlSmoObject class instance.
Öffentliche KlasseSoapMethodCollectionBaseThe 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 KlasseSoapMethodObjectThe SoapMethodObject class provides programmatic access to the referenced SOAP method.
Öffentliche KlasseSoapPayloadThe SoapPayload object represents a SQL Server SOAP payload.
Öffentliche KlasseSoapPayloadMethodThe SoapPayloadMethod class represents a SOAP payload method for the referenced HTTP endpoint.
Öffentliche KlasseSoapPayloadMethodCollectionThe SoapPayloadMethodCollection class represents a collection of SoapPayloadMethod objects that represent all the SOAP payload methods defined on a table.
Öffentliche KlasseSortedListCollectionBaseThe SortedListCollectionBase class is a base class that is used in the construction of sorted list collection classes.
Öffentliche KlasseSqlAssemblyThe SqlAssembly class represents an assembly in the Microsoft .NET environment.
Öffentliche KlasseSqlAssemblyCollectionThe SqlAssemblyCollection class represents a collection of SqlAssembly objects that represent all the assemblies defined on a table.
Öffentliche KlasseSqlAssemblyEventDas SqlAssemblyEvent-Objekt stellt die SQL Server-Assemblyereignisse dar, die in einen Assemblyereignissatz aufgenommen werden können.
Öffentliche KlasseSqlAssemblyEventsThe SqlAssemblyEvents object represents the settings that are required for SQL Server assembly event notification.
Öffentliche KlasseSqlAssemblyEventSetThe SqlAssemblyEventSet object represents a set of assembly events.
Öffentliche KlasseSqlAssemblyFileThe SqlAssemblyFile object represents an assembly file that stores an assembly.
Öffentliche KlasseSqlAssemblyFileCollectionThe SqlAssemblyFileCollection class represents a collection of SqlAssemblyFile objects that represent all the assembly files that are defined on a table.
Öffentliche KlasseSqlPropertyCollectionThe SqlPropertyCollection class is an abstract class that is used in the management of object properties.
Öffentliche KlasseSqlPropertyInfoThe SqlPropertyInfo class is an abstract class used to store information about properties.
Öffentliche KlasseSqlServerRegistrations Veraltet Represents registered instances of SQL Server.
Öffentliche KlasseSqlSmoObjectDas SqlSmoObject-Objekt stellt alle SQL Server-Objekte dar.
Öffentliche KlasseStatisticThe Statistic class represents a SQL Server statistic counter.
Öffentliche KlasseStatisticCollectionThe StatisticCollection class represents a collection of Statistic objects that represent all the statistic counters defined on the table or view.
Öffentliche KlasseStatisticColumnThe StatisticColumn object represents a column defined in a SQL Server statistics counter.
Öffentliche KlasseStatisticColumnCollectionThe StatisticColumnCollection class represents a collection of StatisticColumn objects that represent all the statistic columns defined on a table.
Öffentliche KlasseStatisticEventsThe StatisticEvents object represents the settings required for SQL Server statistic counter event notification.
Öffentliche KlasseStoredProcedureDas StoredProcedure-Objekt stellt eine gespeicherte SQL Server-Prozedur dar.
Öffentliche KlasseStoredProcedureCollectionThe StoredProcedureCollection class represents a collection of StoredProcedure objects that represent all the stored procedures that are defined on a table.
Öffentliche KlasseStoredProcedureEventThe StoredProcedureEvent object represents the SQL Server stored procedure events that can be included in an stored procedure event set.
Öffentliche KlasseStoredProcedureEventsThe StoredProcedureEvents object represents the settings that are required for SQL Server stored procedure event notification.
Öffentliche KlasseStoredProcedureEventSetThe StoredProcedureEventSet object represents a set of stored procedure events.
Öffentliche KlasseStoredProcedureParameterThe StoredProcedureParameter object represents a SQL Server stored procedure parameter.
Öffentliche KlasseStoredProcedureParameterCollectionThe StoredProcedureParameterCollection class represents a collection of StoredProcedureParameter objects that represent all the stored procedure parameters defined on a table.
Öffentliche KlasseSymmetricKeyThe SymmetricKey object represents a SQL Server symmetric key.
Öffentliche KlasseSymmetricKeyCollectionThe SymmetricKeyCollection class represents a collection of SymmetricKey objects that represent all the symmetric keys on the referenced database.
Öffentliche KlasseSymmetricKeyEncryptionThe SymmetricKeyEncryption class represents the encryption type used when encrypting symmetric keys.
Öffentliche KlasseSynonymThe Synonym object represents a SQL Server synonym.
Öffentliche KlasseSynonymCollectionThe SynonymCollection class represents a collection of Synonym objects that represent all the synonyms on the referenced database.
Öffentliche KlasseSynonymEventsThe SynonymEvents object represents the settings that are required for SQL Server synonym event notification.
Öffentliche KlasseSystemDataTypeThe SystemDataType object represents a supported system data type. The SystemDataTypeCollection represents all the supported system data types.
Öffentliche KlasseSystemDataTypeCollectionThe SystemDataTypeCollection class represents a collection of SystemDataType objects that represent all the system data types on the referenced database.
Öffentliche KlasseSystemMessageThe SystemMessage object represents messages defined by the system.
Öffentliche KlasseSystemMessageCollectionThe SystemMessageCollection class represents a collection of SystemMessage objects that represent all the system messages on the instance of SQL Server.
Öffentliche KlasseTableDas Table-Objekt stellt eine SQL Server-Tabelle dar.
Öffentliche KlasseTableCollectionThe TableCollection class represents a collection of Table objects that represent all the tables on the referenced database.
Öffentliche KlasseTableEventThe TableEvent object represents the SQL Server table events that can be included in a table event set.
Öffentliche KlasseTableEventsThe TableEvents object represents the settings required for SQL Server table event notification.
Öffentliche KlasseTableEventSetThe TableEventSet object represents a set of table events.
Öffentliche KlasseTableViewBaseThe 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 KlasseTableViewTableTypeBaseBasisklasse für Tabellensichttypen.
Öffentliche KlasseTcpProtocolThe TcpProtocol object provides programmatic access to the protocols supported by Microsoft SQL Server.
Öffentliche KlasseTransferThe Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.
Öffentliche KlasseTriggerDas Trigger-Objekt stellt einen SQL Server-Trigger dar.
Öffentliche KlasseTriggerCollectionThe TriggerCollection class represents a collection of Trigger objects that represent all the triggers defined on a table.
Öffentliche KlasseTriggerEventsThe TriggerEvents object represents the settings that are required for SQL Server trigger event notification.
Öffentliche KlasseUnknownPropertyExceptionThe UnknownPropertyException class represents the exception that is raised when an SMO operation encounters an unknown property.
Öffentliche KlasseUnsupportedEngineTypeExceptionThe UnsupportedEngineTypeException class represents the exception raised when an SMO operation is attempted on a Database Engine type that does not support that operation. A Database Engine type is either an instance of the SQL Server Database Engine (Datenbankmodul), or SQL Azure.
Öffentliche KlasseUnsupportedFeatureExceptionThe UnsupportedFeatureException class represents the exception raised when an SMO operation encounters a request for an unsupported feature.
Öffentliche KlasseUnsupportedObjectNameExceptionThe UnsupportedObjectNameException class represents the exception that is raised when an SMO operation encounters an unsupported object name.
Öffentliche KlasseUnsupportedVersionExceptionThe UnsupportedVersionException class represents the exception raised when an SMO operation encounters an unsupported version of SQL Server.
Öffentliche KlasseUrnCollectionThe UrnCollection class represents a collection of Urn objects that represent Uniform Resource Name (URN) addresses.
Öffentliche KlasseUserThe User object represents a SQL Server user.
Öffentliche KlasseUserCollectionThe UserCollection class represents a collection of User objects that represent all the database users defined on a database.
Öffentliche KlasseUserDefinedAggregateThe UserDefinedAggregate object represents a SQL Server user-defined aggregate.
Öffentliche KlasseUserDefinedAggregateCollectionThe UserDefinedAggregateCollection class represents a collection of UserDefinedAggregate objects that represent all the database user-defined aggregates that are defined on a database.
Öffentliche KlasseUserDefinedAggregateParameterThe UserDefinedAggregateParameter object represents the parameters that are used with a user-defined aggregate.
Öffentliche KlasseUserDefinedAggregateParameterCollectionThe UserDefinedAggregateParameterCollection class represents a collection of UserDefinedAggregateParameter objects that represent all the user-defined aggregate parameters that are defined on a table.
Öffentliche KlasseUserDefinedDataTypeThe UserDefinedDataType object represents a SQL Server user-defined data type.
Öffentliche KlasseUserDefinedDataTypeCollectionThe UserDefinedDataTypeCollection class represents a collection of UserDefinedDataType objects that represent all the user-defined data types defined on a table.
Öffentliche KlasseUserDefinedDataTypeResolverResolves objects of user-defined types.
Öffentliche KlasseUserDefinedFunctionDas UserDefinedFunction-Objekt stellt eine benutzerdefinierte SQL Server-Funktion dar.
Öffentliche KlasseUserDefinedFunctionCollectionThe UserDefinedFunctionCollection class represents a collection of UserDefinedFunction objects that represent all the user-defined functions that are defined on a table.
Öffentliche KlasseUserDefinedFunctionEventDas UserDefinedFunctionEvent-Objekt stellt die Ereignisse für benutzerdefinierte SQL Server-Funktionen dar, die in einen Ereignissatz für benutzerdefinierte Funktionen eingeschlossen werden können.
Öffentliche KlasseUserDefinedFunctionEventsThe UserDefinedFunctionEvents object represents the settings that are required for SQL Server user-defined function event notification.
Öffentliche KlasseUserDefinedFunctionEventSetThe UserDefinedFunctionEventSet object represents a SQL Server set of user-defined function events.
Öffentliche KlasseUserDefinedFunctionParameterThe UserDefinedFunctionParameter object represents a SQL Server user-defined function parameter.
Öffentliche KlasseUserDefinedFunctionParameterCollectionThe UserDefinedFunctionParameterCollection class represents a collection of UserDefinedFunctionParameter objects that represent all the user-defined function parameters that are defined on a table.
Öffentliche KlasseUserDefinedMessageThe UserDefinedMessage object represents a user-defined message.
Öffentliche KlasseUserDefinedMessageCollectionThe UserDefinedMessageCollection class represents a collection of UserDefinedMessage objects that represent all the user-defined messages defined on a table.
Öffentliche KlasseUserDefinedTableTypeThe UserDefinedTableType object represents a SQL Server user-defined table type data type.
Öffentliche KlasseUserDefinedTableTypeCollectionThe UserDefinedTableTypeCollection class represents a collection of UserDefinedTableType objects that represent all the user-defined table types that are defined on a database.
Öffentliche KlasseUserDefinedTableTypeResolverResolves the type of a user defined table to an Object.
Öffentliche KlasseUserDefinedTypeThe UserDefinedType represents an alias data type that is based on .NET data types.
Öffentliche KlasseUserDefinedTypeCollectionThe UserDefinedTypeCollection class represents a collection of UserDefinedType objects that represent all the alias data types that are defined on a table.
Öffentliche KlasseUserDefinedTypeEventsThe UserDefinedTypeEvents object represents the settings required for SQL Server user-defined type event notification.
Öffentliche KlasseUserDefinedTypeResolverResolves user-defined data types.
Öffentliche KlasseUserEventsThe UserEvents object represents the settings that are required for SQL Server database user event notification.
Öffentliche KlasseUserOptionsThe UserOptions object represents a set configurable server options that relate specifically to users.
Öffentliche KlasseVerifyCompleteEventArgsThe 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 KlasseVersionSerializationAdapterAdapts the serialization mode to the version of SQL Server in use.
Öffentliche KlasseViewThe View object represents a SQL Server view. 
Öffentliche KlasseViewCollectionThe ViewCollection class represents a collection of View objects that represent all the views defined on a table.
Öffentliche KlasseViewEventThe ViewEvent object represents the SQL Server view events that can be included in a view event set.
Öffentliche KlasseViewEventsThe ViewEvents object represents the settings that are required for SQL Server view event notification.
Öffentliche KlasseViewEventSetThe ViewEventSet object represents a set of view events.
Öffentliche KlasseWorkloadGroupThe WorkloadGroup class is represents a SQL Server workgroup, which contains a group of session requests. Workload groups allow aggregate monitoring of resource consumption and application of uniform policies to all requests in the group.
Öffentliche KlasseWorkloadGroupCollectionInitializes a workload group.
Öffentliche KlasseWrongPropertyValueExceptionThe WrongPropertyValueException class represents the exception that is raised when a property is assigned the wrong value.
Öffentliche KlasseXmlSchemaCollectionThe 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 KlasseXmlSchemaCollectionCollectionThe 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.

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

  SchnittstelleBeschreibung
Öffentliche SchnittstelleIColumnPermissionThe IColumnPermission class represents the interface that manages permissions for a specified column.
Öffentliche SchnittstelleIDatabaseMaintenanceFacetInterface that defined methods and properties for the database maintenance facet.
Öffentliche SchnittstelleIDatabaseOptionsInterface with properties that expose database options.
Öffentliche SchnittstelleIDatabasePerformanceFacetDefines methods and properties that can be used to measure and influence database performance.
Öffentliche SchnittstelleIDatabaseSecurityFacetSecurity facet interface.
Öffentliche SchnittstelleIExtendedPropertiesThe IExtendedProperties class is an interface that represents the collection of extended properties associated with an object.
Öffentliche SchnittstelleILoginOptionsThe ILoginOptions class is an interface that represents a collection of options associated with a login.
Öffentliche SchnittstelleIMultipartNameFacetInterface to deal with object names containing both the object and the schema.
Öffentliche SchnittstelleINameFacetRepresents the name facet interface.
Öffentliche SchnittstelleIObjectPermissionThe IObjectPermission class represents the interface used to set object permissions.
Öffentliche SchnittstelleIScriptableThe IScriptable class represents the interface used to create Transact-SQL scripts of SMO objects.
Öffentliche SchnittstelleIServerAuditFacetInterface that identifies audit facet members.
Öffentliche SchnittstelleIServerConfigurationFacetContains configuration information for interfaces based on the Configuration object.
Öffentliche SchnittstelleIServerInformationAn interface based on the Information type properties.
Öffentliche SchnittstelleIServerPerformanceFacetAn interface for the performance facet.
Öffentliche SchnittstelleIServerSecurityFacetAn interface that defines members for the SeverSecurityFacet.
Öffentliche SchnittstelleIServerSelectionFacetThe IServerSelectionFacet class contains members that represent the SQL Server policy-based management server selection facet objects.
Öffentliche SchnittstelleIServerSettingsAn interface for SQL Server 2008 Policy-Based Management that is based on Settings.
Öffentliche SchnittstelleIServerSetupFacetRepresents the Policy-Based Management facet interface for setting up an instance of SQL Server.
Öffentliche SchnittstelleISurfaceAreaFacetAn interface that defines surface area facet members.
Öffentliche SchnittstelleITableOptionsThe ITableOptions class is an interface that represents a collection of options that is associated with a table.
Öffentliche SchnittstelleITextObjectThe ITextObject class represents the interface that is used to implement text on objects.
Öffentliche SchnittstelleIUserOptionsThe IUserOptions class is an interface that represents a collection of options that is associated with a user.
Öffentliche SchnittstelleIViewOptionsThe IViewOptions class is an interface that represents a collection of options that is associated with a view.

  DelegatBeschreibung
Öffentlicher DelegatPercentCompleteEventHandlerThe PercentCompleteEventHandler class represents the event handler that is used to handle percent complete events.
Öffentlicher DelegatProgressReportEventHandlerThe ProgressReportEventHandler class represents the event handler that is used to handle progress report events.
Öffentlicher DelegatScriptingErrorEventHandlerThe ScriptingErrorEventHandler class represents the event handler that is used to handle scripting errors.
Öffentlicher DelegatScriptingFilterVerweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. Supplies filtering for scripts.
Öffentlicher DelegatServerEventHandlerThe ServerEventHandler class represents the event handler that is used to handle server errors.
Öffentlicher DelegatSmoApplication..::..AnyObjectEventHandlerThe SmoApplication..::..AnyObjectEventHandler class represents the event handler that is used to handle events from any object.
Öffentlicher DelegatSmoApplication..::..DatabaseEventHandlerThe SmoApplication..::..DatabaseEventHandler class represents the event handler that handles database events.
Öffentlicher DelegatSmoApplication..::..ObjectAlteredEventHandlerThe SmoApplication..::..ObjectAlteredEventHandler class represents the event handler that is used to handle events that occur when an object is altered.
Öffentlicher DelegatSmoApplication..::..ObjectCreatedEventHandlerThe SmoApplication..::..ObjectCreatedEventHandler class represents the event handler that is used to handle events when an object is created.
Öffentlicher DelegatSmoApplication..::..ObjectDroppedEventHandlerThe SmoApplication..::..ObjectDroppedEventHandler class represents the event handler that is used to handle events when an object is dropped.
Öffentlicher DelegatSmoApplication..::..ObjectRenamedEventHandlerThe SmoApplication..::..ObjectRenamedEventHandler class represents the event handler that handles events that occur when an object is renamed.
Öffentlicher DelegatVerifyCompleteEventHandlerThe VerifyCompleteEventHandler class represents the event handler that handles completion events.

  EnumerationBeschreibung
Öffentliche EnumerationActivationExecutionContextThe ActivationExecutionContext enumeration contains values that specify the security context used by a procedure. These procedures are activated by a service queue.
Öffentliche EnumerationAffinityTypeThe AffinityType enumeration represents the possible affinity settings for an instance of SQL Server.
Öffentliche EnumerationAssemblyAlterOptionsThe AssemblyAlterOptions enumeration contains values that are used to specify the addition options when modifying an assembly. The values are bit flag values, and they can be combined by adding the values.
Öffentliche EnumerationAssemblySecurityLevelThe AssemblySecurityLevel enumeration contains values that are used to specify the access rights for an assembly.
Öffentliche EnumerationAsymmetricKeyEncryptionAlgorithmThe AsymmetricKeyEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an asymmetric key.
Öffentliche EnumerationAsymmetricKeySourceTypeThe AsymmetricKeySourceType enumeration contains values that are used to specify the source type used to load an asymmetric key.
Öffentliche EnumerationAttachOptionsThe AttachOptions enumeration contains values that are used to specify attach options.
Öffentliche EnumerationAuditActionTypeThe AuditActionType enumeration contains values that are used to specify the audit action types.
Öffentliche EnumerationAuditDestinationTypeThe AuditDestination enumeration contains values that are used to specify the destination, to which the results of a SQL Server Audit are sent.
Öffentliche EnumerationAuditFileSizeUnitThe AuditFileSizeUnit enumeration contains values that are used to specify the unit that specifies the size of the audit file.
Öffentliche EnumerationAuditLevelThe AuditLevel enumeration contains values that are used to specify the SQL Server audit level setting.
Öffentliche EnumerationAuditStatusTypeThe AuditStatusType enumeration contains values that are used to specify the status of the audit.
Öffentliche EnumerationBackupActionTypeThe BackupActionType enumeration contains values that are used to specify the type of backup.
Öffentliche EnumerationBackupCompressionOptionsThe BackupCompressionOptions enumeration contains values that are used to specify the backup compression option.
Öffentliche EnumerationBackupDeviceTypeThe BackupDeviceType enumeration contains values that are used to specify the backup device type.
Geschützte EnumerationBackupRestoreBase..::..AsyncOperationThe BackupRestoreBase..::..AsyncOperation enumeration contains values that are used to specify which backup components are running asynchronously.
Öffentliche EnumerationBackupSetFlagThe BackupSetFlag enumeration contains values that are used to specify the purpose of the backup.
Öffentliche EnumerationBackupSetTypeThe BackupSetType enumeration contains values that are used to specify the backup type.
Öffentliche EnumerationBackupTruncateLogTypeThe BackupTruncateLogType enumeration contains values that are used to specify the truncate action taken on the log.
Öffentliche EnumerationCatalogPopulationActionThe CatalogPopulationAction enumeration contains values that are used to specify the method used to populate a full-text catalog.
Öffentliche EnumerationCatalogPopulationStatusThe CatalogPopulationStatus enumeration contains values that are used to specify the status of the full-text catalog.
Öffentliche EnumerationCertificateSourceTypeThe CertificateSourceType enumeration contains values that are used to specify the source of the certificate.
Öffentliche EnumerationChangeTrackingThe ChangeTracking enumeration contains values that are used to specify change tracking in a full-text index.
Öffentliche EnumerationCollationVersionThe CollationVersion enumeration contains values that specify the collation versions.
Öffentliche EnumerationCompatibilityLevelThe CompatibilityLevel enumeration is a list of constant values that specify the behavior that corresponds to a version of SQL Server.
Öffentliche EnumerationCreateDispositionTypeThe CreateDispositionType enumeration contains values that are used to specify the source of the symmetric key.
Öffentliche EnumerationDatabaseDdlTriggerExecutionContextThe DatabaseDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the database DDL trigger runs.
Öffentliche EnumerationDatabaseEncryptionAlgorithmSpecifies the algorithm used to encrypt the database encryption key
Öffentliche EnumerationDatabaseEncryptionStateEnumerates the possible encryption states of a database.
Öffentliche EnumerationDatabaseEncryptionTypeThe DatabaseEncryptionType enumeration contains values that are used to specify the encryption types.
Öffentliche EnumerationDatabaseEventTypeThe DatabaseEventType enumeration is a list of constant values that specify the database event type.
Öffentliche EnumerationDatabaseObjectTypesThe DatabaseObjectTypes enumeration is a list of constant values that specifies the types of database object.
Öffentliche EnumerationDatabasePermissionSetValueThe DatabasePermissionSetValue enumeration is a list of constant values that specify all the database permissions.
Öffentliche 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.
Öffentliche EnumerationDatabaseUserAccessThe DatabaseUserAccess enumeration is a list of constant values that specify how user access can be restricted.
Öffentliche EnumerationDataCompressionTypeThe DataCompressionType enumeration contains values that are used to specify the type of data compression used to store data on the physical partition.
Öffentliche EnumerationDependencyTypeDie DependencyType-Enumeration ist eine Liste konstanter Werte, mit denen die Richtung der Abhängigkeitsermittlung angegeben wird.
Öffentliche EnumerationDeviceTypeThe DeviceType enumeration is a list of constant values that specify the various different types of devices supported by SQL Server.
Öffentliche EnumerationEditionThe Edition enumeration is a list of constant values that specify the various different types of devices that are supported by SQL Server.
Öffentliche EnumerationEndpointAuthenticationOrderThe EndpointAuthenticationOrder enumeration contains values that are used to specify the authentication methods and order of preference for the endpoint connection.
Öffentliche EnumerationEndpointEncryptionThe EndpointEncryption enumeration contains values that are used to specify the state of encryption on the endpoint.
Öffentliche EnumerationEndpointEncryptionAlgorithmThe EndpointEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an endpoint.
Öffentliche EnumerationEndpointStateThe EndpointState enumeration is a list of constant values that specifies the state of the HTTP endpoint.
Öffentliche EnumerationEndpointTypeThe EndpointType enumeration is a list of constant values that specifies the type of HTTP endpoint.
Öffentliche EnumerationEventTypeThe EventType enumeration is a list of constant values that specify the various different types of events that are supported by SQL Server.
Öffentliche 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.
Öffentliche EnumerationExecutionStatusThe ExecutionStatus enumeration is a list of constant values that specify the status of an executing process.
Öffentliche EnumerationFileGrowthTypeThe FileGrowthType enumeration is a list of constant values that specify whether file growth is determined by percentage amount or by KB.
Öffentliche EnumerationFilestreamAccessLevelTypeThe FilestreamAccessLevelType enumeration contains values that are used to specify the type of access permitted on file stream operations.
Öffentliche EnumerationFileStreamEffectiveLevelThe FileStreamEffectiveLevel enumeration contains values that are used to specify the file stream level.
Öffentliche EnumerationFileStreamLevelThe FileStreamLevel enumeration contains values that are used to specify the file stream level.
Öffentliche 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.
Öffentliche EnumerationFragmentationOptionThe FragmentationOption enumeration is a list of constant values that specify the levels of detail of collected fragmentation information.
Öffentliche EnumerationFullTextCatalogUpgradeOptionThe FullTextCatalogUpgradeOption enumeration contains values that are used to specify the action taken when the full-text catalog is upgraded.
Öffentliche EnumerationHttpAuthenticationModesThe HttpAuthenticationModes enumeration contains values that specify the HTTP port for HTTP endpoints.
Öffentliche EnumerationHttpPortTypesThe HttpPortTypes enumeration contains values that are used to specify the type HTTP port.
Öffentliche 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.
Öffentliche 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.
Öffentliche EnumerationIndexKeyTypeThe IndexKeyType enumeration contains values that are used to specify the type of key on which the index is created.
Öffentliche EnumerationIndexOperationThe IndexOperation enumeration contains values that are used to specify index operations.
Öffentliche EnumerationIndexPopulationActionThe IndexPopulationAction enumeration contains values that are used to specify the type of Microsoft Search full-text index population.
Öffentliche EnumerationIndexPopulationStatusThe IndexPopulationStatus enumeration contains values that are used to specify the type of population in progress.
Öffentliche EnumerationInDoubtTransactionResolutionTypeEnumerates possible responses to in-doubt transactions.
Öffentliche EnumerationKeyEncryptionTypeThe KeyEncryptionType enumeration is a list of constant values that specify the key encryption type.
Öffentliche EnumerationLinkedTableTypeThe LinkedTableType enumeration contains values that specify the type of table accessed on a linked server.
Öffentliche EnumerationLinkFieldTypeThe LinkFieldType enumeration contains values that specify the type of link field.
Öffentliche EnumerationLockEscalationTypeAn enumeration that lists lock escalation types.
Öffentliche EnumerationLockRequestStatusThe LockRequestStatus enumeration contains constant values that specify the lock request status.
Öffentliche EnumerationLoginCreateOptionsThe LoginCreateOptions enumeration contains values that are used to specify the password options when you create a logon.
Öffentliche EnumerationLoginTypeThe LoginType enumeration contains values that are used to specify the authentication type and the Windows account type.
Öffentliche EnumerationLogReuseWaitStatusThe LogReuseWaitStatus enumeration contains values that specify the current operation on which the reuse of transaction log space is waiting.
Öffentliche EnumerationMappedClassTypeEnumerates credential mapping options.
Öffentliche 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.
Öffentliche EnumerationMethodLoginTypeThe MethodLoginType enumeration contains values that are used to specify the method used for logging on to the instance of SQL Server.
Öffentliche EnumerationMethodXsdSchemaOptionThe MethodXsdSchemaOption enumeration contains values that specify the XSD schema returned for a SOAP method.
Öffentliche EnumerationMirroringOptionThe MirroringOption enumeration contains values that specify the mirroring options for a database.
Öffentliche EnumerationMirroringRoleThe MirroringRole enumeration contains values that specify the role the database plays in mirroring.
Öffentliche EnumerationMirroringSafetyLevelThe MirroringSafetyLevel enumeration contains values that specify the safety guarantee on updates to the mirrored database.
Öffentliche EnumerationMirroringStatusThe MirroringStatus enumeration contains values that specify the state of a database regarding mirroring.
Öffentliche EnumerationMirroringWitnessStatusThe MirroringWitnessStatus enumeration contains values that specify the state of the mirroring witness.
Öffentliche EnumerationMonthThe Month enumeration contains constant values that specify the twelve calendar months.
Öffentliche EnumerationNSActivationStateThe NSActivationState enumeration contains constant values that specify the activation state of Notification Services.
Öffentliche EnumerationNumaNodeAffinityThe NumaNodeAffinity enumeration defines the affinity states for a Cpu object.
Öffentliche EnumerationObjectClassThe ObjectClass enumeration contains values that specify the SMO class type.
Öffentliche EnumerationObjectPermissionSetValueThe ObjectPermissionSetValue enumeration is a list of constant values that specify all the object permissions.
Öffentliche EnumerationOnFailureActionThe OnFailureAction enumeration contains values that specify the action to be taken when an audit fails.
Öffentliche EnumerationPageVerifyThe PageVerify enumeration contains constant values that specify the automatic page verification options for a database.
Öffentliche EnumerationPerfMonModeThe PerfMonMode enumeration contains values that are used to specify the polling behavior in Performance Monitor.
Öffentliche EnumerationPermissionStateThe PermissionState enumeration contains values that specify the state of a permission.
Öffentliche EnumerationPlanGuideTypeEnumerates the possible Plan Guide types.
Öffentliche EnumerationPrincipalTypeThe PrincipalType enumeration contains values that specify the type of user, role, or login.
Öffentliche 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.
Öffentliche 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.
Öffentliche EnumerationProtocolTypeThe ProtocolType enumeration contains values that are used to specify the type of protocol.
Öffentliche EnumerationProviderAuthenticationTypeSpecifies the type of authentication supported by Cryptographic Provider.
Öffentliche EnumerationRangeTypeThe RangeType enumeration contains values that are used to specify the type range.
Öffentliche EnumerationRecoveryModelThe RecoveryModel enumeration contains values that are used to specify the type of recovery model.
Öffentliche EnumerationRepairOptionsThe RepairOptions enumeration contains values that are used to specify the repair options that are used when checking data in a table.
Öffentliche EnumerationRepairStructureThe RepairRepairStructure enumeration contains values that are used to specify the type of repair options used when checking data in a table.
Öffentliche EnumerationRepairTypeThe RepairType enumeration contains values that are used to specify the type of repair mode used by the database consistency check (DBCC) functions.
Öffentliche EnumerationReplicationOptionsThe ReplicationOptions enumeration contains values that are used to specify the replication settings for the referenced database.
Öffentliche EnumerationResourceUsageThe ResourceUsage enumeration contains values that specify the relative operating system execution priority setting for the Microsoft Search service.
Öffentliche EnumerationRestoreActionTypeThe RestoreActionType enumeration contains values that are used to specify the type of action that is required during a data restore operation.
Öffentliche EnumerationRestoreTypeThe RestoreType enumeration contains values that specify the type of restore operation to perform.
Öffentliche EnumerationResultFormatThe ResultFormat enumeration contains values that specify the format in which to return results for an HTTP endpoint.
Öffentliche EnumerationRetentionPeriodUnitsEnumerates values that specify the units for the retention period.
Öffentliche EnumerationRoleTypesThe RoleTypes enumeration contains values that are used to specify the type of role.
Öffentliche EnumerationSecondaryXmlIndexTypeThe SecondaryXmlIndexType enumeration contains values that are used to specify the secondary XML index type.
Öffentliche EnumerationServerDdlTriggerExecutionContextThe ServerDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the server DDL trigger runs.
Öffentliche EnumerationServerLoginModeThe ServerLoginMode enumeration contains values that are used to specify the method used to connect to the instance of SQL Server.
Öffentliche EnumerationServerMirroringRoleThe ServerMirroringRole enumeration contains values that are used to specify the role of the instance of SQL Server when participating in mirroring.
Öffentliche EnumerationServerPermissionSetValueThe ServerPermissionSetValue enumeration is a list of constant values that specify all the database permissions.
Öffentliche EnumerationServerStatusThe ServerStatus enumeration contains values that are used to specify the status of the instance of SQL Server.
Öffentliche EnumerationServiceStartModeThe ServiceStartMode enumeration contains values that are used to specify the method that is used to start a service.
Öffentliche EnumerationShrinkMethodThe ShrinkMethod enumeration contains values that are used to specify the method that is used shrink a database file.
Öffentliche EnumerationSmoExceptionTypeThe SmoExceptionType enumeration contains values that are used to specify the type of SMO exception.
Öffentliche EnumerationSnapshotIsolationStateThe SnapshotIsolationState enumeration contains values that are used to specify the current state of snapshot isolation.
Öffentliche EnumerationSortOrderThe SortOrder enumeration contains values that specify how objects are sorted in an enumerated list.
Öffentliche EnumerationSpatialGeoLevelSizeEnumerates grid density levels for spatial indexes.
Öffentliche EnumerationSpatialIndexTypeEnumerates possible spatial index types.
Öffentliche EnumerationSqlDataTypeThe SqlDataType enumeration contains values that are used to specify a SQL Server data type.
Öffentliche EnumerationSqlServerVersionThe SqlServerVersion enumeration contains values that are used to specify the version of the referenced instance of SQL Server.
Öffentliche EnumerationSqlServerVersionsThe SqlServerVersions enumeration contains values that are used to specify the version of the referenced instance of SQL Server.
Öffentliche EnumerationSqlSmoStateThe SqlSmoState enumeration contains values that are used to specify the state of an SMO object.
Öffentliche EnumerationSqlVerifyActionThe SqlVerifyAction enumeration contains values that are used to specify the type of backup verification.
Öffentliche 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.
Öffentliche EnumerationStatisticsTargetThe StatisticsTarget enumeration contains values that specify the type of statistic that is targeted for the update operation.
Öffentliche EnumerationStopListOptionThe StopListOption enumeration contains values that are used to specify the way in which a new stop list is created.
Öffentliche EnumerationSymmetricKeyEncryptionAlgorithmThe SymmetricKeyEncryptionAlgorithm enumeration contains values that specify the algorithm that is used to encrypt the symmetric key.
Öffentliche EnumerationSymmetricKeyEncryptionTypeThe SymmetricKeyEncryptionType enumeration contains constant values that specify the type of symmetric key encryption.
Öffentliche EnumerationSynonymBaseTypeThe SynonymBaseType enumeration contains constant values that specify the type of synonym.
Öffentliche EnumerationTerminationClauseThe TerminationClause enumeration contains constant values that specify the action taken when transactions are terminated.
Öffentliche EnumerationTransactionTypesThe TransactionTypes enumeration contains constant values that specify the method of recording transactions.
Öffentliche EnumerationUrnIdOptionEnumerates URN identification options.
Öffentliche EnumerationUserDefinedFunctionTypeThe UserDefinedFunctionType enumeration is a list of constant values that specify the types of user-defined functions that are supported by SQL Server.
Öffentliche EnumerationUserDefinedTypeFormatThe UserDefinedTypeFormat enumeration is a list of constant values that specify the formats used by user-defined types.
Öffentliche EnumerationUserTypeThe UserType enumeration contains constant values that specify the security type for the user.
Öffentliche EnumerationWindowsLoginAccessTypeThe WindowsLoginAccessType enumeration contains constant values that specify the type of access a Windows login has to the instance of SQL Server.
Öffentliche EnumerationWorkloadGroupImportanceThe WorkloadGroupImportance enumeration contains values that specify the importance of workload groups.
Öffentliche EnumerationWsdlGeneratorOptionThe WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.
Öffentliche EnumerationXmlDocumentConstraintThe XmlDocumentConstraint enumeration contains constant values that specify the constraints imposed on an XML document.
Öffentliche EnumerationXmlFormatOptionThe WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.
Öffentliche EnumerationXmlTypeDerivationThe XmlTypeDerivation enumeration contains constant values that specify the XML type derivation.
Öffentliche EnumerationXmlTypeKindThe XmlTypeKind enumeration contains constant values that specify the kind of XML component.
Öffentliche EnumerationXsdSchemaOptionThe XsdSchemaOption enumeration contains constant values that specify whether an inline schema for the method result is returned in the SOAP response.

Community-Beiträge

HINZUFÜGEN
Anzeigen:
© 2014 Microsoft