Procedure:
[AdventureWorks2016CTP3].[dbo].[uspPrintError]
Procedure properties
| Name | Value |
| Schema | [dbo] |
| Owner | [dbo] |
| Creation date | 23.10.2015 |
| Type | P |
| Encrypted | |
| ID | 645577338 |
| Implementation type | Transact SQL |
| Is native compiled |
Creation options
| Name | Value |
| QUOTED_IDENTIFIER | ON |
| ANSI_NULLS | ON |
Objects that depend on [dbo].[uspPrintError]
| Object name | Object type | Dep level |
| [dbo].[uspLogError] | Procedure | 1 |
| [Purchasing].[dVendor] | Trigger | 1 |
| [Sales].[iduSalesOrderDetail] | Trigger | 1 |
| [Purchasing].[iPurchaseOrderDetail] | Trigger | 1 |
| [Production].[iWorkOrder] | Trigger | 1 |
| [Purchasing].[uPurchaseOrderDetail] | Trigger | 1 |
| [Purchasing].[uPurchaseOrderHeader] | Trigger | 1 |
| [Sales].[uSalesOrderHeader] | Trigger | 1 |
| [Production].[uWorkOrder] | Trigger | 1 |
Extended properties
| Name | Value |
| MS_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. |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON GO -- 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; GO EXEC sp_addextendedproperty N'MS_Description', N'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.', 'SCHEMA', N'dbo', 'PROCEDURE', N'uspPrintError', NULL, NULL GO |
See also