Solved

SQL PUSH  DATA

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

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.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
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 set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

707 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