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

On May 17, 11:19 am, Joe Webb <j...@webbtechsolutions.com> 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 MVPhttp://www.sqlns.com- Hide quoted text -
>
> - Show quoted text -