Re: View Results With SQL Profiler?

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 00:04:37 -0400

There is no way to do that with profiler that I know of. You can use
network monitors to see what is returned over the network. 

-- 
Andrew J. Kelly  SQL MVP
"da" <da@hotmail.com> wrote in message 
news:%23APx0HNsEHA.2612@TK2MSFTNGP10.phx.gbl...
> 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
>
>

Relevant Pages

  • Re: View Results With SQL Profiler?
    ... > There is no way to do that with profiler that I know of. ... > network monitors to see what is returned over the network. ... > Andrew J. Kelly SQL MVP ... if you're app is utilizing certain TSQL constructs by matching returned data ...
    (microsoft.public.sqlserver.tools)
  • Re: adding field descriptions
    ... In EM click on the menu for "Tools" and then select "Profiler". ... when the trace properties dialog appears go to the "Events" tab. ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clients)
  • Re: Monitoring Impact of a User in SQL Server
    ... At least it will be read only but they can still issue any queries they want. ... Profiler or Trace will allow you to see what each connection is doing. ... Andrew J. Kelly SQL MVP ... I didnt actually realise SQL Server had ...
    (microsoft.public.sqlserver.tools)
  • Re: Profiler temp file
    ... Well you really shouldn't be using profiler for such things anyway. ... efficient way to do this is to create a trace and send the trace events ... second and then stop it you can go to File - Script trace to generate an ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Weird parallel stored procedures execution problem
    ... Have you run profiler with errors and assertions events turned on? ... Are they just blocked or hung, ... Andrew J. Kelly SQL MVP ... are stopping suddenly without any error message. ...
    (microsoft.public.sqlserver.programming)