Re: SP WITH RECOMPILE option

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ayad (ashammout1_at_hotmail.com)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 12:23:26 -0500

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: creating tables with VBA
    ... I do agree on google, but you need to know what your looking for. ... Ron W ... Is there a web site where I can find moreSQL ddl ...
    (microsoft.public.access.formscoding)
  • Re: creating tables with VBA
    ... I do not believe that Access DDL supports default values. ... ALTER Table MyTable ALTER COLUMN mydate CONSTRAINT AddDateDflt DEFAULT ... Ron W ... Is there a web site where I can find moreSQL ddl ...
    (microsoft.public.access.formscoding)
  • Re: SP WITH RECOMPILE option
    ... tables ddl being referenced by the sp. ... given in your first post is not enough to have an idea of what could be ... "Ayad" wrote: ... >> Please provide DDL and sample data. ...
    (microsoft.public.sqlserver.programming)