I will check tomorrow at work ...

Thanks!

I used your code (below) inside my trigger:

INSERT INTO #B(EventType, Parameters, EventInfo)

EXEC ('dbcc inputbuffer (' + @@spid + ') with no_infomsgs')

SELECT * FROM #B

It returned the code from...

Seth,

The code works well but in my trigger, when I call the code, it returns the trigger code instead of the SQL or stored procedure that...

I tried it ... it works!

Thanks! 😀

Seth,

I was a little premature. The 2 other snippets worked great. I am having problems with the 3rd one.

Here is what I have (note: I used a global...

I tried it today at work and it works! Thanks!

Seth,

I read your reply more closely. Correct me if I am wrong ... it sounds as though these snippets will capture the T-SQL that is...

I am reading this from home and cannot try it out until tomorrow. I am relatively new to this area of SQL Server. Will this code run from inside...

NTEXT can hold up to 2 Billion characters. The max number of bytes for a row in SS2K is 8060. SS2K stores the data in other places and only keeps...

BOL recommends that you don't use UPDATE with NTEXT since the field only holds a pointer to "out of row" data.

Many thanks to both of you!

-- Tom

PS. My organization previously bought the source code to the COTS package that we have and we are able to manipulate the back-end. My thought is to try changing...

Gail and Lynn,

Thanks for your advice. Today, I went and created a test table with one ntext column and was able to insert 38 million characters ... it took...

Oops ... I am using SS2K! Sorry.

I know how to generate the scripts using EM and QA (one at a time). I was just trying to see if there were...

Suresh and Pradeep ... thanks for the help!