?
Solved

SQL PUSH  DATA

Posted on 2004-09-15
3
Medium Priority
?
581 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 900 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 600 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

Introducing Priority Question

Increase expert visibility of your issues by participating in Priority Question, our latest feature for Premium and Team Account holders. Adjust the priority of your question to get emergent issues in front of subject-matter experts for help when you need it most.

Question has a verified solution.

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

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
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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 date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

771 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