RE: SP WITH RECOMPILE option

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

Date: Tue, 2 Nov 2004 09:04:02 -0800

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
    ... 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)
  • Re: SQL tuning
    ... without DDL or sample data to go on). ... The expression in your WHERE clause all preclude the use of an index: ... ClientId is used in a function; ... For further advice, post at least DDL (create table statments, including ...
    (microsoft.public.sqlserver.programming)
  • Re: Access Crashes with CONTAINS in ServerFilter
    ... DDL in SQL ... > information about HowTo provide DDL and sample data) and ADP files. ... > Microsoft Developer Community Support ...
    (microsoft.public.access.formscoding)
  • Re: Help with Update Query
    ... May I ask why this is ALTER ... As for the Update statement in the stored procedure, ... load the tables with sample data, in addition to all the Transact-SQL ... DDL, INSERTS, and T-SQL here and I'll take a look at it. ...
    (microsoft.public.access.queries)
  • Re: The column prefix does not match with a table name or alias Er
    ... Please provide DDL and sample data. ... If the primary key of table Agent is column Agent then try: ...
    (microsoft.public.sqlserver.programming)