Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
beppe_30
Starting Member
5 Posts |
 Posted - 2010-06-22 : 02:04:12
|
| We have more than 100 databases and we would like to alter the db option "page verify" from "none" to "checksum".Do you know of any method to accomplish this task?Thank you very much.beppe_30 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-06-22 : 03:46:22
|
| You can write a query to generate the ALTER DATABASE scripts, or you can use the undocumented sp_MS_foreachDB proc.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Set page verify for all databases