drop table if exists #sql create table #sql ( Logdatae varchar(50), processinfo varchar(50), [text] varchar(max) ) go INSERT INTO #sql Exec xp_readerrorlog 0 Go SELECT distinct right(text,16)FROM #sql WHERE Logdatae like 'Apr 17 2019%' AND text LIKE 'Login failed for user ''sa''. Reason: Password did not match that for the login provided%'