Re: SP WITH RECOMPILE option

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 10:17:07 -0800

Then post the sp code, tables ddl being referenced by the sp. The information
given in your first post is not enough to have an idea of what could be
causing the problem.

AMB

"Ayad" wrote:

> There is no DDL in the SP , it is a Select statement joining a group of
> tables with a sub-query (another Select statement).
>
> Ayad
>
>
> "Alejandro Mesa" <AlejandroMesa@discussions.microsoft.com> wrote in message
> news:36869CBA-72C8-423D-8BFB-E50DD498C795@microsoft.com...
> > How can we know if you did not provide any DDL, sample data, etc.?
> >
> > Please provide DDL and sample data.
> > http://www.aspfaq.com/etiquette.asp?id=5006
> >
> >
> >
> > AMB
> >
> > "Ayad" wrote:
> >
> > > I have a web application with a back end SQL server db. Every time the
> users
> > > login to the web site, they execute a SP.
> > >
> > > The issue is that the user is getting a time-out error message when they
> > > call the SP. If I add the WITH RECOMPILE option to the SP, they don't
> get
> > > the time-out error but on the SQL server it cause a COMPILE x lock on
> the SP
> > > and slow down the application but they get in.
> > >
> > > Why if I remove the WITH RECOMPILE option, the user will get a time-out
> > > error?
> > >
> > > Thanks
> > >
> > > Ayad
> > >
> > >
> > >
>
>
>

Relevant Pages

  • RE: SP WITH RECOMPILE option
    ... Please provide DDL and sample data. ... "Ayad" wrote: ... > the time-out error but on the SQL server it cause a COMPILE x lock on the SP ...
    (microsoft.public.sqlserver.programming)
  • Re: Table Design Question
    ... First post some specs, sample data and DDL. ... non-DDL that you posted looks wrong -- why is a product_id and a product ...
    (microsoft.public.sqlserver.programming)
  • Re: Combo Box RowSource Problem
    ... same problem as I said in my first post, ... the lsit clicked on is, for example, Medtronic PacerX, I get Medtronic PacerY ... Post the DDL for the tables if you ... Bob Hairgrove ...
    (microsoft.public.access.formscoding)
  • Re: cannot drop index....it is being used for Foreign Key Enforcement ???
    ... the ddl is in my first post. ... I wish there was something else I could give you, I'd do it in a heartbeat. ... Thanks for the feedback up to now anyway ...
    (microsoft.public.sqlserver.server)
  • Re: Cursor problem
    ... I posted the stored procedure in a reply to my first post. ... I am under a NDA and can not post the DDL and data. ...
    (microsoft.public.sqlserver.programming)