Solved

SQL PUSH  DATA

Posted on 2004-09-15
3
575 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

837 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