DDL or CLR Trigger sample ?

[Mohammad Dayyan]

Hi guys, I have a Table (TableTest) in a Database (database1) in SQLExpress 2008. I wanna to call a method in C# whenever something is inserted in the Table. Could you please guide me? It would be great if you post a sample code. Thanks.

[Pete OHanlon]

I normally use a SqlNotification to accomplish this. Take a look here[^].

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

[Elfman_NE]

I am building a WEBSERVICE that will listen for PUSH NOTIFICATION from MS Exchange. What I was hoping to do is use the Query Notifications capability too be notified of changes to to specific data in SQL Server. 1. How specific are the SqlNotificationEventArgs that are raised to the dependency? 2. Could/Would it tell me anything specific about the event that triggered the notification? Insert/Update/delete and the primary key of the item? Thanks