Any body tryed to link SQL2000 to SQL2005 or other way arround.
add sql2k to sql2005, and vice versa, as linked server is a supported scenario.for example, from a connection to your sql 2005, run the following commands to add sql2k as a linked server:
sp_addlinkedserver 'sql2k'
sp_setnetname 'sql2k', <machine name>\<instance name>
where 'sql2k' is the linked server name of your choice, <machine name> is the hostname of the machine where your sql 2000 is installed, and <instance name> is the name of your sql 2000 instance. If it is a default instance, then simply
sp_setnetname 'sql2k', <machine name>sql
