Even though it is a little bit late in the game, I decided to post here what I found around doing my own homework for un-installing Reporting Services 2005. Instead...

John,

The easiest way to find out if this is UPDATE or DELETE event is to check rows in inserted table: for UPDATE event there will be rows in both tables...

Thank you everyone! Sorry, I was not clear on what needs to be audited: any kind of data access (like select statements, data modification) has to be logged. If you...

grant VIEW DEFINITION on your_stored_procedure to dev_users

will solve the problem.

I am using very simple VBscript to achieve the same thing, and attachements are allowed as well after small modification

--------------------------------------

Set oMsg = CreateObject("CDONTS.NewMail")

 oMsg.From =...

Something like this?

select o.name from sysobjects o

inner join syscomments c

on o.id = c.id

where text like '%table_name%'

Julia