Dbo.uspPrintError (procedure) - Revision history

Bot at 22:15, 23 June 2010

2010-06-23T22:15:47Z

Bot at 21:59, 23 June 2010

2010-06-23T21:59:58Z

Bot at 21:52, 2 February 2010

2010-02-02T21:52:21Z

Bot at 21:56, 28 December 2009

2009-12-28T21:56:48Z

Bot at 06:01, 30 November 2009

2009-11-30T06:01:38Z

Bot at 05:39, 30 November 2009

2009-11-30T05:39:51Z

Bot at 05:26, 30 November 2009

2009-11-30T05:26:17Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:44Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:55Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''procedure | dbo.uspPrintError |- |}

 -- uspPrintError prints error information a...

2009-01-03T12:36:18Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''procedure | dbo.uspPrintError |- |} <pre> -- uspPrintError prints error information a...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''procedure
| dbo.uspPrintError
|-
|}

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

@@ Line 44: / Line 44: @@
 | Execute
 | Procedure
-| [[dbo.uspLogError_(_(procedure))|dbo.uspLogError]]
+| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
+|
@@ Line 51: / Line 51: @@
 | Execute
 | Table
-| [[Production.WorkOrder_(_(table))|Production.WorkOrder]]
+| [[Production.WorkOrder_(table)|Production.WorkOrder]]
 | Trigger
@@ Line 58: / Line 58: @@
 | Execute
 | Table
-| [[Production.WorkOrder_(_(table))|Production.WorkOrder]]
+| [[Production.WorkOrder_(table)|Production.WorkOrder]]
 | Trigger
@@ Line 65: / Line 65: @@
 | Execute
 | Table
-| [[Purchasing.PurchaseOrderDetail_(_(table))|Purchasing.PurchaseOrderDetail]]
+| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 | Trigger
@@ Line 72: / Line 72: @@
 | Execute
 | Table
-| [[Purchasing.PurchaseOrderDetail_(_(table))|Purchasing.PurchaseOrderDetail]]
+| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 | Trigger
@@ Line 79: / Line 79: @@
 | Execute
 | Table
-| [[Purchasing.PurchaseOrderHeader_(_(table))|Purchasing.PurchaseOrderHeader]]
+| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 | Trigger
@@ Line 86: / Line 86: @@
 | Execute
 | Table
-| [[Purchasing.Vendor_(_(table))|Purchasing.Vendor]]
+| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 | Trigger
@@ Line 93: / Line 93: @@
 | Execute
 | Table
-| [[Sales.SalesOrderDetail_(_(table))|Sales.SalesOrderDetail]]
+| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 | Trigger
@@ Line 100: / Line 100: @@
 | Execute
 | Table
-| [[Sales.SalesOrderHeader_(_(table))|Sales.SalesOrderHeader]]
+| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 | Trigger
@@ Line 107: / Line 107: @@
 | Execute
 | Table
-| [[Sales.Store_(_(table))|Sales.Store]]
+| [[Sales.Store_(table)|Sales.Store]]
 | Trigger

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Procedure
 | dbo.uspPrintError
@@ Line 8: / Line 8: @@
 | '''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 ===
@@ Line 43: / Line 41: @@
 | '''Child Object
-|-
+|- valign="top"
 | Execute
 | Procedure
-| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
+| [[dbo.uspLogError_(_(procedure))|dbo.uspLogError]]
+|
+|
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Production.WorkOrder_(table)|Production.WorkOrder]]
+| [[Production.WorkOrder_(_(table))|Production.WorkOrder]]
 | Trigger
 | iWorkOrder
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Production.WorkOrder_(table)|Production.WorkOrder]]
+| [[Production.WorkOrder_(_(table))|Production.WorkOrder]]
 | Trigger
 | uWorkOrder
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
+| [[Purchasing.PurchaseOrderDetail_(_(table))|Purchasing.PurchaseOrderDetail]]
 | Trigger
 | iPurchaseOrderDetail
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
+| [[Purchasing.PurchaseOrderDetail_(_(table))|Purchasing.PurchaseOrderDetail]]
 | Trigger
 | uPurchaseOrderDetail
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
+| [[Purchasing.PurchaseOrderHeader_(_(table))|Purchasing.PurchaseOrderHeader]]
 | Trigger
 | uPurchaseOrderHeader
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
+| [[Purchasing.Vendor_(_(table))|Purchasing.Vendor]]
 | Trigger
 | dVendor
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
+| [[Sales.SalesOrderDetail_(_(table))|Sales.SalesOrderDetail]]
 | Trigger
 | iduSalesOrderDetail
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
+| [[Sales.SalesOrderHeader_(_(table))|Sales.SalesOrderHeader]]
 | Trigger
 | uSalesOrderHeader
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Sales.Store_(table)|Sales.Store]]
+| [[Sales.Store_(_(table))|Sales.Store]]
 | Trigger

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''procedure
+| '''Procedure
 | dbo.uspPrintError
 |- valign="top"
@@ Line 11: / Line 11: @@
 |}
 <pre>
 -- uspPrintError prints error information about the error that caused
@@ Line 31: / Line 33: @@
 </pre>
+=== Dependencies ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 112: / Line 114: @@
 | iStore
 |}

@@ Line 5: / Line 5: @@
 | '''procedure
 | dbo.uspPrintError
 |-
 |}
@@ Line 27: / Line 30: @@
 END;
 </pre>
 == automatically generated ==

@@ Line 34: / Line 34: @@
 | 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.
 |-
 |}

@@ Line 27: / Line 27: @@
 END;
 </pre>
 == automatically generated ==
@@ Line 62: / Line 61: @@
 END;
 </pre>