Partilhar via


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 _
)
public void Regenerate (
    string password,
    bool forceRegeneration
)
public:
void Regenerate (
    String^ password, 
    bool forceRegeneration
)
public void Regenerate (
    String password, 
    boolean forceRegeneration
)
public function Regenerate (
    password : String, 
    forceRegeneration : boolean
)

Parameters

  • password
    A String value that specifies the password with which to encrypt and decrypt the master key.
  • forceRegeneration
    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.

    If False, regeneration of the master key is not forced.

Remarks

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Use an SMO Method with a Parameter in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

MasterKey Class
MasterKey Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Encryption Hierarchy
CREATE MASTER KEY (Transact-SQL)