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

Scripts by Harsha Bhagat

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Delete Change Tracking table data sys.syscommittab

With high transactions table the sys.syscommittab table does not gets deleted properly. Millions of backdated row remains. To delete the sys.syscommittab table below is the script.   Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 134 reads

Delete Files in Shared Location/SAN

Delete files via TSQL procedure in shared location  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 374 reads

Restore Redgate Transaction logs files via SQL

The script will restore the all the transaction logs files generated by Red Gate after extracting into .trn files.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 256 reads
   Items 1 to 3 of 3