I don't capture the error message from the stored-procedure but instead capture the return error number.
CREATE TRIGGER [test2] ON [dbo].[Imp_DAP_Audit]
FOR INSERT
AS
set nocount on
declare @ReturnError int -- capture error number
DECLARE @C as INT, @ID as INT,@MN as varchar(20), @CID as...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.