You wish to prevent anyone from using the sa acc

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

(Continued from previous question...)

You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?

Answer: Disable the account.

Explanation: You can disable the sa account in SQL Server 2005, which prevents its use.

(Continued on next question...)

Other Job Interview Questions

• Yesterday's QOD How are comments denoted in an XML document?
• How secure are encrypted stored procedures, triggers and views?
• You want to disable the receipt of messages in one of your databases by the Service Broken. How should you do this?
• To maintain the best performance of your SQL Server 2005 databases, how should you deploy encryption technologies?
• What does the Queue Reader Agent do in SQL Server 2005 replication?
• How can you quickly determine if any of these indexes are really being used?
• What level of permissions does a user need to create an assembly with UNSAFE permissions?
• How many dimensions can you have in a SQL Server 2005 Analysis Services database?
• How many plans must you setup?
• What is the best way to have your junior DBA do this?
• More...