SP WITH RECOMPILE option

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

Date: Tue, 2 Nov 2004 11:47:47 -0500

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

  • SP WITH RECOMPILE Option
    ... I have a web application with a back end SQL server db. ... login to the web site, ... the time-out error but on the SQL server it cause a COMPILE x lock on the SP ... Why if I remove the WITH RECOMPILE option, the user will get a time-out ...
    (microsoft.public.sqlserver.server)
  • Re: SP WITH RECOMPILE option
    ... "Ayad" wrote in message ... > I have a web application with a back end SQL server db. ... If I add the WITH RECOMPILE option to the SP, ... > the time-out error but on the SQL server it cause a COMPILE x lock on the ...
    (microsoft.public.sqlserver.programming)
  • RE: Management Point not available
    ... > configured the Default Web Site within IIS 6 to use port 8080. ... Manually restart the SMS Agent Host service on the MP. ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
  • desperately needing help with a Server Error
    ... i know NOTHING about sql server, .net framework or probably anything ... this is NOT a problem with the web site. ... i tripped on to this board from access monster and thought it ... *** i posed this on sql server monster as well, not knowing if here or there ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL Connection String using Domain Account
    ... Web.Config but now have the problem that the web site will not run under ... you can have a username/password set up in sql server - but this would ... The DBA has given me a Domain user account with rights to ... I am unable to get a connection to the database. ...
    (microsoft.public.dotnet.languages.csharp)
Loading