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

Scripts by PremKumar Raju

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

Change the server name of the SQL Server Instance

How to change the server name of SQL Server Instance?  Read more...
By PremKumar Raju 2018/03/27 | Source: SQLServerCentral.com | Category: sql server instance
Rating: |  Discuss |   Briefcase | 311 reads

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 | 186 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 | 407 reads

Fix Orphan Users for All databases

Fix orphan database users on all user databases.  Read more...
Rating: |  Discuss |   Briefcase | 864 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 | 925 reads
   Items 1 to 5 of 5