One of the most common issues faced while connecting to a SQL Server instance is "Login failed for user 'username'. (Microsoft SQL Server, Error: 18456)". In addition to the Error No. SQL Server will provide an Error State no. which will be helpful…
This article guides you in finding the user, process and host, which produced too many transactions filling the transaction log and preventing you from shrinking it.