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 |
|
sasan_vm
Yak Posting Veteran
51 Posts |
 Posted - 2010-04-20 : 03:25:33
|
| Hello,I have an client/server application with sql-server 2000 database, when an user insert a record in chosen table, i need to informed new recordby a service installed on server to related user. I can use timer on service or client application for checking table, but it's not good idea, Is another solution for this ?Kind Regards,sasan. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-20 : 09:50:56
|
| seems like what you need is a trigger which does relevant data update on table and a sql batch job which does informing part and executes periodicaly------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
fan2005
Yak Posting Veteran
85 Posts |
Posted - 2011-07-11 : 00:01:28
|
| I think you can select @@identityand raiserror and trap the raiserrorin your application using Sqlexception classif you got the iddentity you would inform user a successful insertion. |
|
|
|
|
|
|
How can informed record inserted