Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CostaSBD
Starting Member
5 Posts |
 Posted - 2008-12-29 : 12:36:08
|
| Hello all,I can subscribe to an event of SQL Server to alert the VB application when UPDATE has been done in a table?I need to know the capacity of a room and this is stored in a table and modified by an external service, I do not see very efficient make a query from time to time....thnks a lot! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-29 : 12:39:43
|
| seems like what you need is an UPDATE trigger on table which checks if capacity field was involved in update and then do necessary actions |
 |
|
|
CostaSBD
Starting Member
5 Posts |
Posted - 2008-12-29 : 13:36:54
|
| I need to know this change in the .NET Application, a trigger doesn't send me nothing...thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-29 : 13:43:19
|
quote:
Originally posted by CostaSBD
I need to know this change in the .NET Application, a trigger doesn't send me nothing...thanks.
But you can make trigger return you a status bit and based on that cant you write code in application to incorporate your reqmnt. |
|
|
|
voyager838
Yak Posting Veteran
90 Posts |
Posted - 2009-05-15 : 09:18:02
|
| Trigger is a good thing, i use it when i have to send information/status bits to a pre-prepared table,so the front-end application can get an picture of whats happen, before it try to get new datas and so on. |
|
|
|
|
|
|
How to know when a row is updated