Notiification services Help Please -- sql server notification services

Saravana
6/6/2007 2:16:00 PM

We are trying to use SQL server 2005 Notification services to alert an
biztalk system that there is a changed data in the table.We have store proc
which retrieves the result sets from multiple tables and if there is any
change in the result set any update or modify we want NS to trigger an test
file so that Biztalk will pick this file and execute the Store Procedure.I
was going thru the samples with instance file and and ADF files but still
doesnt come to an clear picture.If any one of you can shed light up on this
topic that will be really helpfull.
Thanks

Todd C
6/13/2007 5:43:01 AM

Hello Saravana

First: Get a copy of Shyam Pather's book on SQL NS. ISBN: 0-672-32779-1.
Read the section on the File System Delivery.

You should be able to set up NS to write to an XML file when it goes to
deliver its message.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server notification services

sql server notification services : Notiification services Help Please