Solved

SQL PUSH  DATA

Posted on 2004-09-15
3
576 Views
Last Modified: 2009-07-29
I don't know if this is possible, but I would some how in a stored procedure push somthing to the users of my program. Here's what I mean. I have lets say 10 users who view a datagrid(vb.net) and when one of these users updates the table  via Stored procedure, I would like the Stored Procedure to some how send out some, form of communication to the users telling them that there is new data. ( so they can refresh the DG or what ever). I currently have the VB program just pooling data every 5 secs from the DB, but wonder if there is a better way to do it. Sort of a push from the DB rather than having the program pull so often.

I would love any information in the right direction.
0
Comment
Question by:Jojo1771
3 Comments
 
LVL 10

Accepted Solution

by:
AaronAbend earned 300 total points
ID: 12066406
Polling the database with a query is the only way, basically. You could have a job that updates a column in a small "monitor" table. Then all your users could refer to that value. That way, you do not have every user launching the same query against your real data.
0
 
LVL 10

Assisted Solution

by:Jay Toops
Jay Toops earned 200 total points
ID: 12069817
Yes .. but use a trigger to update your monitor table with "LAST UPDATE TIME"
then the client apps can hold the "last update time" and when it goes out of sync... reload

Jay
0
 
LVL 5

Author Comment

by:Jojo1771
ID: 12144528
Not the answer I wanted but thanks for you help guys..
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

733 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