Re: Stored Procedures Data view webparts

The only way I have found to get any type of trace is to use SQL Profiler.
It will give you a trace of all of the SQL executing on a given server.
Start a profiler session against the server where you are running the SP and
hit the page with the web part and you should see it execute and the
parameters being passed to it.

"Tony Hughes" <tony.john.hughes@xxxxxxxxx> wrote in message
news:4fad5198-92b9-4e26-90d5-4305c3c9b407@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Guys,

I've had a stored procedure created that works in the following way
User log's into SP>using the (LOGIN_USER) parameter the user's id
passed to stored procedure>stored procedure looks up user's group
memberships uses these to grab the appropriate data for the user.


Have tested the procedures themselves they seem ok having issues with
what looks like the sub stored procedures.

Having the following issues basically i get a generic error message
when i try to drag the connection in using the (LOGIN_USER) parameter
wondering if anyone knows how to turn on full logging to actually see
an error message.

The above is the main method of how i am securing front end client
data.


.

Relevant Pages

  • Re: SQL Debugging
    ... You can run a trace using Sql Profiler. ... - Sahil Malik ... > I am able to run a stored procedure with no parameters, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Capturing stored procedures parameters
    ... This can easily be done using SQL Profiler. ... Just establish a new trace ... using one of the SQLProfilerTSQL_xxxx templates. ... > parameters passed to a stored procedure? ...
    (microsoft.public.sqlserver.tools)
  • SqlDataAdapter.Fill returns results of previous command
    ... This code executes successfully at certain points in the application, ... I don't know what the cause of this exception is yet, ... stored procedure was indeed executed on the database. ... The trace shows that the last action on the db was the stored ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Getting Recent Search Terms
    ... I can't get your trace to work. ... > the SQL Profiler GUI in production environments. ... This script or any other profiler server-side script can be ... > "Hilary Cotter" wrote in message ...
    (microsoft.public.sqlserver.fulltext)
  • Re: ConnectionRead Timeout Problem
    ... > Bei Zhu ... I have also looked at SQL Profiler in order to see if there ... As I said stored procedure is executed around 20 times with no ... >> then on the next execution we get the exception on SQL Profiler it is ...
    (microsoft.public.data.ado)