SQL 2000 and .NET events

  • Thread starter Thread starter jabailo
  • Start date Start date
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.
 
Mario,

i don't think you can do it with SqlServer 2000, but you can do it with Sql
Server 2005 and VS 2005.
 
Back
Top