mssql error 로그 확인 하기.

sp_readerrorlog   명령어이다. 

해당 명령어 프로시져는 아래와 같이 되어 있으며, 

각 하위 옵션은 아래내용확인 바란다. 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

CREATE PROC [sys].[sp_readerrorlog](    @p1     INT = 0,    @p2     INT = NULL,    @p3     VARCHAR(255) = NULL,    @p4     VARCHAR(255) = NULL) AS BEGIN    IF (NOT IS_SRVROLEMEMBER(N'securityadmin') = 1)    BEGIN       RAISERROR(15003,-1,-1, N'securityadmin')       RETURN (1)    END      IF (@p2 IS NULL)        EXEC sys.xp_readerrorlog @p1    ELSE        EXEC sys.xp_readerrorlog @p1,@p2,@p3,@p4 END

 

This procedure takes four parameters:

1. Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc...

2. Log file type: 1 or NULL = error log, 2 = SQL Agent log

3. Search string 1: String one you want to search for

4. Search string 2: String two you want to search for to further refine the results