Although the following procedures have not changed, they are relevant to temporary databases:
Procedure name |
Description |
|---|---|
sp_changedbowner |
You can change ownership of user-created temporary databases, whereasyou cannot for system databases, including tempdb. |
sp_defaultloc |
You cannot map system databases, including tempdb to a default location. However, you can map user-created temporary databases. |
sp_renamedb |
You cannot rename system databases, including tempdb. However, you can rename user-created temporary databases. You must ensure that existing bindings for the temporary database being renamed are dropped, and re-created using the new database name. |
