debugsqlMinor
SSMS v18.9.2 Display Estimated Execution Plan returning XML error
Viewed 0 times
errorssmsxmlplanreturningestimateddisplayexecutionv18
Problem
From SSMS v18.9.2, when highlight a simple Select query like
An error occurred while executing batch. Error message is: Error processing execution plan results. The error message is:
There is an error in XML document (1, 2049).
Unexpected end of file while parsing Name has occurred. Line 1, position 2049.
Anyone know what is causing this and how to fix it? Thanks in advance.
select * from sys.tables" in the master database (or any database), I get the following message:An error occurred while executing batch. Error message is: Error processing execution plan results. The error message is:
There is an error in XML document (1, 2049).
Unexpected end of file while parsing Name has occurred. Line 1, position 2049.
Anyone know what is causing this and how to fix it? Thanks in advance.
Solution
It looks like the issue was my
Go to Tools -> Options -> Query Execution -> SQL Server -> General. Then, in the SET TEXTSIZE box, enter 2147483647, and click OK.
SET TEXTSIZE option was set to 0. I changed it to 2147483647 and the issue went away.Go to Tools -> Options -> Query Execution -> SQL Server -> General. Then, in the SET TEXTSIZE box, enter 2147483647, and click OK.
Context
StackExchange Database Administrators Q#306608, answer score: 5
Revisions (0)
No revisions yet.