[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL Server events

Posted on 2002-04-27
6
Medium Priority
?
164 Views
Last Modified: 2010-05-02
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
Comment
Question by:justinhemphill
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 10

Expert Comment

by:smegghead
ID: 6973196
You could create an SQL trigger, which, in turn notifies your application using some other method...
0
 
LVL 1

Author Comment

by:justinhemphill
ID: 6973203
I'm not sure how to do that.
0
 
LVL 1

Expert Comment

by:falconew
ID: 6973210
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.

 
LVL 101

Expert Comment

by:mlmcc
ID: 6973739
Listening
0
 
LVL 1

Author Comment

by:justinhemphill
ID: 6974765
Is it true that you can only create Extended Stored Procedures using c or c++
0
 
LVL 1

Accepted Solution

by:
falconew earned 800 total points
ID: 6976152
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

656 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