Microsoft.SqlServer.Server.SqlTrigger forces me to specify the Target

Question

Microsoft.SqlServer.Server.SqlTrigger forces me to specify the Target

jango_41

SSC Veteran

Points: 243
More actions
September 27, 2010 at 2:25 pm

#238786

Dear joyfull All,
when a trigger is to be defined in c#, you must define something like :
[Microsoft.SqlServer.Server.SqlTrigger(Name = "UpdateAddressChangeLogADDRESS", Target = "ADDRESS", Event = "FOR UPDATE")]
I may be wrong, but it appears to me that this keeps me working, and I like to be lazy.
My clients have very experienced people, and they would be glad to use the clr triggers tat I define for their own chosen targets and events.
Is there a workaround to avoid the specification of Target (and Event) in the Microsoft.SqlServer.Server.SqlTrigger attribute ?
Tahnk you in advance,
Edmond de Savornin Lohman,
Utrecht, Netherlands

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 1

jango_41 (9/27/2010)
My clients have very experienced people, and they would be glad to use the clr triggers tat I define for their own chosen targets and events.

I do not understand this line. Could you rephrase?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Phil Parkin SSC Guru Points: 247180 More actions · Answer 2

jango_41 (9/27/2010)
Dear joyfull All,
when a trigger is to be defined in c#, you must define something like :
[Microsoft.SqlServer.Server.SqlTrigger(Name = "UpdateAddressChangeLogADDRESS", Target = "ADDRESS", Event = "FOR UPDATE")]
I may be wrong, but it appears to me that this keeps me working, and I like to be lazy.
My clients have very experienced people, and they would be glad to use the clr triggers tat I define for their own chosen targets and events.
Is there a workaround to avoid the specification of Target (and Event) in the Microsoft.SqlServer.Server.SqlTrigger attribute ?
Tahnk you in advance,
Edmond de Savornin Lohman,
Utrecht, Netherlands

Is this a question relating to SSIS? I think you may have posted in the wrong forum.