That was quite clear and informative. I will try and implement the same and
get back to you in case of any doubts.
Thanks a bunch !
"Joe Webb" wrote:
> Hi Priya -
> Welcome to the SQLNS world!!! This newsgroup is a great place to learn
> and ask questions. Come often.
> Using the built-in SQL Server Event Provider, you can use 3 or 4 part
> names to query other tables in other databases in the same SQL Server
> instance or in linked servers, respectively.
> To query a table in another database in the same SQL Server instance,
> you could do something like this:
> <!--Event Providers-->
> <Value>SELECT PrId,
> , PrDate
> , PrType
> PrId NOT IN (SELECT
> PrId FROM
> To query a table in a database in another SQL Server instance, add a
> linked server and then use 4 part names. In the prior example, you'd
> As for examples and where to learn more...Shyam Pather has written an
> excellent book on SQLNS. I also have a book out there on it. Both may
> be found on Amazon by searching for SQL Server Notification Services.
> I'm not aware of sites dedicated to SQLNS (although that's on my list
> of things to do), but I do have a blog dedicated to the technology. I
> just started it last month, but intend to update it at least weekly.
> Here it is: http://www.sqlns.com. I'd love to hear comments on what
> you'd like to see on it.
> Joe Webb
> SQL Server MVP
> Get up to speed quickly with SQLNS
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)On Mon, 10 Oct 2005 03:33:03 -0700, "Priya"
> <[email protected]> wrote:
> >I am facing a problem similar to a previous post in this forum.
> >I have an existing application and we need to integrate SQLNS inorder to
> >cater our Notification requirements. I'm not able to figure out how the
> >appADF.xml file has to be configured when the database to be queried is
> >different from the database SQLNS creates by itself for storing subscriber
> >and event details.
> >Can you please guide me with some examples as to how this can be done.
> >As I'm a novice in this field, will be quite helpful if u could suggest some
> >sites where i can find examples other than the samples provided during
> >Thanks & Regards