July 11, 2002 at 8:31 am
hi ppl! I have a big question...
I would like to catch ev'rything that happens on my db... but profiler has a little bug... if anyone send a batch query with words like: sp_password, sp_addlogin, etc, i can't see a little word of the batch!
Even if this is commented!!
So, i thought to write an update trigger, on my sysprocesses table that catch this and give me a DBCC INPUTBUFFER on updated spid! but sql server dont allow to put triggers on system tables...so, i ve tried to create a view of my sysprocesses and create a trigger on that... in theory, it should work, but didnt... i have to see that batch, its a command that ENTERPRISE MANAGER send to the server in the graphics interface that i would like to catch and write a script to turn my task automatic !! any ideas?
I use Sql Server 2000!
Thx!
July 11, 2002 at 8:48 am
The reason profiler prevents the display of such information is for security reasons. It does have counters to track when security audit events happen. (Security Audit Event Classes).
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply