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.