When a user on a remote SQL Server wants to exec

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

(Continued from previous question...)

When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?

Answer: The local login that is mapped from the remote procedure call.

Explanation: When a linked server is setup, remote logins must be mapped to local logins.

(Continued on next question...)

Other Job Interview Questions

• You have specified that a SQL Server 2005 login must respect the password policy on a Windows XP host. Which of the following are valid passwords for the user Kendall?
• True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?
• What What does the term ACID refer to?
• Which query will return a list of the synonyms in your database?
• Which of these is not a parameter you can pass to the LOGINPROPERTY function?
• When you install SQL Server 2005 and create a new database, is a Database Master Key created?
• What does the ERROR_PROCEDURE() function return?
• Which type of XML variable requires a\one and only one root element?
• Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
• What is the timestamp datatype used for?
• More...