dbo.uspLogError Procedure

Information

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

SQL Script

CREATE PROCEDURE [dbo].[uspLogError] 
@ErrorLogID [int] = 0 OUTPUT -- contains the ErrorLogID of the row inserted
AS                               -- by uspLogError in the ErrorLog table
BEGIN
SET NOCOUNT ON;
SET @ErrorLogID = 0;
BEGIN TRY
IF ERROR_NUMBER() IS NULL
RETURN;
IF XACT_STATE() = -1
BEGIN
PRINT 'Cannot log error since the current transaction is in an uncommittable state. ' 
+ 'Rollback the transaction before executing uspLogError in order to successfully log error information.';
RETURN;
END
INSERT [dbo].[ErrorLog] 
(
[UserName], 
[ErrorNumber], 
[ErrorSeverity], 
[ErrorState], 
[ErrorProcedure], 
[ErrorLine], 
[ErrorMessage]
) 
VALUES 
(
CONVERT(sysname, CURRENT_USER), 
ERROR_NUMBER(),
ERROR_SEVERITY(),
ERROR_STATE(),
ERROR_PROCEDURE(),
ERROR_LINE(),
ERROR_MESSAGE()
);
SET @ErrorLogID = @@IDENTITY;
END TRY
BEGIN CATCH
PRINT 'An error occurred in stored procedure uspLogError: ';
EXECUTE [dbo].[uspPrintError];
RETURN -1;
END CATCH
END;