This administrator will own the jobs. Which role

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

(Continued from previous question...)

This administrator will own the jobs. Which role should you assign?

You are delegating permissions on your SQL Server 2005 server to other adminstrators. You have local, single server jobs on one server that you would like to allow another administer to start, stop, and view the history for, but not delete history. This administrator will own the jobs. Which role should you assign? Answer
SQLAgentUserRole

Explanation
SQL Server 2005 provides 3 fixed roles for the agent service that limit privileges for administrators. The SQLAgentUserRole is designed for local jobs (not multiserver) that allows the member to work with their owned jobs (edit, start, stop, view history) without deleting the history of any job.

(Continued on next question...)

Other Job Interview Questions

• Which of these is not a parameter you can pass to the LOGINPROPERTY function?
• How large a database can you have in this edition of SQL Server 2005? ...
• In SQL Server 2005, which network protocols use endpoints?
• How can you easily monitor to see if this assembly is being used?
• What does the DEALLOCATE statement do in SQL Server 2005?
• In SQL Server 2005, if you want the keys securing your data to expire over time, what type of key encryption would you choose?
• How can you get SQL Server 2005 to simulate multiple processors for query testing?
• In SQL Server 2005 Analysis Services, what does the Synchronize Database Wizard allow you to do?
• How many rows are returned by these two select statements?
• What result would you expect from this statement? Select * from dbo .MyTable
• More...