If you are trying to link sql2000 from the new 64bit 2005 servers and get a message similar to this - “provider supports the interface, but returns a failure code when it is used” you may need to apply the fix below.
c:\Program Files\Microsoft SQL Server\MSSQL\Install>osql -pUSER -pPASSWORD -s[SERVER] -iinstcat.sql