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.
LVL 1
justinhemphillAsked:
Who is Participating?
 
falconewConnect With a Mentor Commented:
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.

0
 
smeggheadCommented:
You could create an SQL trigger, which, in turn notifies your application using some other method...
0
 
justinhemphillAuthor Commented:
I'm not sure how to do that.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
falconewCommented:
Create an Extended Store procedure to notify your application and create a trigger to the table you want to monitor.
0
 
mlmccCommented:
Listening
0
 
justinhemphillAuthor Commented:
Is it true that you can only create Extended Stored Procedures using c or c++
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.