Phil,
Can you provide the entire query or statement you are issuing?
Four-part table names are allowed in some places and not others.
Steve Kass
Drew University
[quoted text, click to view] phil wrote:
>The object name 'pic_db.pubs.dbo.authors' contains more
>than the maximum number of prefixes. The maximum is 2.
>
>when i tried selecting from a linkedserver i get this
>message. help anyone?
>
>thanks very much
>PHil
>
>