Several stored procedures have been altered to work with multiple temporary databases:
sp_helpdb now reports whether or not a database is a user-created temporary database. This appears under the status column.
sp_helpdb "mytempdb3"
name db_size owner dbid created status ------- ------- ----- ---- ------- ----- mytempdb 32.0 MB sa 7 Dec 12, 2001 select into/bulkcopy/pllsort, trunc log on chkpt, user created temp db
sp_bindcache – has been extended to prevent binding of individual tables to a named cache in user-created temporary databases.
sp_dboption – has been extended to prevent user-created temporary databases from being set to single-user mode. Additionally, when an attempt to alter the options for a temporary database is made, a warning is issued – database options across all temporary databases must be consistent.
sp_dropuser – has been extended to prevent a guest user from being dropped from user-created temporary databases.
