sql server: get the full text of a long request

This may be due to the maximum number of characters that the result to the grid can return, 65535.

enter the description of the image here

You cannot change this to be higher than this number.

The text data type of sys.dm_exec_sql_text is nvarchar(max), there are no problems there.

You can convert the column to XML as an alternative solution

SELECT CAST(t.(text) AS XML)
FROM sys.dm_exec_requests AS r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS t

Or a better method by Evgeniy Gribkov

SELECT t.(text) 
FROM sys.dm_exec_requests AS r 
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS t 
FOR XML RAW, ELEMENTS;

Better this way: SELECT t. (Text) FROM sys.dm_exec_requests AS CROSS
APPLY sys.dm_exec_sql_text (r.sql_handle) AS t FOR XML RAW, ELEMENTS;
Since the request text cannot always be converted to XML. In
in particular, you cannot convert the query text when it is called stored remotely
procedures: "XML analysis: line 13, character 129, illegally qualified
character name "

Or save the results in a file

enter the description of the image here

ubuntu: choregraphe project data recovery after a full restart lock

I am working with Choregraphe to build some robot functions in a project. Recently I did something to make my project freeze not only my Choregraphe, but also my entire system froze until I disconnected it. Once I restarted, I tried to start the project to correct the error in the project. To my surprise, Choregraphe will lock on the desktop in any attempt to open the project. Despite this, no other projects were affected. I was wondering if anyone had any advice or suggestion to recover the project, since they have years of work from former colleagues that would be difficult to replace.

Trump supporters: Do you have a photo of Donald Trump in full military uniform like this photo of Pete Buttigieg?

Report abuse

Additional details