Actually it should directly change the setting rather than giving me the script as output..

Your reply on this much appreciated.

Thanks..but I have all my registered server in my SSMS and I want to directly execute the query which will change the page_verify option of all the servers in one...

Thanks..but I have all my registered server in my SSMS and I want to directly execute the query which will change the page_verify option of all the servers in one...

Hey,

Can you please try running your SSMS as administrator..just a suggestion try..

🙂

Hi There,

I want to find out the current setting of all the databases with current page_verify option in my environment.

If it is sql 2000 i want to set torn page...