• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • 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.
0
justinhemphill
Asked:
justinhemphill
1 Solution
 
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
 
falconewCommented:
Create an Extended Store procedure to notify your application and create a trigger to the table you want to monitor.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
mlmccCommented:
Listening
0
 
justinhemphillAuthor Commented:
Is it true that you can only create Extended Stored Procedures using c or c++
0
 
falconewCommented:
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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