SQL Server Profiler text data gets truncated

295 views Asked by At

I'm running SQL Server Profiler and I'm seeing some large LINQ queries are getting truncated in the TextData.

It looks like this:

exec sp_executesql N'SELECT 
    [Project91].[C14] AS [C1], 
    [Project91].[C1] AS [C2], 

etc...

[Project33].[MyField] AS [MyField], 
[Project33].[MyField2] AS [MyField2], 
',N'@p__linq__30 uniqueidentifier,@p__linq__29 uniqueidentifier,@p__linq__31 

etc...

There's no way that query would end with a comma like this before the parameters list.

Is there a way to increase the size of the field?

The version of SQL Server Profiler that I'm running is:

SQL Server Profiler                     15.0.18424.0
SQL Server Management Objects (SMO)     16.100.47021.0+7eef34a564af48c5b0cf0d617a65fd77f06c3eb1
Microsoft Data Access Components (MDAC) 10.0.19041.2486
Microsoft MSXML                         3.0 6.0 
Microsoft .NET Framework                4.0.30319.42000
Operating System                        10.0.19045
0

There are 0 answers