You can use sp_tempdb to bind logins and applications to temporary databases or temporary database groups, and to create temporary database groups in both the nonclustered Adaptive Server and the Cluster Edition. In the Cluster Edition, which supports both local and global temporary databases, you can bind logins or applications to local user temporary databases or temporary database groups, but not to global temporary databases.
The default temporary database group is system-generated and always present. It is empty unless you use sp_tempdb to add local temporary databases to it. In the Cluster Edition, the local system temporary database is not part of the default group.
The sp_tempdb user interface includes the option unbindall_gr, which removes all bindings to the specified group in either the nonclustered Adaptive Server or the Cluster Edition. In addition, the unbind option includes an instance_name parameter that is specific to the Cluster Edition.
