On 2016/04/19 8:34 PM, Jarred Ford wrote: > Is it possible to create multiple in-memory databases and be able to access > tables with a single query between them? For example, select * from > db1.dbo.table1 db1 join db2.dbo.table1 db2 on db1.x = db2.x.
No. An in-memory database has no descriptor or handle that can be accessed externally. You can make several connections which can all spawn in-memory databases, but you cannot attach a memory database to another memory database in another connection. (you can of course easily attach other file DBs to a memory DB, but that point is moot). If it was me... I would make all the tables in one memory database - why do you need many? Prepend table names in stead of DB names. The change effort is very little to go from specifying "db2.table1" to "db2Table1", etc - though I realize you would have a real reason why you needed it like you've specified. Best of luck, Ryan
