Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sysindexes Expand / Collapse
Author
Message
Posted Tuesday, August 7, 2001 7:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 1, 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
Posted Tuesday, August 7, 2001 12:19 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:47 PM
Points: 2,107, Visits: 3,584
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
Posted Tuesday, August 7, 2001 7:52 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Wednesday, August 8, 2001 6:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 1, 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 »

Add to briefcase

Permissions Expand / Collapse