> I there a way to set up something like a delegate for a database. > Specifically I'm interested in having the database firing an > event when a row changes. I heard that this is going to be > possible with Yukon but can this be done now ? I'm > interested in databases other than MSSQL also. > Thanks in advance...
In SqlServer 2000 you could write an extended stored procedure (in C++) which is called by a trigger on your table. The extended proc could for example send a message to a tcp socket or through a named pipe to a .NET service you write and you have your notification :) i.o.w.: not very easy. Frans. -------------------------------------------------------------------- Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com My .NET Blog : http://weblogs.asp.net/FBouma Microsoft MVP (C#) -------------------------------------------------------------------- =================================== This list is hosted by DevelopMentorŪ http://www.develop.com Some .NET courses you may be interested in: Essential .NET: building applications and components with CSharp August 30 - September 3, in Los Angeles http://www.develop.com/courses/edotnet View archives and manage your subscription(s) at http://discuss.develop.com