Trigger returning DBCC input buffer statement being cut-off

prashanthprashanth Posts: 2
edited December 22, 2008 12:14PM in SQL Compare Previous Versions
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....

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,
    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!
Sign In or Register to comment.