>>>>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'."
>
>
>You didn't set your linked server well.
>You should set all security and logons.
How?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people