>I am curently on \\SJ..DWD2 I need to check data in : \\A2333SR_TEST\DS_PROGEDD.dbo.progedd_paccid
>
>when I do a select * from \\A2333SR_TEST\DS_PROGEDD.dbo.progedd_paccid I get an error abot a '\'
>
When I did select * from [A23339\SR_TEST].DS_PROGEDD.dbo.progedd_paccid
it kicked back Could not find server 'A23339\SR_TEST' in sysservers. Execute sp_addlinkedserver......
So that is the answer that I was looking for.
__Stephen