Freigeben über

  • Artikel

Server-Member

The Server object represents an instance of SQL Server.

Der Server-Typ macht die folgenden Member verfügbar.

Konstruktoren

  Name Beschreibung
Öffentliche Methode Server() () () () Initializes a new instance of the Server class.
Öffentliche Methode Server(String) Initializes a new instance of the Server class with the specified name.
Öffentliche Methode Server(ServerConnection) Initializes a new instance of the Server class based on the specified connection.

Zum Anfang

Methoden

  Name Beschreibung
Geschützte Methode AddDatabaseContext (Geerbt von SqlSmoObject.)
Öffentliche Methode Alter() () () () Updates any Server object property changes on the instance of SQL Server. 
Öffentliche Methode Alter(Boolean)
Geschützte Methode AlterImpl (Geerbt von SqlSmoObject.)
Geschützte Methode AlterImplFinish (Geerbt von SqlSmoObject.)
Geschützte Methode AlterImplInit (Geerbt von SqlSmoObject.)
Geschützte Methode AlterImplWorker (Geerbt von SqlSmoObject.)
Öffentliche Methode AttachDatabase(String, StringCollection) Attaches an existing database that is made up of one or more files to the instance of SQL Server with the specified name and using the specified data files. 
Öffentliche Methode AttachDatabase(String, StringCollection, AttachOptions)
Öffentliche Methode AttachDatabase(String, StringCollection, String) Attaches an existing database that is made up of one or more files to the instance of SQL Server with the specified name and using the specified data files. 
Öffentliche Methode AttachDatabase(String, StringCollection, String, AttachOptions)
Geschützte Methode BindDefaultImpl (Geerbt von SqlSmoObject.)
Geschützte Methode BindRuleImpl (Geerbt von SqlSmoObject.)
Geschützte Methode CheckCollation (Geerbt von SqlSmoObject.)
Geschützte Methode CheckObjectState() () () () Validates the state of the referenced object. (Geerbt von SqlSmoObject.)
Geschützte Methode CheckObjectState(Boolean) Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. (Geerbt von SqlSmoObject.)
Geschützte Methode CheckObjectStateImpl (Geerbt von SqlSmoObject.)
Geschützte Methode CheckVersion100 (Geerbt von SqlSmoObject.)
Geschützte Methode CheckVersion80 Checks the validity of the object on SQL Server 2000. (Geerbt von SqlSmoObject.)
Geschützte Methode CheckVersion80SP3 Checks the validity of the object on SQL Server 2000 SP3. (Geerbt von SqlSmoObject.)
Geschützte Methode CheckVersion90 Check the validity of the object on SQL Server 2005. (Geerbt von SqlSmoObject.)
Geschützte Methode CheckVersionBelow90 (Geerbt von SqlSmoObject.)
Geschützte Methode CleanObject (Geerbt von SqlSmoObject.)
Öffentliche Methode CompareUrn Compares two URNS.
Geschützte Methode CreateImpl (Geerbt von SqlSmoObject.)
Geschützte Methode CreateImplFinish (Geerbt von SqlSmoObject.)
Geschützte Methode CreateImplInit (Geerbt von SqlSmoObject.)
Öffentliche Methode DeleteBackupHistory(DateTime) Deletes the backup history for this instance of SQL Server up until the specified date and time.
Öffentliche Methode DeleteBackupHistory(Int32) Deletes the backup history for the specified media set.
Öffentliche Methode DeleteBackupHistory(String) Deletes the backup history for the specified database.
Öffentliche Methode Deny(ServerPermissionSet, String) Denies the specified set of permissions for the specified grantee on the instance of SQL Server.
Öffentliche Methode Deny(ServerPermissionSet, array<String> [] () [] []) Denies the specified set of permissions for the specified grantees on the instance of SQL Server.
Öffentliche Methode Deny(ServerPermissionSet, String, Boolean) Denies the specified set of permissions for the specified grantee and other users that the grantee granted the specified set of permissions on the instance of SQL Server.
Öffentliche Methode Deny(ServerPermissionSet, array<String> [] () [] [], Boolean) Denies the specified set of permissions for the specified grantees and other users that the grantee granted the specified set of permissions on the instance of SQL Server.
Öffentliche Methode DetachDatabase(String, Boolean) Detaches the specified database from the instance of SQL Server with the option to update statistics before the database is detached.
Öffentliche Methode DetachDatabase(String, Boolean, Boolean) Detaches the specified database from the instance of SQL Server with the option to update statistics before the database is detached.
Öffentliche Methode DetachedDatabaseInfo Returns information about a detached database file.
Öffentliche Methode Discover (Geerbt von SqlSmoObject.)
Geschützte Methode DropImpl (Geerbt von SqlSmoObject.)
Geschützte Methode DropImplWorker (Geerbt von SqlSmoObject.)
Öffentliche Methode EnumActiveCurrentSessionTraceFlags Gets active session flags as a DataTable.
Öffentliche Methode EnumActiveGlobalTraceFlags Gets a DataTable that contains active global trace flags.
Öffentliche Methode EnumAvailableMedia() () () () Enumerates a list of media that is visible to the instance of SQL Server on the local area network.
Öffentliche Methode EnumAvailableMedia(MediaTypes) Enumerates a list of media that is visible to the instance of SQL Server on the local area network and limited to the type of media specified.
Öffentliche Methode EnumCollations Enumerates a list of collations supported by the instance of SQL Server.
Öffentliche Methode EnumDatabaseMirrorWitnessRoles() () () () Enumerates a list of database mirror witness roles.
Öffentliche Methode EnumDatabaseMirrorWitnessRoles(String) Enumerates a list of mirror witness roles for the specified database.
Öffentliche Methode EnumDetachedDatabaseFiles Enumerates a list of detached database files.
Öffentliche Methode EnumDetachedLogFiles Enumerates a list of detached log files.
Öffentliche Methode EnumDirectories Enumerates a list of directories relative to the specified path.
Öffentliche Methode EnumErrorLogs Enumerates a list of SQL Server error log files.
Öffentliche Methode EnumLocks() () () () Enumerates a list of current locks held on the instance of SQL Server.
Öffentliche Methode EnumLocks(Int32) Enumerates a list of current locks held by the specified process on the instance of SQL Server.
Öffentliche Methode EnumMembers Enumerates a list of members of server roles and database roles on the instance of SQL Server.
Öffentliche Methode EnumObjectPermissions() () () () Enumerates a list of object permissions for the instance of SQL Server.
Öffentliche Methode EnumObjectPermissions(String) Enumerates a list of object permissions for a specified grantee on the application instance of SQL Server.
Öffentliche Methode EnumObjectPermissions(ObjectPermissionSet) Enumerates a list of object permissions for a specified permission on the instance of SQL Server.
Öffentliche Methode EnumObjectPermissions(String, ObjectPermissionSet) Enumerates a list of object permissions for a specified grantee and a specified permission on the instance of SQL Server.
Öffentliche Methode EnumPerformanceCounters() () () () Enumerates a list of performance counters that are supported by the instance of SQL Server.
Öffentliche Methode EnumPerformanceCounters(String) Enumerates a list of performance counters that are supported by the instance of SQL Server for a specified object.
Öffentliche Methode EnumPerformanceCounters(String, String) Enumerates a list of performance counters that are supported by the instance of SQL Server for a specified object and specified counter.
Öffentliche Methode EnumPerformanceCounters(String, String, String) Enumerates a list of performance counters that are supported by the instance of SQL Server for a specified object, for a specified counter, and on the specified instance of SQL Server.
Öffentliche Methode EnumProcesses() () () () Enumerates a list of processes running on the instance of SQL Server.
Öffentliche Methode EnumProcesses(Boolean) Enumerates a list of processes running on the instance of SQL Server with the option to exclude system processes.
Öffentliche Methode EnumProcesses(Int32) Enumerates a list of information about the specified process.
Öffentliche Methode EnumProcesses(String) Enumerates a list of processes running on the instance of SQL Server that are associated with the specified login.
Geschützte Methode EnumScriptImpl (Geerbt von SqlSmoObject.)
Geschützte Methode EnumScriptImplWorker (Geerbt von SqlSmoObject.)
Öffentliche Methode EnumServerAttributes Enumerates a list of server attributes for the instance of SQL Server.
Öffentliche Methode EnumServerPermissions() () () () Enumerates a list of server permissions for the instance of SQL Server.
Öffentliche Methode EnumServerPermissions(String) Enumerates a list of server permissions for a specified grantee on the instance of SQL Server.
Öffentliche Methode EnumServerPermissions(ServerPermissionSet) Enumerates a list of server permissions for a specified permission on the instance of SQL Server.
Öffentliche Methode EnumServerPermissions(String, ServerPermissionSet) Enumerates a list of server permissions for a specified grantee and a specified permission on the instance of SQL Server.
Öffentliche Methode EnumStartupProcedures Enumerates a list of startup procedures.
Öffentliche Methode EnumWindowsDomainGroups() () () () Enumerates a list of Microsoft Windows group accounts defined on a domain.
Öffentliche Methode EnumWindowsDomainGroups(String) Enumerates a list of Microsoft Windows group accounts defined for the specified domain.
Öffentliche Methode EnumWindowsGroupInfo() () () () Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server.
Öffentliche Methode EnumWindowsGroupInfo(String) Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server.
Öffentliche Methode EnumWindowsGroupInfo(String, Boolean) Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server and with the option to list the individual members.
Öffentliche Methode EnumWindowsUserInfo() () () () Enumerates a list of information about all Microsoft Windows users that have explicitly granted access to SQL Server.
Öffentliche Methode EnumWindowsUserInfo(String) Enumerates a list of information about all Microsoft Windows users that have explicitly granted access to the instance of SQL Server.
Öffentliche Methode EnumWindowsUserInfo(String, Boolean) Enumerates a list of information about all Microsoft Windows users that have explicitly granted access to the instance of SQL Server and with the option to list all the permissions paths (groups) through which the user has been granted access to the instance of SQL Server.
Öffentliche Methode Equals (Geerbt von Object.)
Geschützte Methode Finalize (Geerbt von Object.)
Geschützte Methode FormatSqlVariant (Geerbt von SqlSmoObject.)
Geschützte Methode GenerateDataSpaceFileStreamScript (Geerbt von SqlSmoObject.)
Geschützte Methode GenerateDataSpaceScript (Geerbt von SqlSmoObject.)
Öffentliche Methode GetActiveDBConnectionCount Returns the number of active connections for the specified database.
Geschützte Methode GetBindDefaultScript (Geerbt von SqlSmoObject.)
Geschützte Methode GetBindRuleScript (Geerbt von SqlSmoObject.)
Geschützte Methode GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Geerbt von SqlSmoObject.)
Geschützte Methode GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (Geerbt von SqlSmoObject.)
Geschützte Methode GetDateTimeParameter (Geerbt von SqlSmoObject.)
Geschützte Methode GetDateTimeParameterAsInt (Geerbt von SqlSmoObject.)
Geschützte Methode GetDBName Gets the database name that is associated with the object. (Geerbt von SqlSmoObject.)
Öffentliche Methode GetDefaultInitFields Returns the property types that are initialized by default when the specified object is initialized.
Geschützte Methode GetEnumParameter (Geerbt von SqlSmoObject.)
Geschützte Methode GetFragOptionString (Geerbt von SqlSmoObject.)
Geschützte Methode GetGuidParameter (Geerbt von SqlSmoObject.)
Öffentliche Methode GetHashCode (Geerbt von Object.)
Geschützte Methode GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Geerbt von SqlSmoObject.)
Geschützte Methode GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (Geerbt von SqlSmoObject.)
Öffentliche Methode GetPropertyNames Returns the names of the initialized properties for the specified object type
Geschützte Methode GetPropValue (Geerbt von SqlSmoObject.)
Geschützte Methode GetPropValueOptional (Geerbt von SqlSmoObject.)
Geschützte Methode GetPropValueOptionalAllowNull (Geerbt von SqlSmoObject.)
Geschützte Methode GetRealValue (Geerbt von SqlSmoObject.)
Geschützte Methode GetScriptingOptionsForCreate (Geerbt von SqlSmoObject.)
Geschützte Methode GetServerName Gets the name of the instance of SQL Server with which the object is associated. (Geerbt von SqlSmoObject.)
Geschützte Methode GetServerObject (Geerbt von SqlSmoObject.)
Öffentliche Methode GetSmoObject Gets a SqlSmoObject that is specified by a URN.
Geschützte Methode GetSqlServerVersionName Gets the version name of the instance of SQL Server with which the object is associated. (Geerbt von SqlSmoObject.)
Öffentliche Methode GetStringComparer Gets an IComparer interface.
Geschützte Methode GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Geerbt von SqlSmoObject.)
Geschützte Methode GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (Geerbt von SqlSmoObject.)
Geschützte Methode GetTimeSpanParameterAsInt (Geerbt von SqlSmoObject.)
Öffentliche Methode GetType (Geerbt von Object.)
Geschützte Methode GetUrnRecursive(StringBuilder) (Geerbt von SqlSmoObject.)
Geschützte Methode GetUrnRecursive(StringBuilder, UrnIdOption) (Geerbt von SqlSmoObject.)
Öffentliche Methode Grant(ServerPermissionSet, String) Grants the specified set of permissions to the specified grantee on the instance of SQL Server.
Öffentliche Methode Grant(ServerPermissionSet, array<String> [] () [] []) Grants the specified set of permissions to the specified grantees on the instance of SQL Server.
Öffentliche Methode Grant(ServerPermissionSet, String, Boolean) Grants access to the specified permission to the grantee and the ability to grant access to other users on the instance of SQL Server.
Öffentliche Methode Grant(ServerPermissionSet, array<String> [] () [] [], Boolean) Grants access to the specified permission to the grantees and the ability to grant access to other users on the instance of SQL Server.
Öffentliche Methode Grant(ServerPermissionSet, String, Boolean, String) Grants the specified set of permissions to the grantee and the ability to grant the set of permissions to other users on the instance of SQL Server under an assumed role.
Öffentliche Methode Grant(ServerPermissionSet, array<String> [] () [] [], Boolean, String) Grants the specified set of permissions to the grantees and the ability to grant the set of permissions to other users on the instance of SQL Server under an assumed role.
Geschützte Methode ImplInitialize (Geerbt von SqlSmoObject.)
Öffentliche Methode Initialize() () () () Initializes the object and forces the properties be loaded. (Geerbt von SqlSmoObject.)
Öffentliche Methode Initialize(Boolean) Initializes the object and forces the properties be loaded. (Geerbt von SqlSmoObject.)
Öffentliche Methode IsDetachedPrimaryFile Verifies whether the specified file is a primary (.mdf) database file.
Geschützte Methode IsObjectDirty Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. (Geerbt von SqlSmoObject.)
Geschützte Methode IsObjectInitialized Verifies whether the object has been initialized. (Geerbt von SqlSmoObject.)
Geschützte Methode IsObjectInSpace Verifies whether the object is isolated or connected to the instance of SQL Server. (Geerbt von SqlSmoObject.)
Geschützte Methode IsVersion80SP3 (Geerbt von SqlSmoObject.)
Öffentliche Methode IsWindowsGroupMember Verifies whether the specified Microsoft Windows user account is a member of the specified Windows group.
Öffentliche Methode KillAllProcesses Stops the all processes on the specified database.
Öffentliche Methode KillDatabase Deletes the specified database and drops any active connection.
Öffentliche Methode KillProcess Stops the specified process.
Geschützte Methode MarkDropped (Geerbt von SqlSmoObject.)
Geschützte Methode MarkForDropImpl (Geerbt von SqlSmoObject.)
Geschützte Methode MemberwiseClone (Geerbt von Object.)
Öffentliche Methode PingSqlServerVersion(String) Gets the version number of the instance of SQL Server.
Öffentliche Methode PingSqlServerVersion(String, String, String) Get the version number of the specified instance of SQL Server using the specified login and password to gain access.
Geschützte Methode PostAlter (Geerbt von SqlSmoObject.)
Geschützte Methode PostCreate (Geerbt von SqlSmoObject.)
Geschützte Methode PostDrop (Geerbt von SqlSmoObject.)
Öffentliche Methode ReadErrorLog() () () () Enumerates the SQL Server error log.
Öffentliche Methode ReadErrorLog(Int32) Enumerates the specified SQL Server error log.
Öffentliche Methode Refresh Refreshes the objects and properties on the Server object. (Überschreibt SqlSmoObject. . :: . .Refresh() () () ().)
Öffentliche Methode Revoke(ServerPermissionSet, String) Revokes a previously granted set of permissions from a list of grantees on the instance of SQL Server.
Öffentliche Methode Revoke(ServerPermissionSet, array<String> [] () [] []) Revokes a previously granted set of permissions from a list of grantees on the instance of SQL Server.
Öffentliche Methode Revoke(ServerPermissionSet, String, Boolean, Boolean) Revokes previously granted permissions from a grantee on the instance of SQL Server and any other users to whom the grantee has granted the specified set of permissions. The grantee is also given the ability to revoke the specified set of permissions from other users under an assumed role.
Öffentliche Methode Revoke(ServerPermissionSet, array<String> [] () [] [], Boolean, Boolean) Revokes previously granted permissions from grantees on the instance of SQL Server and any other users to whom the grantees have granted the specified set of permissions. The grantees are also given the ability to revoke the specified set of permissions from other users under an assumed role.
Öffentliche Methode Revoke(ServerPermissionSet, String, Boolean, Boolean, String) Revokes previously granted permissions from a grantee on the instance of SQL Server and any other users to whom the grantee has granted the specified set of permissions. The grantee is also given the ability to revoke the specified set of permissions from other users under an assumed role.
Öffentliche Methode Revoke(ServerPermissionSet, array<String> [] () [] [], Boolean, Boolean, String) Revokes previously granted permissions from grantees on the instance of SQL Server and any other users to whom the grantees have granted the specified set of permissions. The grantees are also given the ability to revoke the specified set of permissions from other users under an assumed role.
Öffentliche Methode Script() () () ()
Öffentliche Methode Script(ScriptingOptions)
Geschützte Methode ScriptAlter (Geerbt von SqlSmoObject.)
Geschützte Methode ScriptCreate (Geerbt von SqlSmoObject.)
Geschützte Methode ScriptDdl (Geerbt von SqlSmoObject.)
Geschützte Methode ScriptDrop (Geerbt von SqlSmoObject.)
Geschützte Methode ScriptImpl() () () () (Geerbt von SqlSmoObject.)
Geschützte Methode ScriptImpl(ScriptingOptions) (Geerbt von SqlSmoObject.)
Geschützte Methode ScriptImplWorker (Geerbt von SqlSmoObject.)
Öffentliche Methode SetDefaultInitFields(Boolean) Specifies that all properties are fetched when objects are instantiated.
Öffentliche Methode SetDefaultInitFields(Type, Boolean) Specifies all the properties are fetched when objects of the specified type are instantiated.
Öffentliche Methode SetDefaultInitFields(Type, StringCollection) Specifies the properties that are fetched when objects of the specified type are instantiated.
Öffentliche Methode SetDefaultInitFields(Type, array<String> [] () [] []) Specifies the properties that are fetched when objects of the specified type are instantiated.
Geschützte Methode SetParentImpl (Geerbt von SqlSmoObject.)
Öffentliche Methode SetTraceFlag Sets a trace flag.
Öffentliche Methode ToString Returns a String that represents the referenced object. (Geerbt von SqlSmoObject.)
Geschützte Methode TouchImpl (Geerbt von SqlSmoObject.)
Geschützte Methode UnbindDefaultImpl (Geerbt von SqlSmoObject.)
Geschützte Methode UnbindRuleImpl (Geerbt von SqlSmoObject.)
Öffentliche Methode Validate (Geerbt von SmoObjectBase.)

Zum Anfang

Felder

  Name Beschreibung
Geschütztes Feld m_ExtendedProperties (Geerbt von SqlSmoObject.)

Zum Anfang

Eigenschaften

  Name Beschreibung
Öffentliche Eigenschaft ActiveDirectory Gets information about the Active Directory settings for the instance of SQL Server.
Öffentliche Eigenschaft AuditLevel Gets or sets the AuditLevel property value.
Öffentliche Eigenschaft Audits Represents a collection of Audit objects. Each Audit object represents an audit log defined on the instance of SQL Server.
Öffentliche Eigenschaft BackupDevices Represents a collection of BackupDevice objects. Each BackupDevice object represents a backup device defined on the instance of SQL Server.
Öffentliche Eigenschaft BackupDirectory Gets or sets the BackupDirectory property value.
Öffentliche Eigenschaft BrowserServiceAccount Gets the service account that the Browser service runs under on the instance of SQL Server.
Öffentliche Eigenschaft BrowserStartMode Gets the start mode for the SQL Server Browser Service running on the instance of SQL Server.
Öffentliche Eigenschaft BuildClrVersion Gets the BuildClrVersion property value.
Öffentliche Eigenschaft BuildClrVersionString Gets the BuildClrVersionString property value.
Öffentliche Eigenschaft BuildNumber Gets the BuildNumber property value.
Öffentliche Eigenschaft Collation Gets the Collation property value.
Öffentliche Eigenschaft CollationID Gets the CollationID property value.
Öffentliche Eigenschaft ComparisonStyle Gets the ComparisonStype property value.
Öffentliche Eigenschaft ComputerNamePhysicalNetBIOS Gets the ComputerNamePhysicalNetBIOS property value.
Öffentliche Eigenschaft Configuration Gets the configuration options for the instance of SQL Server.
Öffentliche Eigenschaft ConnectionContext Gets the current server connection details for the instance of SQL Server.
Öffentliche Eigenschaft Credentials Represents a collection of Credential objects. Each Credential object represents a credential defined on the instance of SQL Server.
Öffentliche Eigenschaft CryptographicProviders Gets the CryptographicProviders property value.
Öffentliche Eigenschaft Databases Represents a collection of Database objects. Each Database object represents a database defined on the instance of SQL Server.
Öffentliche Eigenschaft DefaultFile Gets or sets the DefaultFile property value.
Öffentliche Eigenschaft DefaultLog Gets or sets the DefaultLog property value.
Öffentliche Eigenschaft DefaultTextMode Gets or sets the Boolean property value that specifies whether the default text mode is set for the instance of SQL Server.
Öffentliche Eigenschaft Edition Gets the Edition property value.
Öffentliche Eigenschaft Endpoints Represents a collection of Endpoint objects. Each Endpoint object represents an endpoint defined on the instance of SQL Server.
Öffentliche Eigenschaft EngineEdition Gets the EngineEdition property value.
Öffentliche Eigenschaft ErrorLogPath Gets the ErrorLogPath property value.
Öffentliche Eigenschaft Events Gets the server events that are associated with the instance of SQL Server.
Geschützte Eigenschaft ExecuteForScalar Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Geerbt von SqlSmoObject.)
Öffentliche Eigenschaft FilestreamLevel
Öffentliche Eigenschaft FilestreamShareName
Öffentliche Eigenschaft FullTextService Gets the Microsoft Search Full-Text service implementation for the instance of SQL Server.
Öffentliche Eigenschaft Information Gets information about the instance of SQL Server.
Öffentliche Eigenschaft InstallDataDirectory Gets the local Windows directory where the installation data is stored for the instance of SQL Server.
Öffentliche Eigenschaft InstallSharedDirectory Gets the remote shared directory where the installation data is stored for the instance of SQL Server.
Öffentliche Eigenschaft InstanceName Gets the instance name of the instance of SQL Server. 
Öffentliche Eigenschaft IsCaseSensitive Gets the IsCaseSensitive property value.
Öffentliche Eigenschaft IsClustered Gets the IsClustered property value.
Öffentliche Eigenschaft IsFullTextInstalled
Öffentliche Eigenschaft IsSingleUser Gets the IsSingleUser property value.
Geschützte Eigenschaft IsTouched Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Geerbt von SqlSmoObject.)
Öffentliche Eigenschaft JobServer Gets the SQL Server Agent associated with the instance of SQL Server.
Öffentliche Eigenschaft Language Gets the Language property value.
Öffentliche Eigenschaft Languages Represents a collection of Language objects. Each Language object represents an languages supported by the instance of SQL Server.
Öffentliche Eigenschaft LinkedServers Represents a collection of LinkedServer objects. Each LinkedServer object represents a linked server registered on the instance of SQL Server.
Öffentliche Eigenschaft LoginMode Gets or sets the ServerLoginMode property value.
Öffentliche Eigenschaft Logins Represents a collection of Login objects. Each Login object represents a login defined on the instance of SQL Server.
Öffentliche Eigenschaft Mail Gets the Microsoft SQL Mail service associated with the instance of SQL Server.
Öffentliche Eigenschaft MailProfile Gets or sets the MailProfile property value.
Öffentliche Eigenschaft MasterDBLogPath Get the MasterDBLogPath property value.
Öffentliche Eigenschaft MasterDBPath Gets the MasterDBPath property value.
Öffentliche Eigenschaft MaxPrecision Gets the MaxPrecision property value.
Öffentliche Eigenschaft Name Gets the name of the server, which is the physical machine name.
Öffentliche Eigenschaft NamedPipesEnabled Gets the Boolean value that specifies whether Named Pipes provider is enabled for client-server connectivity on the instance of SQL Server.
Öffentliche Eigenschaft NetName Gets the NetName property value.
Öffentliche Eigenschaft NumberOfLogFiles Gets or sets the NumberOfLogFiles property value.
Geschützte Eigenschaft ObjectInSpace Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (Geerbt von SqlSmoObject.)
Öffentliche Eigenschaft OleDbProviderSettings Gets the DbProviderSettings property value.
Öffentliche Eigenschaft OSVersion Gets the OSVersion property value.
Öffentliche Eigenschaft PerfMonMode Gets or sets the PerfMonMode property value.
Öffentliche Eigenschaft PhysicalMemory Gets the PhysicalMemory property value.
Öffentliche Eigenschaft Platform Gets the Platform property value.
Öffentliche Eigenschaft Processors Gets the Processors property value.
Öffentliche Eigenschaft Product Gets the Product property value.
Öffentliche Eigenschaft ProductLevel Gets the ProductLevel property value.
Öffentliche Eigenschaft Properties Gets a collection of Property objects that represent the object properties. (Geerbt von SqlSmoObject.)
Öffentliche Eigenschaft ProxyAccount Gets the proxy account associated with the instance of SQL Server.
Öffentliche Eigenschaft ResourceGovernor Gets the ResourceGovernor property value.
Öffentliche Eigenschaft ResourceLastUpdateDateTime Gets the ResourceLastUpdateDateTime property value.
Öffentliche Eigenschaft ResourceVersion Gets the ResourceVersion property.
Öffentliche Eigenschaft ResourceVersionString Gets the ResouceVersionString property value.
Öffentliche Eigenschaft Roles Represents a collection of ServerRole objects. Each ServerRole object represents a role defined on the instance of SQL Server.
Öffentliche Eigenschaft RootDirectory Gets the RootDirectory property value.
Geschützte Eigenschaft ScalarResult Gets the scalar result for the referenced object. (Geerbt von SqlSmoObject.)
Öffentliche Eigenschaft ServerAuditSpecifications
Öffentliche Eigenschaft ServerType Gets the server type for the instance of SQL Server.
Öffentliche Eigenschaft ServiceAccount Gets the service account under which the instance of SQL Server is running.
Öffentliche Eigenschaft ServiceInstanceId Gets the ID value that uniquely identifies the service instance for this instance of SQL Server.
Öffentliche Eigenschaft ServiceMasterKey Gets the service master key associated with the instance of SQL Server.
Öffentliche Eigenschaft ServiceName
Öffentliche Eigenschaft ServiceStartMode
Öffentliche Eigenschaft Settings Gets modifiable settings for the instance of SQL Server.
Öffentliche Eigenschaft SqlCharSet Gets the SqlCharSet property value.
Öffentliche Eigenschaft SqlCharSetName Gets the SqlCharSetName property value.
Öffentliche Eigenschaft SqlDomainGroup
Öffentliche Eigenschaft SqlSortOrder Gets the SqlSortOrder property value.
Öffentliche Eigenschaft SqlSortOrderName Gets the SqlSortOrderName property value.
Öffentliche Eigenschaft State Gets the state of the referenced object. (Geerbt von SmoObjectBase.)
Öffentliche Eigenschaft Status
Öffentliche Eigenschaft SystemDataTypes Represents a collection of SystemDataType objects. Each SystemDataType object represents a system data type defined on the instance of SQL Server.
Öffentliche Eigenschaft SystemMessages Represents a collection of SystemMessage objects. Each SystemMessage object represents a system message defined on the instance of SQL Server.
Öffentliche Eigenschaft TapeLoadWaitTime Gets or sets the TapeLoadWaitTime property value.
Öffentliche Eigenschaft TcpEnabled
Öffentliche Eigenschaft Triggers Represents a collection of ServerDdlTrigger objects. Each ServerDdlTrigger object represents a server data definition language (DDL) trigger that is defined on the instance of SQL Server.
Öffentliche Eigenschaft Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Geerbt von SqlSmoObject.)
Öffentliche Eigenschaft UserData Gets or sets user-defined data associated with the referenced object. (Geerbt von SmoObjectBase.)
Öffentliche Eigenschaft UserDefinedMessages Represents a collection of UserDefinedMessage objects. Each UserDefinedMessage object represents a user-defined message defined on the instance of SQL Server.
Öffentliche Eigenschaft UserOptions Gets the user options for the current connection to the instance of SQL Server.
Öffentliche Eigenschaft Version Gets the Version property value.
Öffentliche Eigenschaft VersionMajor Gets the VersionMajor property value.
Öffentliche Eigenschaft VersionMinor Gets the VersionMinor property value.
Öffentliche Eigenschaft VersionString Gets the VersionString property value.

Zum Anfang

Ereignisse

  Name Beschreibung
Öffentliches Ereignis PropertyChanged (Geerbt von SqlSmoObject.)
Öffentliches Ereignis PropertyMetadataChanged (Geerbt von SqlSmoObject.)

Zum Anfang