xp_readerrorlog Msg 22004

When using xp_readerrorlog you may receive the error message:
 
Msg 22004, Level 12, State 1, Line 0
Error executing extended stored procedure: Invalid Parameter Type

 
image1
Pre-SQL Server 2012 this does work.
image2
From SQL Server 2012 onwards you require the N prefix:
image3

Leave a Reply