469,592 Members | 2,041 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,592 developers. It's quick & easy.

Single Trigger for "SELECT" execution happens irrespective of any table.

Whenever the “SELECT” command execution happens irrespective of any table inside one particular database Log information into one Log table.

The Information required
1) User logged in
2) Machine details
3) Table Name
In My DB there were more than 100 tables. I want to Wright single trigger like "DDL trigger" to know what are tables are got executed at which time, by which user and from which machine.

- Karthick
Feb 11 '09 #1
1 1529
2,878 Expert 2GB
I don't think SELECT are logged. Select also is not an event, which means it can not fire a trigger. If you see one, kindly post it here...

-- CK
Feb 13 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

23 posts views Thread by ian justice | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.