Re: Stored Procedures Data view webparts

Sweet thanks mate. Turned out to be the user permissions we could see
and diagnose with SQL profiler.


Got another issue though i cannot filter the contents? anybody else
have these problems with stored procedures and filtering the data.
When i do attempt to i break the stored proc and just get the generic
error message.

On May 31, 10:08 am, Tony Hughes <tony.john.hug...@xxxxxxxxx> wrote:
Umm the main thing though is with designer it will not even add to the
page just comes up with an error automatically in the left had side
where it attempts to display the table and data structure. will try
profiler whilst doing this.

On May 31, 12:12 am, "JD" <ya...@xxxxxxxxxxxxxxxx> wrote:

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.hug...@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: Invalid Buffer 17805
    ... SQL:StmtStarting from the T-SQL event classes ... SP:Starting and SP:StmtStarting from the Stored Procedures ... least SQLAgent% in the same not like application filter. ... >I want to create a SQL Profiler trace that will help me to identify ...
    (microsoft.public.sqlserver.clients)
  • Re: access 2007 really slow
    ... Sorry about the vagueness comment about the SQL Profiler (again new to SQL ... compared to the administrator profile. ... I also made sure all references to the tables have a prefix of dbo (w/i ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Logging
    ... > Can you explain a little more what you mean about TextData Column ... You'll need to read up on Profiler in BOL. ... columns of data you can capture from a trace. ... Add a filter for the users on the LoginName (make sure the filter works ...
    (microsoft.public.sqlserver.server)
  • run Profiler on a specific SP/Query/Function
    ... run Profiler on a specific SP/Query/Function ... What are the solutions with this version of SQL Server to avoid this? ... that's a quite a nuisance when you set up a filter for a column ...
    (microsoft.public.sqlserver.tools)
  • Re: Object Access?
    ... SQL Server does not track this info. ... run Profiler to see what is going on. ... > they are also referenced in quite a few stored procedures and do actually ... > still redundant or obsolete. ...
    (microsoft.public.sqlserver.programming)