Schema unusable after deleting another database
It looks like you'll need to change the user's default database, as it appears this is currently set to DB1, which no longer exists.

exec sp_defaultdb @loginame='user1', @defdb='DB2'


OR

ALTER LOGIN &lt;login_name&gt; WITH DEFAULT_DATABASE = &lt;default_database&gt;