Blog Archives

Set autoclose property for all database


in SSMS , Right click on database node in Object Explorer, Select menu item “Start PowerShell” Type in following in power shell window to set Auto Close on all databases dir | foreach {$_.AutoClose = $true; $_.Alter()} If you would

Posted in DB Management, SQL Power shell, SQL Server, SSMS

How to specify DB name in CMS Query


You can set the database name for the registered server in the “Connection Properties” tab. Then open a “New Query” on the server group and run your query   Related forum thread: http://social.msdn.microsoft.com/Forums/en-US/sqlkjappmsmgmt/thread/69576d3a-20f5-4641-9e55-0e805429839a

Posted in SSMS