Groups | Blog | Home
all groups > dotnet general > june 2005 >

dotnet general : SQL 2000 and .NET events


jabailo NO[at]SPAM texeme.com
6/25/2005 7:53:10 PM

Can a SQL 2000 server raise a .NET event?

--
Texeme Textcasting Technology
Mario
6/26/2005 1:09:08 AM
be more clear

[quoted text, click to view]
jabailo NO[at]SPAM texeme.com
6/26/2005 11:38:31 AM
[quoted text, click to view]

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.



[quoted text, click to view]

--
Texeme Textcasting Technology
Carlos Lopes
7/1/2005 3:55:02 AM
Mario,

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



[quoted text, click to view]
AddThis Social Bookmark Button