sql server replication: hi all,

im thinking this is not impossible, but any links or tips on how to set this

As long as you have a 2005 distributor this is ok
(http://msdn2.microsoft.com/en-us/library/ms143241.aspx). Even new datatype
columns (eg varchar(max)) can be replicated and the mapping is automatic. To
set up, do it all from SSMS and have SQL 2000 subscriber registered there
also - it's much the same as setting up any other publication.
Cheers,
Paul Ibison

ChiWhiteSox wrote on Sat, 14 Jul 2007 10:56:01 -0700:

[quoted text, click to view]

Definitely possible, I've got such as setup running here at work. It's easy
using SSMS to setup, or scripted.

It's also possible to have a SQL 2005 publisher and a SQL 7 subscriber, but
you can't use SSMS to do this as it can't connect to SQL 7. It was a new
experience for me not using a GUI to set this up, but I didn't have any
choice and it's been working fine :)

Dan