When you run into errors running queries after adding a linked server which runs sql server 2000 on a machine running sql server 2008 try the openquery function instead :
insert into tablename (fieldname, fieldname) select * from openquery(servername,'select fieldname,fieldname from dbname.dbo.tablename')