In SQL Server 2005, what permissions does a user

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

(Continued from previous question...)

In SQL Server 2005, what permissions does a user need to successfully execute the USE command?

Answer: CONNECT permission on the target database.

Explanation: A user needs the CONNECT permission on the target database.

(Continued on next question...)

Other Job Interview Questions

• What do you need to do now to ensure you can recover the routes in the event of a disaster?
• You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do?
• What does the sqlwb utility do?
• To which versions of SQL Server 2005 can you upgrade an SQL Server 2000 MSDE SP3 edition database?
• How can you determine which Service Broker ports are being used on your server?
• What else should you configure on these instances?
• What is row versioning in SQL Server 2005?
• On which port does the dedicated administrator connection listen in SQL Server 2005?
• What can be used to ensure that a field in a table only accepts a certain range of values?
• Which optional SQL Server component must you install to ensure that you can create and execute maintenance plans?
• More...