How to insert record into journal_mst table in database manually

vinhlq

Dear all,

Currently, we want to insert record into journal_mst table in database manually, we are trying, but the database raise message warning:

"Msg 50000, Level 16, State 10, Procedure RaiseErrorSp, Line 124
<MsgTag>General Parameters does not exist.<MsgTag>
Msg 3609, Level 16, State 1, Procedure journal_mstInsert, Line 18
The transaction ended in the trigger. The batch has been aborted."

Anyone has done this task, please help us

Thank you so much,

burnsg

I would imagine you would need to wrap your code like so:



DECLARE @sessionid uniqueidentifier

SET @sessionid = newid()

EXEC InitSessionSP @sessionid, 'sa', @Site



-- do work here



EXEC closesessionsp @sessionid