When users move or upgrade from an older version of BillQuick to a newer one and they have a database on the SQL Server, they may want to remove that database. Instead of deleting, you can move the database so that other users don’t access it.
Here are the steps to do that:
1. Open Microsoft SQL Server Management Studio.
2. Log in using either Windows Authentication or SQL Server Authentication.
3. Once logged in, expand the Databases folder. Select your BillQuick database and right-click to choose Task>Detach.
4. Once the Detach Database screen displays, check the Drop Connections option and then click OK. Users will not be able to enter data in your old database.
Note: This will not delete the database; it will take it off the SQL Server Management Studio so that users won’t have access to it. Check the below link for more:
http://msdn.microsoft.com/en-us/library/ms191491(v=sql.90).aspx