What is a simple way to rename a database in MS

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

(Continued from previous question...)

What is a simple way to rename a database in MS SQL Server?

The simple way to rename a database is to run the following T-SQL command: "EXEC sp_renamedb 'old_name', 'new_name'". You may want to set the database in single user mode before running this command.

(Continued on next question...)

Other Job Interview Questions

• By default, MS SQL Server sets the index fill factor to 100%. What does this mean?
• What information do you need to identify a remote MS SQL Server to make a connection request?
• What is the meaning of an Outer Join operatin of two tables?
• What is a simple way to detach a database that is not in use in MS SQL Server?
• How do you describe a field in a table in the database?
• What should you do to prepare for MS SQL Server upgrade?
• What is the meaning of Data Normalization?
• What is the meaning of the following T-SQL command: CREATE TABLE orders ...
• Is T-SQL language syntax case-sensitive?
• During a BULK INSERT operation, are triggers and contraints enforced by default?
• More...