Online Documentation for SQL Manager for SQL server
Selecting the database
At this step of the wizard you should specify the database to be detached from the instance of SQL Server.
Use the Database drop-down list to select the database to be detached.
Note that you can detach a database only if it has no active connections and it is not enabled for replication. To clear the current connections to the database, use the corresponding Clear connections button.
Press the Refresh button to get the current status of the selected database.
Update statistics before detaching
Check this option to update the database statistics before detaching the database.
Using this option you can unregister the database (if it has been registered in SQL Manager).
When you are done, click the Next button to proceed to the Detaching database step of the wizard.