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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top