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

Scripts by PremKumar Raju

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

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 | 136 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 | 379 reads

Fix Orphan Users for All databases

Fix orphan database users on all user databases.  Read more...
Rating: |  Discuss |   Briefcase | 764 reads

Move End of Month file from source to destination

The script below executes on the first of every month and moves files from source to destination location.   Read more...
By PremKumar Raju 2014/07/24 | Source: SQLServerCentral.com | Category: move files
Rating: |  Discuss |   Briefcase | 923 reads
   Items 1 to 4 of 4