search

amachanic / sp_whoisactive

sp_whoisactive
GNU General Public License v3.0
1.13k stars 281 forks source link

XML datatype instance has too many levels of nested nodes. Maximum allowed depth is 128 levels #111

Closed rwyoung01 closed 3 weeks ago

rwyoung01 commented 9 months ago

I have a job that load the WhoisActive results into a table every 30 seconds. I can not load the table when the XML SQL_TEXT has to many nested nodes. Is there a way to filter these records or some other work around. Load this data into a table has helped us solve some many issues.

erikdarlingdata commented 3 weeks ago

@rwyoung01 there’s no way to filter those out currently. You may need to change the column data type to nvarchar max if this is a frequent occurrence.