Trigger returning DBCC input buffer statement being cut-off
prashanth
Posts: 2
Hi all,
I created a log file that is intended to capture the sql statement being used to insert/ update/delete a record in a table (see the attached code snippet) but even though I created the statement field to be varchar (4000) the captured statement is being cut off...
Is there any other way to capture the whole statement.
Thanks....
I created a log file that is intended to capture the sql statement being used to insert/ update/delete a record in a table (see the attached code snippet) but even though I created the statement field to be varchar (4000) the captured statement is being cut off...
Is there any other way to capture the whole statement.
Thanks....
Comments
I'm afraid that I don't really understand what is happening. I assume that you have added extra logic to a DML trigger to write the query to a log file, but the code snippet that you mention is not available on the forum post.
Is this happening during the operation of SQL Compare anyway? Because if it's not, then maybe the professional community at www.sqlservercentral.com may be more well-placed to give advice on this sort of subject.
Thanks!