>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)
If it's not broken, fix it until it is.
My Blog