Solved

SQL PUSH  DATA

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

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 …
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

776 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