Dropped the database your logon trigger writes to? Every login then fails with Error 17892 Logon failed. I recreate the problem and show how to get back in.
SQL SERVER – Find All Servers From Local Network – Using sqlcmd – Detect Installed SQL Server on Network
Find every SQL Server on network with one command: sqlcmd -L or osql -L lists the instances on your local network. An update to my old isql script.
SQL SERVER – sqlcmd – Using a Dedicated Administrator Connection to Kill Currently Running Query
When a long running query makes SQL Server stop responding, sqlcmd with a Dedicated Administrator Connection lets you connect from another computer and kill it.
SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor
Turn on SQLCMD Mode and the SSMS Query Editor can run sqlcmd scripts that mix OS and SQL commands. The interesting part: the OS commands run first.
SQL SERVER – sqlcmd vs osql – Basic Comparison
sqlcmd vs osql: which one should you use to run queries from the command prompt? A short comparison of isql, osql and sqlcmd, and why I pick sqlcmd.
SQL SERVER – 2005 – Introduction and Explanation to sqlcmd
An introduction to sqlcmd, the SQL Server 2005 command prompt utility that runs ad hoc T-SQL statements and scripts, and how it improves on isql and osql.
SQL SERVER – Fix : Error : Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset DBSCHEMA_TABLES_INFO for OLE DB provider SQLNCLI for linked server LinkedServerName
Msg 7311 comes up when a 64-bit SQL Server 2005 runs distributed queries against a linked 32-bit SQL Server 2000 or 7.0. Running instcat.sql with osql fixes it.