You can create shareable temporary tables in both user-created temporary databases and in the system tempdb. Existing applications that use tempdb when creating shareable temp tables will continue to create these tables in the system tempdb. This allows cooperating applications and sessions that communicate through the shareable tables in the temporary database to continue to work as before.New applications can create their shareable temporary tables in a user-created temporary database. These works similarly to shareable temporary tables created in tempdb. That is, they are accessible to other sessions, and persist until you restart the server, unless you explicitly drop them.
Applications that use user-created temporary
databases will not work if the designated user-created
temporary database is dropped.
