Additional changes

Limits in the Resource Governor with regard to temporary database usage continue to hold for the user-created temporary databases, just as they do for tempdb.

Large scale deallocation is not logged for temporary databases.

Replication Agent is never started for a temporary database.

Parallel queries

The child threads for parallel queries are assigned to the same temporary database as their parent.

Multiple-database transactions

A multidatabase transaction that spans temporary and nontemporary databases cannot start in a temporary database, since it would be impossible to recover such a transaction. However, a multidatabase transaction across only temporary databases does not have this restriction since temporary databases are re-created each time the server is restarted.