Finding SQL Server Event IDs

[narpet]

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...

[ck9663]

You can check the log. But I don't think queries are logged, though.

-- CK

[narpet]

That's what I was afraid of... thanks for the info.