Dbo.uspPrintErrorprocedure

wikibot

Procedure	dbo.uspPrintError
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.

Source

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

Dependencies

Reference Type	Object Type	Referencing Object	Child Type	Child Object
Execute	Procedure	dbo.uspLogError
Execute	Table	Production.WorkOrder	Trigger	iWorkOrder
Execute	Table	Production.WorkOrder	Trigger	uWorkOrder
Execute	Table	Purchasing.PurchaseOrderDetail	Trigger	iPurchaseOrderDetail
Execute	Table	Purchasing.PurchaseOrderDetail	Trigger	uPurchaseOrderDetail
Execute	Table	Purchasing.PurchaseOrderHeader	Trigger	uPurchaseOrderHeader
Execute	Table	Purchasing.Vendor	Trigger	dVendor
Execute	Table	Sales.SalesOrderDetail	Trigger	iduSalesOrderDetail
Execute	Table	Sales.SalesOrderHeader	Trigger	uSalesOrderHeader
Execute	Table	Sales.Store	Trigger	iStore