query in SQL 2005 profiler in wrapped format

15 Dec 2005 10:42 PM

likong

In SQL 2005 profiler, the bottom half of each trace window displays the
actual SQL query in "wrapped" format (e.g., a single line long query is
wrapped into multiple lines), which is different from SQL 2000 profiler
where the actual query is displayed in non-wrapped format.

I would like to request to change it to be non-wrapped format in SQL
2005 profiler. The reason is that the SQL query in wrapped format may
be different from the original non-wrapped format, especially when a
nvarchar parameter is artificially wrapped into the next line (the new
nvarchar parameter has the extra \n characters embedded). Most of
times when I cut&paste the wrapped SQL query from the SQL 2005 profiler
into a query window in Management Studio, I have to manually un-wrap
the query to get the original query. On the other hand, I never has
this issue with SQL 2000 Profiler.

Thanks.

Kong

3 Jan 2006 6:05 PM

Maciek Sarnowicz [MSFT]

Thanks for reporting this. We have logged this issue in our defects database
and will look into fixing it in the next service release.

Regards,
Maciek Sarnowicz
--------------------
SQL Server SDE

This posting is provided "AS IS" with no warranties, and confers no rights

<lik***@email.com> wrote in message
Show quote

news:1134686569.346157.145680@g47g2000cwa.googlegroups.com...
>
> In SQL 2005 profiler, the bottom half of each trace window displays the
> actual SQL query in "wrapped" format (e.g., a single line long query is
> wrapped into multiple lines), which is different from SQL 2000 profiler
> where the actual query is displayed in non-wrapped format.
>
> I would like to request to change it to be non-wrapped format in SQL
> 2005 profiler. The reason is that the SQL query in wrapped format may
> be different from the original non-wrapped format, especially when a
> nvarchar parameter is artificially wrapped into the next line (the new
> nvarchar parameter has the extra \n characters embedded). Most of
> times when I cut&paste the wrapped SQL query from the SQL 2005 profiler
> into a query window in Management Studio, I have to manually un-wrap
> the query to get the original query. On the other hand, I never has
> this issue with SQL 2000 Profiler.
>
> Thanks.
>
> Kong
>