Re: Stored Procedures Data view webparts

Hmm... I just tried filtering on one of my DVWP's that uses a stored proc
and it doesn't work - I don't get any errors, it just continues to display
all of the data. I guess I never tried it before.

I think I know what the problem is, but I need to take a closer look at it.
If I find something, I will reply to this thread - but it may not be for a
day or two.

"Tony Hughes" <tony.john.hughes@xxxxxxxxx> wrote in message
news:342be14c-7648-4dfc-89d0-e532a6fe8b3e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: Comparision between Datatables Select method and stored procedure
    ... rather than in the database. ... my guess would be that filtering rows on ... DataTable will most likely outperform the stored procedures. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Off Topic - Access to Postgres
    ... >> and stored procedures is not usually the best answer, and may not help at all. ... My novice understanding of a database like Postgres is that we ... a query may fail to optimize well and pass the SQL ... filtering, and does not cause the filtering to be done by the server as query ...
    (comp.databases.ms-access)
  • Re: Quantify the impact of SQL profiler in SQL perfromane
    ... If you only trace stored procedures and batches, ... filtering, then impact will be low, maybe a few percent. ... Profiler has %10 negative impact while running on sql server ...
    (microsoft.public.sqlserver.programming)
  • Its so nice to have a profiler
    ... Ian - not seen you around much - but wanted to thank you for the Profiler! ... I've not had to use it before - but today I added 1000 records to my app and it dragged to a crawl - "Damn it must be that category filtering code I just ... Profiler profiler: [myModel recaclulateFilter; expandTree] inSetNamed: 'Filtering' ... At some point we should put together a zip file with all the best packages and an install script that loads them up to create a "Developer Image". ...
    (comp.lang.smalltalk.dolphin)
  • Re: Feature Request: 2005 Beta 2
    ... I have no clue what they can do for me. ... > Hi Shawn, ... >> can create categories to group my stored procedures. ... >> Not sure if you've considered this already but the filtering isn't as ...
    (microsoft.public.sqlserver.tools)