What does the ERROR_PROCEDURE() function return?

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

(Continued from previous question...)

What does the ERROR_PROCEDURE() function return?

Answer
The name of the stored procedure that caused an error.

Explanation
The ERROR_PROCEDURE() function is placed in the catch block of a TRY..CATCH construct and returns the name of the procedure that caused an error to be thrown.

(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?
• SELECT USER_NAME() -- Returns Andy
• How is Thesaurus data configured in SQL Server 2005 Full-Text Search?
• 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 function ORIGINAL_LOGIN return in SQL Server 2005?
• You want to speed up your SQL Server 2005 Service Broker queue by placing an index on it. What is the best way to do this?
• True or false, Report Builder supports user defined run time parameters?
• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• What the heck does ATN2 do?
• 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?
• More...