25112
asked on
not able to get full text of query
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(0x010 00E0036A22 110001927D 0030000000 0000000)
SELECT cast(TEXT as varchar(max)) FROM ::fn_get_sql(0x01000E0036A 2211000192 7D00300000 000000000)
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
thanks
(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(0x010
SELECT cast(TEXT as varchar(max)) FROM ::fn_get_sql(0x01000E0036A
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
thanks
Is this on sql 2005 or 2008?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.