-- uspPrintError prints error information about the error that caused   -- execution to jump to the CATCH block of a TRY...CATCH construct.   -- Should be executed from within the scope of a CATCH block otherwise   -- it will return without printing any error information.  CREATE PROCEDURE [dbo].[uspPrintError]   AS  BEGIN      SET NOCOUNT ON;        -- Print error information.       PRINT 'Error ' + CONVERT(varchar(50), ERROR_NUMBER()) +            ', Severity ' + CONVERT(varchar(5), ERROR_SEVERITY()) +            ', State ' + CONVERT(varchar(5), ERROR_STATE()) +             ', Procedure ' + ISNULL(ERROR_PROCEDURE(), '-') +             ', Line ' + CONVERT(varchar(5), ERROR_LINE());      PRINT ERROR_MESSAGE();  END;  
SELECT st.text QueryText  FROM sys.dm_exec_cached_plans   CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st  WHERE text LIKE N'%uspPrintError%';