Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Procedure | dbo.uspPrintError |- valign="top" | '''Description | Prints e...

2010-06-23T22:07:55Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Procedure | dbo.uspPrintError |- valign="top" | '''Description | Prints e...

New page

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

=== 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]]

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

Dbo.uspPrintErrorprocedure - Revision history

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Procedure | dbo.uspPrintError |- valign="top" | '''Description | Prints e...