MasterKey.Regenerate Method (String, Boolean)

Regenerates the database master key by using the specified new password, and with the option to force the regeneration, thus removing all items that cannot be successfully decrypted.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub Regenerate ( _
    password As String, _
    forceRegeneration As Boolean _
)
'Usage
Dim instance As MasterKey 
Dim password As String 
Dim forceRegeneration As Boolean

instance.Regenerate(password, forceRegeneration)
public void Regenerate(
    string password,
    bool forceRegeneration
)
public:
void Regenerate(
    String^ password, 
    bool forceRegeneration
)
member Regenerate : 
        password:string * 
        forceRegeneration:bool -> unit
public function Regenerate(
    password : String, 
    forceRegeneration : boolean
)

Parameters

  • password
    Type: System.String
    A String value that specifies the password with which to encrypt and decrypt the master key.
  • forceRegeneration
    Type: System.Boolean
    A Boolean value that specifies whether to drop the items that cannot be successfully regenerated by using the old database master key password.If True, regeneration of the master key is forced, and all items that cannot be regenerated are dropped. Otherwise, False.

Examples

Calling Methods

See Also

Reference

MasterKey Class

Regenerate Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Encryption Hierarchy

CREATE MASTER KEY (Transact-SQL)