
July 28th, 2006, 04:00 PM
|
|
Registered User
|
|
Join Date: Jul 2006
Posts: 1
Time spent in forums: 13 m 8 sec
Reputation Power: 0
|
|
SQL Server events and .Net Framework
Hi, I'm developing an application (C#) that must monitor a database table and do things with the new records inserted on it.
The insertions are made by another application.
Currently I'm doing the monitoring thing with a loop in which I check for new records, work on them if any, and mark them as processed(setting a value in a field).
I want to know if there is any way to do this catching an event generated by my MSSQL server when a new record is inserted. Can MSSQL 2000 send a message to my application telling it that a new record was inserted? I readed several forums and I found what I think is a solution but for Visual Basic 6, nothing for .Net.
Any insight is helpful. Thank you very much.
|