21 Sep, 2022
T-SQL query to find repetitive failed logins in SQL Server 0 (0)
MSSQL, T-SQL Scripts , ,

Below script is used to find logins which are failing repeatedly since 1 day. you can change the number of days as per your requirement. this script is taken from Here

SET NOCOUNT ON

	DECLARE @ErrorLogCount INT 
	DECLARE @LastLogDate DATETIME
… Read the rest