dbo.uspPrintError Procedure

Information

Namedbo.uspPrintError
Assembly Name 
Created29.3.2010. 21:58:18
Modified29.3.2010. 21:58:18
Encrypted 

SQL Script

CREATE PROCEDURE [dbo].[uspPrintError] 
AS
BEGIN
SET NOCOUNT ON;
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;