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.
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.
ChrisMCITP 1 year ago
@ChrisMCITP Thanks for the input, and you're right, but this is designed for GCSE (14-16 year olds), so we kind simplify it
Firchild 1 year ago