May 14, 2009 at 12:44 am
Hi Al,
getting the error
"Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for
OLE DB provider "SQLNCLI10" for linked server "LinkedServer".
The provider supports the interface, but returns a failure code
when it is used. OLE DB provider "SQLNCLI10" for
linked server "RPMServer" returned message "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "LinkedServer" returned message
"Query timeout expired".
Please help me on this.
Thanks in advance
May 14, 2009 at 5:38 am
marees.inspire (5/14/2009)
Hi Al,getting the error
"Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for
OLE DB provider "SQLNCLI10" for linked server "LinkedServer".
The provider supports the interface, but returns a failure code
when it is used. OLE DB provider "SQLNCLI10" for
linked server "RPMServer" returned message "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "LinkedServer" returned message
"Query timeout expired".
When are you getting this error..?
Was it working before..?
Both the servers are having SQL server..? which version..?
October 6, 2009 at 8:22 am
run this on the master DB of the sql 200 server...
create procedure sp_tables_info_rowset_64
@table_name sysname,
@table_schema sysname = null,
@table_type nvarchar(255) = null
as
declare @Result int set @Result = 0
exec @Result = sp_tables_info_rowset @table_name, @table_schema, @table_type
go
August 26, 2011 at 2:17 pm
SSC Rookie
This worked for me
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply