Attach and detach SQL databases with SQL server management studio

Attach or detach a SQL database to the SQL instance for Accounting CS, Workpapers CS, and Practice CS using SQL Server Management Studio. This article explains the steps for SQL Server Management Studio. The steps may differ if you have the full version of SQL. If you haven't installed SQL Server Management Studio, consult your firm's qualified IT professional.
Follow these steps to attach or detach a SQL database.
  1. Open SQL Server Management Studio.
  2. Select the desired instance for attachment or detachment.
  3. Select
    Connect
    .
  4. Then, follow either of the procedures below.
Detach a database in management studio
To detach a database:
  1. Expand the
    Databases
    folder by clicking the "+" button next to it under the instance.
  2. Right-click the database you want to detach.
  3. Select
    Tasks
    , then select
    Detach
    .
  4. Mark the
    Drop
    checkbox.
  5. Select
    OK
    .
Attach a database in management studio
To attach a database:
  1. Right-click the
    Databases
    folder under the instance, then select
    Attach
    .
  2. Select
    Add
    .
  3. Select the database file you want to attach and click OK.
  4. Verify the correct database is selected and select
    OK
    .
  5. Open your CS program (Accounting CS, Workpapers CS, or Practice CS).