query in SQL 2005 profiler in wrapped format


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

.

Relevant Pages

  • RE: Excel & MS Query caused compile errors
    ... My data is in an Excel file called ... The format of it were distorted after copying and pasting. ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ...
    (microsoft.public.excel.programming)
  • Re: ADO.NET query execution much slower than SQL Management Studio
    ... When you first start using a new database it creates stats. ... the first few queries run slowly, as will any unique type of query, as it ... Something that would affect the .NET SqlClient but not SQL Mgmt Studio? ... compare this to the profiler command (meaning what is actually run in the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: mySQL Problem
    ... And when the query gets executed i get back the following error: ... Actually, problem is proper quoting, not the format or anything else. ... the SQL standard and won't work on any other RDBMS I'm familiar with. ... you admit that mssql uses something DIFFERENT and PARTICULAR to alias? ...
    (comp.lang.php)
  • Re: ADO.NET query execution much slower than SQL Management Studio
    ... Run the query twice from ADO.NET and see ... Stats being compiled on SQL Server ... If you are dynamically adding statements in a sproc, ... sproc versus running the sproc statement from profiler), ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VBA ADO SQL Query Problem
    ... For long queries on a Oracle DB, I often meke it easy by using Business ... Object where I copy the SQL statement from. ... query parameter in the Oracle date format. ... But the query DID work, only no records were retrieved ...
    (microsoft.public.excel.programming)
Quantcast