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

• On which port does the default instance of SQL Server 2005 Analysis Services listen to by default?
• How many Service Packs will be released for SQL Server 2005 in 2007?
• Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database: Submitted by Charles Hawkins
• Which of these is not a parameter you can pass to the LOGINPROPERTY function?
• In SQL Server 2005, what does the CREATE SERVICE command do?
• What is the scope of the control permission in SQL Server 2005?
• You want to be sure that your Scalable Shared Database is as available as possible. Which of the following is not needed for this?
• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• In Full-Text Search, what is word breaking?
• If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?
• More...