"Aubrey" <miscuates@online.nospam> wrote in message
news:1C22A686-4D3B-4EC1-A03C-98EDBE21CD71@microsoft.com...
> How do I / Can I use SQL 2005 Express Edition to subscribe to a SQL 2000
> Publication?
>
> I attempted to use Windows Synchronizer to create an Anonymous Merge
> Subscription on a Laptop running Windows Vista Home Premium with SQL
> Server
> 2005 Express Edition. It 'complained' that SQL 2005 cannot subscribe to
> SQL
> 2000.
>
> All older Laptops run Windows XP Pro with MSDERelA and have worked great
> for
> years. We are running an Access XP Runtime Application. (And the won't
> load
> on Vista either!)
> --
> Aubrey Kelley

"Charles Wang[MSFT]" wrote:

> Hi, Aubrey,
> I understand that the Merge Replication failed to be setup between your SQL
> Server 2000 publisher and anonymous SQL Server 2005 Express subscriber.
> If I have misunderstood, please let me know.
>
> This is by design, for merge replication, the subscriber version number
> cannot exceed the publisher version number; however you can create snapshot
> or transaction replication from SQL Server 2000 to SQL Server 2005 Express.
> If merge replication is required in your situation, I recommend that you
> upgrade your SQL Server 2000 to SQL Server 2005; otherwise, you may still
> need to use MSDE 2000.
>
> If you have any other questions or concerns, please feel free to let me
> know.
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================
> Get notification to my posts through email? Please refer to:
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
>
> If you are using Outlook Express, please make sure you clear the check box
> "Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
>
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ======================================================
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================
>
>
>