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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-18 : 08:07:08
|
| Nageen writes "Hello,I want to ask that which is the best way to get notified by SQL Server's events like when a new row is inserted etc.I want to get my web service notified when there is some change in the DB.Thanks" |
|
|
surendrakalekar
Posting Yak Master
120 Posts |
Posted - 2005-11-18 : 08:40:06
|
| 1. You can maintain DateAdded, DateUpdated, AddedByUser, UpdatedByUser columns2. Table auditing to track all the column updation.Surendra |
 |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2005-11-18 : 09:14:54
|
quote:
Originally posted by AskSQLTeam
Nageen writes "Hello,I want to ask that which is the best way to get notified by SQL Server's events like when a new row is inserted etc.I want to get my web service notified when there is some change in the DB.Thanks"
Well, the you can use triggers and setup an audit table. then have a .net app pole the audit table and then communicate with your web service. There are a ton of ways to do this actually.________________________________________________Drinking German Beer... fun.Listening to an accordian player play ACDC...priceless |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-11-20 : 22:29:16
|
| you can audit a database SUID if you only allow these queries to run using sprocs/udfs, this way you can incorporate the audit trailHTH--------------------keeping it simple... |
|
|
|
|
|
|
Best way to get notified by SQL Server