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

Finding SQL Server Event IDs

P: 69
Hello all,

I am trying to find out if it is possible to get a list of all of the event IDs that MS SQL server can generate. Does anyone know if a compiled list exists anywhere?

Also, can this be extracted from the SQL server itself through a query?

For example: What would the event ID be if someone performs a select query? Would that even be tracked anywhere... whether within the SQL server software itself, or within the OS logs where the software resides?

If this question doesn't belong in this area just let me know... I've been searching the web and can't find an answer to this question.

My boss thinks that these types of activities are logged within Windows, but I've never seen anything like this before.

Thanks in advance...
Mar 30 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 2,878
You can check the log. But I don't think queries are logged, though.

-- CK
Mar 31 '08 #2

P: 69
That's what I was afraid of... thanks for the info.
Apr 3 '08 #3

Post your reply

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