What is a simple way to detach a database that i

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a simple way to detach a database that is not in use in MS SQL Server?

The simple way to detach a database is to run the following T-SQL command: "EXEC sp_detach_db 'db_name'".

(Continued on next question...)

Other Job Interview Questions

• What is the meaning of the following T-SQL command: CREATE TABLE orders ...
• When "SET CONCAT_NULL_YIELDS_NULL ON", concatenating a null value with a string will yield a NULL result. But this only applies to the current session if you use in Query Analyzer. Is this true?
• What does Field refers to in MS SQL Server?
• What is a simple way to detach a database that is not in use in MS SQL Server?
• What is "osql"? What can you do with "osql"?
• What are distributed queries?
• What are distributed queries?
• What is a Torn Page in MS SQL Server?
• What is a Rule is MS SQL Server?
• What is the default TCP/IP port # used by MS SQL Server to receive connection requests?
• More...