SQL Server Developer >> Odd link server bahavior with error 7352
Im running sql server 2000 sp3. MDAC 2.8 when i try to run a remote query
against another server using a linked server i get the following:
Msg 7352, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. The object
'[GADBPROD02].[craApplicationLog].[dbo].[companyUserSubscriptions]' was
missing expected column 'companyId'.
here's the funny part. The statement im running which i will paste in below
works if my input parameter is changes, and it also works if I use open
query...
This Fails...
SELECT DISTINCT psr.companyId
FROM GADBPROD02.craApplicationLog.dbo.companyUserSubscriptions cus
INNER JOIN PersonSubscriptionRelationships psr
ON psr.companyId = cus.companyId
WHERE psr.personId = 10757
These succeed...
SELECT DISTINCT psr.companyId
FROM GADBPROD02.craApplicationLog.dbo.companyUserSubscriptions cus
INNER JOIN PersonSubscriptionRelationships psr
ON psr.companyId = cus.companyId
WHERE psr.personId = 10743 --just changed the id for the input param
or...
SELECT DISTINCT companyId FROM
openquery(GADBPROD02,'select* from
craApplicationLog.dbo.companyUserSubscriptions cus
INNER JOIN [eq-dbsvr].crm.dbo.PersonSubscriptionRelationships psr
ON psr.companyId = cus.companyId
WHERE psr.personId = 10757')
I have seen numerous posts on the web but no solutions. I have considered
upgrading to SP4 and or MDAC 2.8SP1 but only if someone knows for sure that
it is a solution... any other help would be appreciated...
Thanks,
-Tim