Msg 7311, Level 16, State 2, Line 1

The reason for this error message is as follows: “You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server”.

Resolution:

To Fix the above issue we have two options:

* Creating Store procedure on Master database (or)

1) Connect to SQL Server
2) Create the below store procedure in Master database
2.1) create procedure sp_tables_info_rowset_64 @table_name sysname, @table_schema sysname = null, @table_type nvarchar(255) = null
as
declare @Result int
select @Result = 0
exec @Result = sp_tables_info_rowset @table_name, @table_schema, @table_type

2.2) GRANT EXECUTE ON sp_tables_info_rowset_64 TO USER

* Updating SQL Server system catalog files

Please refer the KB article to do this --> http://support.microsoft.com/kb/906954

Note: the kb article updates several things on Master database instaed of updating system catalogs, i would prefer step 1... bcoz i m done with step 1 and its successfull with out any issues :)

Thanks,
Satish Kumar.

Ole Automation Procedures' does not exist, or it may be an advanced option

Please execute below to resolve the issue:

EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE

EXEC master.dbo.sp_configure 'Ole Automation Procedures', 1
RECONFIGURE

Thanks,
Satish Kumar.