Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NeilG
Aged Yak Warrior
530 Posts |
 Posted - 2009-04-22 : 06:13:01
|
| Hi Guys, I was wondering if there is any place were you can find the different Eventdata() XML schema's that are returned for different DDL Trigger events i.e. the ddl_database_level_events, alter_table, Create_table for example i'm trying to have triggers for certain auditing reasons and will be using the EventData().value but need to know the schema's returned inorder to see what infomation I can captureCheersGuys |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-22 : 06:44:21
|
From Books Onlinequote:
EVENTDATA returns a value of type xml. By default, the schema definition for all events is installed in the following directory: C:\Program Files\Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2006\11\events\events.xsd.
I don't know if this applies to SQL Server 2005 also. Give it a try.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-04-22 : 06:56:35
|
| Cheers Peso, I've looked in the same folder for 2005 but can't see it but i'll look in BOL for EVENTDATA and see if there's a similar path cheers |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-04-22 : 07:01:14
|
| Found it under the eventdata() Transact SQL entry in BOL it informs you that typing each of the seperate events into BOL will give you the schema showing what data is being returned in the (Event_Instance) node Cheers for the little directional help there |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-22 : 07:50:21
|
You're welcome.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
DDL Triggers and XML schema for Eventsdata