Hello!

I have triggers that tell me when a table is updated, for example.

But I don't know what rows were appended. I don't know the content of the
sql statement that ran.

Is there a way to use the trigger to send me the actual sql statement that
was run?

-Bahman

Use the SQL Profiler to see what's going on 'behind the scenes'.

Start here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_aa_2xiq.asp


ML

Dear ML,

My problem is probably much simpler. I want to do this:

CREATE TRIGGER RankDataInsert
ON rank_data
FOR INSERT
AS
   EXEC master..sp_send_cdosysmail
'SqlSer***@hotmail.com',
'bahma***@hotmail.com',
'Insert Action', (select * from inserted)

But it bombs on 'select * from inserted'. Could there be a quick fix for this?

Show quoteHide quote

Start learning more here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_6iem.asp


ML

Yes. Declare a varchar variable and set the text of your query as its value.
Then supply the variable as the appropriate parameter.

And, most important of all: stop using sp_send_cdosysmail!!!

There's a much more efficient extended procedure xp_sendmail. This is the
21st century after all...


ML

Stored Procs vs VIEWS: Seeking Comparison
How to find gaps in sequential key
boolean programming
JDBC client - CURSOR as OUT parameter -supported ?
Creating a trigger using a cursor