Properties

Owner:	dbo
Encrypted:
Creation Date:	04/26/2006
Modification Date:
Description:	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.

Creation options

QUOTED_IDENTIFIER:
ANSI_NULLS:

Objects that depend on [dbo].[uspPrintError]

	Object Name	Owner	Object Type	Dep Level
	uspLogError	dbo	Procedure	1
	uspUpdateEmployeeHireInfo	HumanResources	Procedure	2
	uspUpdateEmployeeLogin	HumanResources	Procedure	2
	uspUpdateEmployeePersonalInfo	HumanResources	Procedure	2
	dVendor	Purchasing	Trigger	2
	iduSalesOrderDetail	Sales	Trigger	2
	iPurchaseOrderDetail	Purchasing	Trigger	2
	iStore	Sales	Trigger	2
	iWorkOrder	Production	Trigger	2
	uPurchaseOrderDetail	Purchasing	Trigger	2
	uPurchaseOrderHeader	Purchasing	Trigger	2
	uSalesOrderHeader	Sales	Trigger	2
	uWorkOrder	Production	Trigger	2

Total: 13 object(s)

SQL

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

-- 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;

GO
SET QUOTED_IDENTIFIER OFF
GO

GO
SET ANSI_NULLS OFF
GO

See Also

List of stored procedures