Blog

I have set up sp_BlitzFirst to run as a job (for the PowerBI Dashboard). Occasionally, when it runs, it gets the following error: Msg 8152, Sev 16, State 13, Line 2980 : String or binary data would be truncated. [SQLSTATE 22001] This is actually happening in the sp_BlitzCache procedure at this line: INSERT #stored_proc_info (Read more

Downloaded First Responders Kit today (2017-12-07). After install, sp_blitz ran fine, but sp_blitzfirst is failing with an illegal XML character message. Full message is as follows: Msg 9420, Level 16, State 1, Procedure sp_BlitzFirst, Line 3146 [Batch Start Line 0] XML parsing: line 2, character 126, illegal xml character Complete output is: Setting up configurationRead more

I’ve been using sp_BlitzFirst (as well as other ‘First Responder’ scripts) for a while now without issue. Updated to latest version of sp_BlitzFirst this week: Version = ‘6.0’ & VersionDate = ‘20171201’. Since updating my scripts I’ve had errors on some (not all) of my servers running sp_BlitzFirst. SQL Server versions (2008, 2012, 2014 andRead more