[Top] [All Lists]

Re: Being Notified from Multiple Databases

Subject: Re: Being Notified from Multiple Databases
From: herbert422
Date: 21 May 2007 09:07:02 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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.
> HTH...
> --
> Joe Webb
> SQL Server MVP 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] Current Thread [Next in Thread>
  • Re: Being Notified from Multiple Databases, herbert422 <=