共用方式為


ServiceMasterKey 類別

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

命名空間:  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

備註

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.

範例

使用加密

繼承階層

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

執行緒安全性

這個類型的任何公用static (在 Visual Basic 中為 Shared) 成員都是安全執行緒。不保證任何執行個體成員都可以是安全執行緒。