Skip to content

sp_BlitzLock - New table mode breaks other stuff #3640

@erikdarlingdata

Description

@erikdarlingdata

Version of the script
Current

What is the current behavior?
I was quite foolishly working on this feature across two issue branches without realizing it, and I had changes on one that did not make it to the other, primarily:

  1. Hard-coded object names in table mode
  2. Incomplete query logic for parsing XML data

If the current behavior is a bug, please provide the steps to reproduce.
Just run the darn thing. The #dd temp table doesn't populate correctly with the current code because the @xe and @xd variables remain NULL unless the new "table" code branch is accessed.

What is the expected behavior?
Erik should mind his branches in the future.

Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
All versions of ErikOS contain this bug.

Metadata

Metadata

Labels

No labels
No labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions