Mario wrote:
On SQL Server, you have 'events', sort of, in the form of triggers. When
someone inserts a record, other things can happen.
In Remoting, I can raise events on a server which can raise events on my
windows clients.
So, I am thinking, I should be able to set up a trigger, that runs a
program, that sends a message to a Remoted server, and which then notifies
my clients that something on the database has changed.
My question is, does .NET integrate enough with SQL server so that I am able
to do this? My clumsy way would be to let the trigger run a stored
procedure that runs a console application in DOS.