EVENTDATA() XML Schema/DTD

Question

Hey I've been looking for the EVENTDATA()s xml schema or DTD but haven't been able to find it anywhere. I'm specifcally looking for a list of the EVENT_INSTANCE/ObjectType options. Does anyone know where I can find out this information?

Thanks

Answer 1

Hi John,

Welcome to SQL SERVER XML Forum!

 

Search for "events.xsd" in your sql server installation folder. I have it in the following location. "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2006\11\events".

 

Hope this helps

 

Jacob

Answer 2

Cheers I'll check that out when I get to work tomorrow.

Answer 3

Since this is the first link I found, and the answer by Mr. Sebastian didn't work for me on 6 servers, here's another location:

http://schemas.microsoft.com/sqlserver/2006/11/eventdata/

http://schemas.microsoft.com/sqlserver/2006/11/eventdata/events.xsd