How to change data_compression option for all tables on all databases

There is a MSDN forum question to change the data_compression option to change for all tables on all databases in a server.There were many scripts available in the web. However, here I would like to present one another method usingsp_MSforeachdb and sp_MSforeachtable system proce

 
 
 
 
 
(0)
144 times
Add to favorites
Databases
1/16/2015
E-mail Twitter del.icio.us Digg Facebook