sysindexes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » sysindexes

sysindexes

Rate Topic

Display Mode

Topic Options

Author

Message

pattikay

Posted Tuesday, August 07, 2001 7:20 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 6:34 AM
Points: 11, Visits: 2

When a server running sql 7.0 tries to get information from the sysindexes table of another server running sql 2000 ,following error occurs :
OLE DB provider 'SQLOLEDB' supplied inconsistent metadata for a column. Metadata information was changed at execution time.

The query i am running is :
select rows
FROM [serverRunningsql2000].[dbname].dbo.sysindexes
where indid < 2
AND id = 2007678200
Querying any other table is fine,but sysindexes always gives that error.
The servers are already linked.Any other query that is executed works fine ,but not any that queries the sysindexes table.
What could be causing this error?
Thanks in advance.

Post #711

David Benoit

Posted Tuesday, August 07, 2001 12:19 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 7:56 AM
Points: 2,063, Visits: 3,441

PattiKay,

Check out article Q255097 from Microsoft. This is apparently a known issue however they do suggest a workaround. Hope this helps and have a great day!

David

David

@SQLTentmaker
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Post #20567

Sean Burke

Posted Tuesday, August 07, 2001 7:52 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, August 29, 2002 12:00 AM
Points: 72, Visits: 1

Good find on the KB article David. I don't reccommend workaround #1

.

Patii, I'm curious to find out if workaround #2 works for you. Pelase let us know.

Sean

Post #20568

pattikay

Posted Wednesday, August 08, 2001 6:57 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 6:34 AM
Points: 11, Visits: 2

Thanks David and Sean for your suggestions.Sean your right, workaround #1 is out of the question.
Workaround #2 which is -->Create a view on the local server and then select from that view, instead of selecting from the view on the remote linked server.

It did not work,so i did the oppposite,i created a view on the remote linked server which selects from sysindexes , so i do not query sysindexes directly.
create view tot_att_vw
as
select rows from sysindexes
where indid < 2
and id = object_id("attendance_details")

so in the stored procedure i will be running :
select rows
FROM [serverRunningsql2000].[dbname].dbo.tot_att_vw

Though i am thinking of calling an sp instead of a view.

Thanks again for your suggestions.

Post #20569

« Prev Topic | Next Topic »

Permissions