Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I'm trying to run sp_Blitz for the first time and getting this error message:
sp_Blitz @CheckUserDatabaseObjects = 0
Warning: Null value is eliminated by an aggregate or other SET operation. Msg 567, Level 16, State 5, Procedure sp_Blitz, Line 3863 [Batch Start Line 0] File '' either does not exist or is not a recognizable trace file. Or there was an error opening the file.
What may be causing the error?
There's a weird bug that only pops up on some instances of SQL Server when the Trace File path has problems. I can't diagnose those, but we took some steps to avoid that bug which are in the latest version of sp_Blitz.
Please head over to firstresponderkit.org to grab the newest version, and file an issue at the GitHub repo if you run into anything else.
Thanks!
