>>I want to pull data from a table on SMAP001. I'm in server SMIT001. I have created a linked server to SMAP001
>>
>>I have this so far
>>
>>

>>	SELECT	smap001.PK5.PD.PD_IMKEY AS Item,
>>			Min(smap001.PK5.PD_PREF) AS MinOfPD_PREF
>>		FROM PD
>>		GROUP BY PK51PD.PD_IMKE
>>
>>
>>

>>
>>I'm getting "Invalid object name 'smap001.PK5.PD'."
>
>You should use full syntax to get DB:
>
>

>	SELECT	PD.PD_IMKEY AS Item,
>		Min(PD.PD_PREF) AS MinOfPD_PREF
>        FROM smap001.PK5.SchemaHere.PD PD
>	GROUP BY PD.PD_IMKE
>

Ok, I now get "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."