SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Encryption Rss

Search for any content tagged encryption

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 5 of 5   
 

Remove Database Encryption Key on all user databases

Below script will remove database encryption key, database certificate and master key on all the user databases. For tempdb database, you need to restart the SQL Server Instance to complete the process. Note: It is advisable to take transaction log backup before this activity is performed.  Read more...
Rating: |  Discuss |   Briefcase | 134 reads

Transparent Database Encryption on all User Databases

How to apply Transparent Database encryption?  Read more...
By PremKumar Raju 2017/05/25 | Source: SQLServerCentral.com | Category: tde
Rating: |  Discuss |   Briefcase | 377 reads

TDE Decryption Timer Script

Decryption Timer to let you know when the removal of encryption for a TDE encrypted database has completed to perform a backup of the data after masking.  Read more...
By Edward Pochinski 2017/01/24 | Source: SQLServerCentral.com | Category: tde
Rating: |  Discuss |   Briefcase | 330 reads

MD5

function to create md5 string for passwords  Read more...
Rating: |  Discuss |   Briefcase | 1,084 reads

Encrypt All Stored procedures at once

this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.   Read more...
By Chris Morton 2009/09/10 | Source: SQLServerCentral.com | Category: with encryption
Rating: |  Discuss |   Briefcase | 3,296 reads
   Items 1 to 5 of 5