ServiceMasterKey 类

The ServiceMasterKey object represents a Microsoft SQL Server service master key.

继承层次结构

System. . :: . .Object
  Microsoft.SqlServer.Management.Smo. . :: . .SmoObjectBase
    Microsoft.SqlServer.Management.Smo. . :: . .SqlSmoObject
      Microsoft.SqlServer.Management.Smo..::..ServiceMasterKey

命名空间:  Microsoft.SqlServer.Management.Smo
程序集:  Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)

语法

声明
<SfcElementTypeAttribute("MasterKey")> _
Public NotInheritable Class ServiceMasterKey _
    Inherits SqlSmoObject
用法
Dim instance As ServiceMasterKey
[SfcElementTypeAttribute("MasterKey")]
public sealed class ServiceMasterKey : SqlSmoObject
[SfcElementTypeAttribute(L"MasterKey")]
public ref class ServiceMasterKey sealed : public SqlSmoObject
[<SealedAttribute>]
[<SfcElementTypeAttribute("MasterKey")>]
type ServiceMasterKey =  
    class
        inherit SqlSmoObject
    end
public final class ServiceMasterKey extends SqlSmoObject

ServiceMasterKey 类型公开以下成员。

属性

  名称 说明
受保护属性 ExecuteForScalar Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (从 SqlSmoObject 继承。)
受保护属性 IsTouched Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (从 SqlSmoObject 继承。)
受保护属性 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. (从 SqlSmoObject 继承。)
公共属性 Parent Gets the Server object that is the parent of the ServiceMasterKey object.
公共属性 Properties Gets a collection of Property objects that represent the object properties. (从 SqlSmoObject 继承。)
受保护属性 ScalarResult Gets the scalar result for the referenced object. (从 SqlSmoObject 继承。)
公共属性 State Gets the state of the referenced object. (从 SmoObjectBase 继承。)
公共属性 Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (从 SqlSmoObject 继承。)
公共属性 UserData Gets or sets user-defined data associated with the referenced object. (从 SmoObjectBase 继承。)

页首

方法

  名称 说明
受保护方法 AddDatabaseContext (从 SqlSmoObject 继承。)
受保护方法 AlterImpl (从 SqlSmoObject 继承。)
受保护方法 AlterImplFinish (从 SqlSmoObject 继承。)
受保护方法 AlterImplInit (从 SqlSmoObject 继承。)
受保护方法 AlterImplWorker (从 SqlSmoObject 继承。)
受保护方法 BindDefaultImpl (从 SqlSmoObject 继承。)
受保护方法 BindRuleImpl (从 SqlSmoObject 继承。)
公共方法 ChangeAccount Encrypts the service master key with the new, specified credentials.
受保护方法 CheckCollation (从 SqlSmoObject 继承。)
受保护方法 CheckObjectState() () () () Validates the state of the referenced object. (从 SqlSmoObject 继承。)
受保护方法 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. (从 SqlSmoObject 继承。)
受保护方法 CheckObjectStateImpl (从 SqlSmoObject 继承。)
受保护方法 CheckVersion100 (从 SqlSmoObject 继承。)
受保护方法 CheckVersion80 Checks the validity of the object on SQL Server 2000. (从 SqlSmoObject 继承。)
受保护方法 CheckVersion80SP3 Checks the validity of the object on SQL Server 2000 SP3. (从 SqlSmoObject 继承。)
受保护方法 CheckVersion90 Check the validity of the object on SQL Server 2005. (从 SqlSmoObject 继承。)
受保护方法 CheckVersionBelow90 (从 SqlSmoObject 继承。)
受保护方法 CleanObject (从 SqlSmoObject 继承。)
受保护方法 CreateImpl (从 SqlSmoObject 继承。)
受保护方法 CreateImplFinish (从 SqlSmoObject 继承。)
受保护方法 CreateImplInit (从 SqlSmoObject 继承。)
公共方法 Discover (从 SqlSmoObject 继承。)
受保护方法 DropImpl (从 SqlSmoObject 继承。)
受保护方法 DropImplWorker (从 SqlSmoObject 继承。)
受保护方法 EnumScriptImpl (从 SqlSmoObject 继承。)
受保护方法 EnumScriptImplWorker (从 SqlSmoObject 继承。)
公共方法 Equals (从 Object 继承。)
公共方法 Export Saves the service master key to the specified system path location with the specified password.
受保护方法 Finalize (从 Object 继承。)
受保护方法 FormatSqlVariant (从 SqlSmoObject 继承。)
受保护方法 GenerateDataSpaceFileStreamScript (从 SqlSmoObject 继承。)
受保护方法 GenerateDataSpaceScript (从 SqlSmoObject 继承。)
受保护方法 GetBindDefaultScript (从 SqlSmoObject 继承。)
受保护方法 GetBindRuleScript (从 SqlSmoObject 继承。)
受保护方法 GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (从 SqlSmoObject 继承。)
受保护方法 GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (从 SqlSmoObject 继承。)
受保护方法 GetDateTimeParameter (从 SqlSmoObject 继承。)
受保护方法 GetDateTimeParameterAsInt (从 SqlSmoObject 继承。)
受保护方法 GetDBName Gets the database name that is associated with the object. (从 SqlSmoObject 继承。)
受保护方法 GetEnumParameter (从 SqlSmoObject 继承。)
受保护方法 GetFragOptionString (从 SqlSmoObject 继承。)
受保护方法 GetGuidParameter (从 SqlSmoObject 继承。)
公共方法 GetHashCode (从 Object 继承。)
受保护方法 GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (从 SqlSmoObject 继承。)
受保护方法 GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (从 SqlSmoObject 继承。)
受保护方法 GetPropValue (从 SqlSmoObject 继承。)
受保护方法 GetPropValueOptional (从 SqlSmoObject 继承。)
受保护方法 GetPropValueOptionalAllowNull (从 SqlSmoObject 继承。)
受保护方法 GetRealValue (从 SqlSmoObject 继承。)
受保护方法 GetScriptingOptionsForCreate (从 SqlSmoObject 继承。)
受保护方法 GetServerName Gets the name of the instance of SQL Server with which the object is associated. (从 SqlSmoObject 继承。)
受保护方法 GetServerObject (从 SqlSmoObject 继承。)
受保护方法 GetSqlServerVersionName Gets the version name of the instance of SQL Server with which the object is associated. (从 SqlSmoObject 继承。)
受保护方法 GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (从 SqlSmoObject 继承。)
受保护方法 GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (从 SqlSmoObject 继承。)
受保护方法 GetTimeSpanParameterAsInt (从 SqlSmoObject 继承。)
公共方法 GetType (从 Object 继承。)
受保护方法 GetUrnRecursive(StringBuilder) (从 SqlSmoObject 继承。)
受保护方法 GetUrnRecursive(StringBuilder, UrnIdOption) (从 SqlSmoObject 继承。)
受保护方法 ImplInitialize (从 SqlSmoObject 继承。)
公共方法 Import Loads the service master key from the file located at the specified system path by using the specified password.
公共方法 Initialize() () () () Initializes the object and forces the properties be loaded. (从 SqlSmoObject 继承。)
公共方法 Initialize(Boolean) Initializes the object and forces the properties be loaded. (从 SqlSmoObject 继承。)
受保护方法 IsObjectDirty Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. (从 SqlSmoObject 继承。)
受保护方法 IsObjectInitialized Verifies whether the object has been initialized. (从 SqlSmoObject 继承。)
受保护方法 IsObjectInSpace Verifies whether the object is isolated or connected to the instance of SQL Server. (从 SqlSmoObject 继承。)
受保护方法 IsVersion80SP3 (从 SqlSmoObject 继承。)
受保护方法 MarkDropped (从 SqlSmoObject 继承。)
受保护方法 MarkForDropImpl (从 SqlSmoObject 继承。)
受保护方法 MemberwiseClone (从 Object 继承。)
受保护方法 PostAlter (从 SqlSmoObject 继承。)
受保护方法 PostCreate (从 SqlSmoObject 继承。)
受保护方法 PostDrop (从 SqlSmoObject 继承。)
公共方法 Recover Recovers a service master key, in case the service master key has been changed external to SQL Server.
公共方法 Refresh Refreshes the object and retrieves properties when the object is next accessed. (从 SqlSmoObject 继承。)
公共方法 Regenerate() () () () Regenerates the database master key by using the specified new password.
公共方法 Regenerate(Boolean) Regenerates the service master key with the option to force the regeneration, and removes all items that cannot be successfully decrypted.
受保护方法 ScriptAlter (从 SqlSmoObject 继承。)
受保护方法 ScriptCreate (从 SqlSmoObject 继承。)
受保护方法 ScriptDdl (从 SqlSmoObject 继承。)
受保护方法 ScriptDrop (从 SqlSmoObject 继承。)
受保护方法 ScriptImpl() () () () (从 SqlSmoObject 继承。)
受保护方法 ScriptImpl(ScriptingOptions) (从 SqlSmoObject 继承。)
受保护方法 ScriptImplWorker (从 SqlSmoObject 继承。)
受保护方法 SetParentImpl (从 SqlSmoObject 继承。)
公共方法 ToString Returns a String that represents the referenced object. (从 SqlSmoObject 继承。)
受保护方法 TouchImpl (从 SqlSmoObject 继承。)
受保护方法 UnbindDefaultImpl (从 SqlSmoObject 继承。)
受保护方法 UnbindRuleImpl (从 SqlSmoObject 继承。)
公共方法 Validate (从 SmoObjectBase 继承。)

页首

事件

  名称 说明
公共事件 PropertyChanged (从 SqlSmoObject 继承。)
公共事件 PropertyMetadataChanged (从 SqlSmoObject 继承。)

页首

字段

  名称 说明
受保护字段 m_ExtendedProperties (从 SqlSmoObject 继承。)

页首

显式接口实现

  名称 说明
显式接口实现私有方法 IAlienObjectDiscover (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObjectGetParent (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObjectGetProperty (从 SqlSmoObject 继承。)
显式接口实现私有方法 ISfcPropertyProviderGetPropertySet (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObjectGetUrn (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObjectResolve (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObjectSetProperty (从 SqlSmoObject 继承。)

页首

注释

A service master key is the lop layer in the encryption hierarchy. It is used to encrypt all the lower layers of the encryption hierarchy, such as database master keys, certificates, asymmetric and symmetric keys. The service master key is generated by Windows and secured by the Windows data protection API. It can only be opened by the Windows service account under which it was created, or by a user who knows both the service account name and its password.

To get the ServiceMasterKey object properties, users can be a member of the public fixed server role.

To set the ServiceMasterKey object properties, users must have CONTROL SERVER permission on the server or be a member of the sysadmin fixed server role.

To back up or restore the service master key, users must have CONTROL SERVER permission on the server or be a member of the sysadmin fixed server role.

示例

使用加密

线程安全

此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。