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

318 times
Add to favorites
E-mail Twitter Digg Facebook
Be the first to ask a question.