>>>Hello,
>>>
>>>How can I make a query in SQL server that involves tables from different databases? I tried MyDB!MyTable, but that does not work.
>>
>>MyDB.dbo.MyTable
>>
>>(Use 3 parts naming convention - DbName.SchemaName.TableName)
>
>So the SchemaName is always "dbo"? or could that be different sometimes?
No,
Schema is not always dbo.
It could be other, but you could miss its name:
DBNAME..TableName
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
