microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Publishcation Types 4 SQL-NS

Subject: Re: Publishcation Types 4 SQL-NS
From: "James"
Date: Tue, 17 Jul 2007 10:34:05 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Ok, hadn't gotten that far yet in my SQL-NS 101 but did just look it up in 
the SQL Server TechCenter and it does look like the more elegant approach. 
Thanks for the tip.

JIM


"Joe Webb" <[email protected]> wrote in message 
news:[email protected]
> On Mon, 16 Jul 2007 16:34:43 -0500, James wrote:
>
>> I have our production database on an SQL 2000 DB Server.  I am developing 
>> a
>> notification application in the new 2005 Server.  My theory is to create 
>> a
>> publication from the 2000 Server to the 2005 Server and then the Instance
>> Applications on the 2005 Server will operate against the published data.
>>
>> 1. Will this work?
>> 2. Which type of publication? (Snapshot, Transactional...)
>>
>> *** I have complete control over both servers and databases so all 
>> options
>> are open.
>>
>> If the publication is periodically wiping out the or over the previous
>> 'snapshot?' will notifications be re-sent as the SQL-NS Server sees the 
>> data
>> as being new?
>>
>> Ideas welcome.
>>
>> thanks
>>
>>
>> JIM
>
>
> With SSNS, you can have a hosted event provider running on the SS 2005
> box, regularly retrieving event data from the SS 2000 box.
>
> Or have I misinterpreted your question?
>
> HTH...
>
> Joe
>
>
> -- 
> Joe Webb
> SQL Server MVP
> http://www.sqlns.com 



<Prev in Thread] Current Thread [Next in Thread>