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-09-27 : 07:59:09
|
| Rim writes "Hi, I need help in the following issue, I have a this table that receives new records very frequently from a tcp connection, each new record arrives to the table has to be sent to an application to be processed, message rate is about 5 messages per moment (could be a second +-).I need a way to detect new inserted records and send a notification with the record to the application, how can I perform that with out having an over head on the server from the roundtrips every moment, can I use triggers?? or does SQL-DMO have anything to do here??at the moment, I am doing the round trips manually, but I need to automate it if possible..im using windows 2000VS .NET 2003SQL server 2000PLease help me, soon..Thanks in advance.." |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-09-27 : 12:01:27
|
| trigger seems to be what you are asking for. BOL(books online) has all the info you will need.Help us help YOU!Read this blog entry for more details: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx*need more coffee*SELECT * FROM Users WHERE CLUE > 0(0 row(s) affected) |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-28 : 02:03:45
|
you may want to do it the other way around...schedule the application to check for new records inserted instead of tasking the server to invoke the application, by just adding one column to keep track which rows have been inserted recently or utilizing an auto-increment column or datetime columnjust my 2 cents...  --------------------keeping it simple... |
|
|
|
|
|
|
Detecting new inserted records