Apart from implementing an extended sp or using sp_OACreate and friends (allow you to call COM objects) you could use a new service for SQL Server called SQL Server Notification Services. It's a service which allows you to catch various types of events (both from SQL Server as well as other places) and notify interested parties/apps of the events.
More info at: http://www.microsoft.com/sql/NS/overview.asp Niels Developmentor http://staff.develop.com/nielsb > -----Original Message----- > From: Moderated discussion of advanced .NET topics. [mailto:ADVANCED- > [EMAIL PROTECTED]] On Behalf Of Wayne Enis > Sent: 03 July 2002 14:50 > To: [EMAIL PROTECTED] > Subject: [ADVANCED-DOTNET] Watching for SQL Events > > I'm after some functionality similar to the FileSystemWatcher component, > but watching for events within a SQL database, notifying me of any > insert, update or delete events.Is it possible to trap SQL events within > .net. The database i need to watch is a 3rd party product, where i have > not control over the software managing the data, the best i could > probably hope for is that i could create new triggers. > > Any ideas anyone ?? > > Wayne > > You can read messages from the Advanced DOTNET archive, unsubscribe from > Advanced DOTNET, or > subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
