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 - 2006-01-09 : 08:28:39
|
| Brian writes "I have a client application that polls a table in a local db to see if a row has been inserted. I would prefer that the db raise some event when a row is inserted and then handle it in the client app. Something simillar to the SQLConnection.InfoMessage event. Although the event has to fire for all connections. The connection that inserts the row is not the connection that is polling.With SMO, I could handle DDL events in a client app such as Drop Index, Table Created, etc. What exists in SQL Server 2005 to handle simple DML events, such as a row inserted?Any message back from a trigger only goes to the connection that inserted the row.Thank you for any help.Brian" |
|
|
|
|
|
Event at client when inserting a row.