Re: How to View Result Data with SQL Profiler?

From: David Gugick (davidg-nospam_at_imceda.com)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 00:03:41 -0400

da wrote:
> Is it possible to see the result set data returned by a query in SQL
> Profiler?
>
> I can see the TSQL inside by Stored Procs listed in my trace, but I
> can't find a way to see the result data that is returned. How is
> this done?
>
> Thanks,
>
> -- da

No, you can't see the actual data returned as far as I know. Is there a
reason you are looking to see what data was queried? 

-- 
David Gugick
Imceda Software
www.imceda.com

Relevant Pages

  • 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: 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: Prepared TADOQuery Question
    ... I have the prepared property set to true, but when using the MS SQL ... The profiler results don't change when I open/close the query. ...
    (borland.public.delphi.database.ado)
  • Re: SELECT MAX(...) performance in SQL Server/ODBC
    ... I tried the Profiler and compared the results and execution plans in the two ... executing the query from C++ code by calling SQLExecDirect. ... > Have you tried using SQL Profiler to profile the events on the server? ...
    (microsoft.public.data.odbc)
  • 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 ... where the actual query is displayed in non-wrapped format. ...
    (microsoft.public.sqlserver.tools)