What does the function ORIGINAL_LOGIN return in

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

(Continued from previous question...)

What does the function ORIGINAL_LOGIN return in SQL Server 2005?

Answer: The login used to connect to SQL Server.
Explanation: This function returns the name of the login originally used to connect to SQL Server for a session, regardless of any context switching that has occurred.

(Continued on next question...)

Other Job Interview Questions

• What does the PAD_INDEX parameter do when you create an index in SQL Server 2005?
• You are writing a new stored procedure to perform maintenance on your SQL Server 2005 databases that defragments the indexes in an online manner. What command should you use?
• In Full-Text Search, what is word breaking?
• What is the scope of the control permission in SQL Server 2005?
• What does the DUMP command do?
• What does the DUMP command do?
• What does the PAD_INDEX parameter do when you create an index in SQL Server 2005?
• What should you have applied a patch for by now on your Windows 2003 and XP systems?
• You then write a function to use this assembly, but it does not work. What could be the problem?
• In SQL Server 2005, what does instance aware mean for a service?
• More...