Ad Widget

Collapse

how to monitor sql2008 error log[encoding problem]

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • peng_hb
    Junior Member
    • Jul 2013
    • 4

    #1

    how to monitor sql2008 error log[encoding problem]


    i use zabbix active agent monitor sql2008 error log
    key=log["C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG.6"]
    i can't collect any information
    i use Notepad++ to open log file ERRORLOG.6,the encoding is UCS-2 little endian

    when i use Notepad++ change the encoding to UTF-8,zabbix conlect log information normal

    but SQL can't change the error log encoding
    i use key=key=log["C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG.6",, "UCS-2"]
    can't collect any information

    what is the problem?
  • Komodoro
    Junior Member
    • Nov 2013
    • 4

    #2
    Instead of using UCS-2 in the end, use UTF-8 mate.

    Comment

    Working...