Calling Windows service from sql server 2005

Posted on 2007-08-03
Medium Priority
Last Modified: 2013-11-26

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.
Question by:HanuSoftware

Expert Comment

ID: 19629832
When you wrote the Windows Service, how did you design it to be called?
LVL 13

Accepted Solution

Steven_W earned 2000 total points
ID: 20498592
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.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

750 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question