not able to get full text of query
Posted on 2013-01-18
both the below statements are not bringing the full content of the query back..
(it brought 44k characters, but then truncated it) 43679 exactly..
SELECT DISTINCT cast(TEXT as varchar(max)) FROM sys.sysprocesses OUTER APPLY SYS.DM_EXEC_SQL_TEXT(0x01000E0036A22110001927D00300000000000000)
SELECT cast(TEXT as varchar(max)) FROM ::fn_get_sql(0x01000E0036A22110001927D00300000000000000)
for a query bigger than that, is it possible to capture it with the new DMVs or other SQL Server feature?
INPUTBUFFER also has that limitation, it seems like