Calling Windows service from sql server 2005


I have made a windows service in dot net 2005 and
I want to call this windows service when I insert a record in the table.So is there any machnisam ,we can call the windows service whenver any record is inserted in the table.

Please give the solution if there is.
Who is Participating?
As a starting point, you can create a trigger on a table ("CREATE TRIGGER x ON mytable FOR INSERT AS ...")

OR: you can use the SQL Service Broker.

You can either have a CLR trigger or use your .NET code to talk to the service broker.


However, the ultimate answer really depends on how you wrote your Windows Service (and whether or not a Windows Service is really the most appropriate location for your custom-code.
When you wrote the Windows Service, how did you design it to be called?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.