SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


sysindexes


sysindexes

Author
Message
pattikay
pattikay
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 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.



David Benoit
David Benoit
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14138 Visits: 3650
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

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Sean Burke
Sean Burke
Mr or Mrs. 500
Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)Mr or Mrs. 500 (578 reputation)

Group: General Forum Members
Points: 578 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



pattikay
pattikay
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 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.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search