All objects have a four part name:
server.database.owner.objectname
If possible, objects should be referred to by owner.objectname;
SELECT * FROM dbo.authors
-Mike
>>>May be Mike will join this thread then, though I guess, I'm being paranoid... :)
>>
>>I'm here but you already got your answer ;-)
>>
>>-Mike
>
>Thanks. Just was curios, what is in your book, since I don't have it where I'm now.
>
>Here is the link, somebody pointed me to
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_syntaxc_9kvn.asp