Places a local system temporary database in the drop state.
sp_tempdb_markdrop database_name [, {'mark' | 'unmark'}]
database_name – is the name of the local system temporary database you are dropping.
mark – marks the specified database for dropping.
unmark – clears the mark from the database.
This example marks a local system temporary database named “old_cluster_tempdb1” to be dropped:
sp_tempdb_markdrop 'old_cluster_tempdb1', 'mark'
This example removes the mark from the local system temporary database “old_cluster_tempdb1”:
sp_tempdb_markdrop 'old_cluster_tempdb1, 'unmark'
To delete the last local temporary database:
Use sp_tempdb_markdrop to place the local system temporary database in the drop state.
Shut down and restart the instance that owns the last local temporary database.
After you mark the local system temporary database to
be dropped, the owner instance restarts if there are no other active
instances. This instance does not use the marked local system temporary
database when it starts.
Use drop database to delete the last local system temporary database.
