tags:

views:

28

answers:

1
Q: 

Message from SQL Server database to application when something changes in database

I have used triggers within a database .. like .. when record in table A is deleted then also delete the corresponding record in table B, C D .. e.c.t

In SQL Server, is there a way to send message to application from database using triggers ...

The scenario is ...

If same application ( .exe ) is opened by 2 users and both use the same database ... then is 1st user has deleted an item ... then 2nd user should see it immediately ... or something like that.

+1  A: 

You can use Query Notifications. See: MS Sql 2008 Query Notifications MS Sql 2005 Using Query Notifications With C#

thedugas  2010-02-15 16:40:53
perfect ... thank you . ...
KK  2010-02-15 16:46:22
@KK - since you are a new member, I thought it would be courteous to inform you if you don't know - when you think someone has answered your question, you should mark it as answered (click the check on the left side of the answer). Your accept rate is recorded and shown by your name when you post a question - if you have a high accept rate people will be more likely to answer your questions; if you have a low accept rate people will be reluctant to spend time giving you an answer. I in no way meant this post to signify that you should accept my answer - just being courteous and giving a tip.
thedugas  2010-02-15 17:15:13

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL