Because a local system temporary database is always in use if its owner instance is running, you cannot drop a local system temporary database while its owner instance is running.
To drop a local system temporary database, shut down the instance, and then drop the local system temporary database from another instance.
