• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 167
  • Last Modified:

SQL Server events

I currently have an app that polls (using a timer with the interval set to 1000) a SQL Server table looking for changes to records.

The problem is that this has a serious impact on the performance of my system.

I was wondering if it was possible to get SQL Server to send notification to my VB application if any of the records change.
1 Solution
You could create an SQL trigger, which, in turn notifies your application using some other method...
justinhemphillAuthor Commented:
I'm not sure how to do that.
Create an Extended Store procedure to notify your application and create a trigger to the table you want to monitor.
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

justinhemphillAuthor Commented:
Is it true that you can only create Extended Stored Procedures using c or c++
If you are not familiar with C/C++ you can still write a small application using VB to notify your main application. You can use the TCP/IP control or whatever you like to notify your main application.
And then you create a trigger on the table to execute the Extended Store Procedure XP_CMDSHELL 'your small application'. That is a trick.

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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now