dbcc addtempdb

dbcc addtempdb adds a temporary database to the global list of available temporary databases. The syntax for this command is:

dbcc addtempdb( dbid | dbname )

If the database does not exist or is not a temporary database, an error is generated. If the database is already a member of the list, an informational message prints.