By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

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

P: 13
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
4)
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.

Reg,
- Karthick
Feb 11 '09 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
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.