sp_tempdb allows users to:
Create the default temporary database group
Bind temporary databases to the default temporary database group
Bind the “sa” login and applications to the default temporary database group or to specific temporary databases
The syntax for sp_tempdb is:
sp_tempdb [
[ { create | drop } , groupname ] |
[ { add | remove } , tempdbname, groupname ] |
[ { bind, objtype, objname, bindtype, bindobj [, scope, hardness ] } |
{ unbind, objtype, objname [, scope ] } ] |
[ unbindall_db, tempdbname ] |
[ show [, "all" | "gr" | "db" | "login" | "app" [, name ] ] |
[ who, dbname ]
[ help ]
]
For detailed parameter and usage information, see Reference Manual: Stored Procedures.
