We have built a small windows service using SQL Server WMI Provider, Every time a connection is established a WMI async event is triggered by SQL Server WMI Provider and this trigger is handled by a custom component. We do some custom business logic check and if the user is not a legitimate user then his connection is disconnected ... there are still some pitfall in this code :-)
I have not tried this out but going thru the documentation it is possible to capture Insert/Delete/Update event externally without touching the database. Note : You need to download SQL WMI provider before trying this out... Regards Yogesh Shetty Team COE Financial Technologies (India) Ltd. URL: <http://www.ftindia.com> www.ftindia.com mailto : <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] contact : +91 22 6164145 -----Original Message----- From: Moderated discussion of advanced .NET topics. [ <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED]] On Behalf Of Niels Berglund Sent: Wednesday, July 03, 2002 10:52 PM To: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] Subject: Re: [ADVANCED-DOTNET] Watching for SQL Events 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> http://www.microsoft.com/sql/NS/overview.asp Niels Developmentor <http://staff.develop.com/nielsb> http://staff.develop.com/nielsb > -----Original Message----- > From: Moderated discussion of advanced .NET topics. [ <mailto:ADVANCED-> mailto:ADVANCED- > <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]] On Behalf Of Wayne Enis > Sent: 03 July 2002 14:50 > To: <mailto:[EMAIL PROTECTED]> [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> 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> 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.
