dbo uspPrintError (procedure)

Modified on 2011/08/27 11:17 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Procedure'''
| dbo.uspPrintError
|- valign="top"
| '''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 ===
{{{{<nowiki>
-- 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;
</nowiki>}}}}

=== Dependencies ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Reference Type'''
| '''Object Type'''
| '''Referencing Object'''

| '''Child Type'''
| '''Child Object'''

|- valign="top"
| Execute
| Procedure
| [[dbo uspLogError (procedure)|dbo.uspLogError]]

| &nbsp;
| &nbsp;
|- valign="top"
| Execute
| Table
| [[Production WorkOrder (table)|Production.WorkOrder]]

| Trigger
| iWorkOrder
|- valign="top"
| Execute
| Table
| [[Production WorkOrder (table)|Production.WorkOrder]]

| Trigger
| uWorkOrder
|- valign="top"
| Execute
| Table
| [[Purchasing PurchaseOrderDetail (table)|Purchasing.PurchaseOrderDetail]]

| Trigger
| iPurchaseOrderDetail
|- valign="top"
| Execute
| Table
| [[Purchasing PurchaseOrderDetail (table)|Purchasing.PurchaseOrderDetail]]

| Trigger
| uPurchaseOrderDetail
|- valign="top"
| Execute
| Table
| [[Purchasing PurchaseOrderHeader (table)|Purchasing.PurchaseOrderHeader]]

| Trigger
| uPurchaseOrderHeader
|- valign="top"
| Execute
| Table
| [[Purchasing Vendor (table)|Purchasing.Vendor]]

| Trigger
| dVendor
|- valign="top"
| Execute
| Table
| [[Sales SalesOrderDetail (table)|Sales.SalesOrderDetail]]

| Trigger
| iduSalesOrderDetail
|- valign="top"
| Execute
| Table
| [[Sales SalesOrderHeader (table)|Sales.SalesOrderHeader]]

| Trigger
| uSalesOrderHeader
|- valign="top"
| Execute
| Table
| [[Sales Store (table)|Sales.Store]]

| Trigger
| iStore
|}
devio dbscript ScrewTurn Wiki

Navigation¶

dbo uspPrintError (procedure)
