Skip to content

Instantly share code, notes, and snippets.

@JosiahSiegel

JosiahSiegel/read_error_log.sql

Last active January 18, 2016 14:00
Show Gist options
  • Save JosiahSiegel/eaa2f716d3d2bc0c3733 to your computer and use it in GitHub Desktop.
Save JosiahSiegel/eaa2f716d3d2bc0c3733 to your computer and use it in GitHub Desktop.
Download ZIP
#MSSQL #Research #Users Read error log
Raw
read_error_log.sql
DECLARE @temp_error_log TABLE
(
date datetime,
process varchar(50) null,
text varchar(MAX) null
)
INSERT INTO @temp_error_log
EXEC sp_readerrorlog 0, 1--, 'Login failed'
SELECT * FROM @temp_error_log
ORDER BY date DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment