Re: Being Notified from Multiple Databases
On May 17, 11:19 am, Joe Webb <[email protected]> wrote:
> On Wed, 16 May 2007 16:51:18 -0700, herbert422 wrote:
> > My question is it possible to configure SQL Notification Service to
> > monitor several databases instead of one. Currently I have code that
> > can monitor any changes on one database, but I would like to modify it
> > so that I am alerted when a database is changed amongst a set of
> > databases.
> > My current approach to it is very bulky and very ugly indeed. I was
> > thinking about spawning a thread to monitor each database. Every time
> > a database is changed it raises an event in VB.NET to obtain the newly
> > added record or to figure out which record was deleted and update my
> > application accordingly. The potential issue I can see with this
> > approach is concurrency and ensuring that data is correctly displayed
> > on my application.
> > Thanks in advanced
> If you are using the SQL Server Event Provider, you can create a view on
> one server that retrieves information from the other servers using linked
> servers. The view could use a union, etc.
> Joe Webb
> SQL Server MVPhttp://www.sqlns.com- Hide quoted text -
> - Show quoted text -
Unfortunately, there are permissions issues I can not resolve in
establishing a link server, and was hoping that there could be an
alternative to that option.
|<Prev in Thread]
||[Next in Thread>|
- Re: Being Notified from Multiple Databases,