Partilhar via

  • Artigo

Membros Server

The Server object represents an instance of SQL Server.

O tipo Server expõe os seguintes membros.

Construtores

  Nome Descrição
Método público Server() () () () Initializes a new instance of the Server class.
Método público Server(String) Initializes a new instance of the Server class with the specified name.
Método público Server(ServerConnection) Initializes a new instance of the Server class based on the specified connection.

Início

Métodos

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

Início

Campos

  Nome Descrição
Campo protegido m_ExtendedProperties (Herdado de SqlSmoObject.)

Início

Propriedades

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

Início

Eventos

  Nome Descrição
Evento público PropertyChanged (Herdado de SqlSmoObject.)
Evento público PropertyMetadataChanged (Herdado de SqlSmoObject.)

Início