Linked server from SQL 2005 64-bit to SQL 7

I've experienced the problem with creating a linked server from SQL 2005 64-bit to SQL 2000.

"The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".

I have resolved this by upgrading the system stored procs on the 2000 machine by running instcat.sql, documented in http://support.microsoft.com/default.aspx/kb/906954/en-us . Works great.

However, I'm now experiencing the same error when linking from SQL 2005 64-bit to SQL 7. I'm concerned about applying 2000 code onto a SQL 7 machine. Any ideas on how to handle this case?

Thanks

Paul

Hi Paul,

You can gohead and apply the 2000 code instcat.sql in SQL server 7.0, Upgrading the catalog stored procedures does not affect the operation of existing SQL Server clients...

But for this you should have Admin rights and please do take a backup of the Master DB and then apply the code.

Thanks

Thamizhan