When accessing another database on the same instance of SQL Server Express, will you get the same performance you would as if you connected directly to that database?
For example, will this:
USE DatabaseA
SELECT * FROM DatabaseB.dbo.MyTable
Be just as fast as this?
USE DatabaseB
SELECT * FROM MyTable
John
Go to the complete details ...