How To: Attach or detach a database in SQL Server 2005 Express

How to Attach or detach a database in SQL Server 2005 Express

In this video tutorial, viewers learn how to detach and attach a database in SQL Server 2005. Microsoft SQL Server is a relational model database server. Begin by opening the Database and show all the tables. To detach the table, right-click the database and select Detach. Make sure that the database is not opened or it will not detach. To attach a database, right-click on Database and select Attach. Click on Add and find the table. Select the table and press OK. This video will benefit those viewers who use SQL Server 2005, and would like to learn how to attach or detach the database.