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:

Posted in SSMS