Compartir a través de

  • Artículo

Server Miembros

The Server object represents an instance of SQL Server.

El tipo Server expone los siguientes miembros.

Constructores

  Nombre Descripción
Método publico Server() () () () Initializes a new instance of the Server class.
Método publico Server(String) Initializes a new instance of the Server class with the specified name.
Método publico Server(ServerConnection) Initializes a new instance of the Server class based on the specified connection.

Principio

Métodos

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

Principio

Campos

  Nombre Descripción
Campo protegido m_ExtendedProperties (Se hereda de SqlSmoObject).

Principio

Propiedades

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

Principio

Eventos

  Nombre Descripción
Evento público PropertyChanged (Se hereda de SqlSmoObject).
Evento público PropertyMetadataChanged (Se hereda de SqlSmoObject).

Principio