Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: dbo uspPrintError (procedure)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 18:08


wikibot

procedure dbo.uspPrintError
DescriptionPrints 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.

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

Reference TypeObject TypeReferencing ObjectChild TypeChild Object
ExecuteProceduredbo.uspLogError
ExecuteTableProduction.WorkOrderTriggeriWorkOrder
ExecuteTableProduction.WorkOrderTriggeruWorkOrder
ExecuteTablePurchasing.PurchaseOrderDetailTriggeriPurchaseOrderDetail
ExecuteTablePurchasing.PurchaseOrderDetailTriggeruPurchaseOrderDetail
ExecuteTablePurchasing.PurchaseOrderHeaderTriggeruPurchaseOrderHeader
ExecuteTablePurchasing.VendorTriggerdVendor
ExecuteTableSales.SalesOrderDetailTriggeriduSalesOrderDetail
ExecuteTableSales.SalesOrderHeaderTriggeruSalesOrderHeader
ExecuteTableSales.StoreTriggeriStore

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.