sqlblockedprocesses

sqlblockedprocesses copied to clipboard

See title. Fix was to change `@filenamePattern` instances to `@FilenamePattern`.

mattcargile

Should be monitorloop = bpReportXMLNode.value('(./@monitorLoop)[1]', 'nvarchar(100)'), instead of monitorloop = bpReportXMLNode.value('(//@monitorLoop)[1]', 'nvarchar(100)'),

Smakoffsky

The results are ordered by monitorloop (then by hierarchy) It would be more natural to be sorted by date. (Sometimes monitorloop's value resets? Maybe on reboots?)

mjswart-d2l