August 14, 2008 at 7:53 am
Hello,
I'm trying to set up some logging on our servers of general DDL activity. i have implemented database level triggers ok (using DDL_DATABASE_LEVEL_EVENTS) and indeed some server level ones too (DDL_Login_Events for example). i was trying to implement another for create_linked_server. i keep getting an error when trying to create the trigger;
Msg 1084, Level 15, State 1, Line 3
'create_linked_server' is an invalid event type.
i also get the error if i try and set up an event notification for the same event. is it true to say that not all of the events are capturable using triggers and you have to use notifications?
i noticed that there is a sys view called sys.event_notification_event_types which would seem to contain the types of event that can be tracked. create_linked_server doesnt appear in the view. i originally took the events from the BOL where there is a nice chart showing them.
am i missing something obvious or has anyone else had a similar problem?
ps, be gentle this is my first post!
August 14, 2008 at 8:01 am
I don't see create linked server in BOL under the list of events that DDL triggers can fire for.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 14, 2008 at 8:05 am
i was looking at this chart admittedly from MSDN!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply