lyfz_repos/经典版源码/document/数据库维护脚本/错误消息存储过程.sql

-- 错误消息存储过程
IF (object_id('proc_error_info') is not null)
    DROP PROCEDURE proc_error_info
GO

CREATE PROC proc_error_info
AS
    SELECT 
	ERROR_NUMBER() as '错误编号',
	ERROR_SEVERITY() '错误严重性',
	ERROR_STATE() as '错误状态',
	ERROR_PROCEDURE() as '错误对象(存储过程或触发器)名称',
	ERROR_LINE() as '错误行号',
	ERROR_MESSAGE() as '错误描述'
go