To drop the local system temporary database of the last instance:
Use sp_tempdb_markdrop to mark the database to be dropped. For example, if ase3_tdb1 is the last local system temporary database, mark it with this command:
sp_tempdb_markdrop ase3_tdb1
Shut down and restart the last instance. The local system temporary database marked for “drop” is not used.
Drop the temporary database from this instance.
