Calling Windows service from sql server 2005

Hi


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.
HanuSoftwareAsked:
Who is Participating?
 
Steven_WCommented:
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.
0
 
kenhaleyCommented:
When you wrote the Windows Service, how did you design it to be called?
0
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.