>>>>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
That is great! Thank you.
Christian Isberner
Software Consultant