Tag: SQL

  • Locked yourself out of a database? get access back …

    For any purpose, you set a database [named: test] to a single-user mode and forget to set AUTO_UPDATE_STATISTICS OFF before doing so, use a script to remove the single-user mode (it’s most likely the GUI dialog isn’t accessible, so the quick option is to use T-SQL) and gain access to the database back. The background…