4.1 Detaching and Attaching a Database in SQL Server 2005 Express

[ChrisMCITP]

Misleading! Detaching a database removes it completely from SQL's database engine (not just SSMS), and therefore removes the ability to query the database. If you want to connect to a SQL database from a progam via ADO or similar, the database needs to be attached to an instance of SQL server or you're going to get nowhere fast. Detaching a database is used to move databases between instances or the same instance of SQL server without having to do a backup/restore.

[Firchild]

@ChrisMCITP Thanks for the input, and you're right, but this is designed for GCSE (14-16 year olds), so we kind simplify it

[sabrown311]

Thank ya

[anilmahadev2009]

Good One m8 ;)

[abotubar]

Thanxxxxxxxx :)