Is there anyway I can setup a subscription on a SQL 2008 server with the publication on a SQL 2000 server. I keep getting the error message version 10.0 of SQL is not supported when I try to set it up. Any ideas?
You can setup replication from 2000 to 2008 and vice verca. The only requirement is the distributor should be at least same version as publisher.
To addup what DInaker mentioned See http://www.vinodunny.com/blog/post/...eplication-between-SQL-2000-and-SQL-2008.aspx blog.
Yet whenever I try and setup the replication on the SQL 2000 box it says that This SQL Version (10.0) is not supported!