why be normal?
Welcome to Sign in | Help
in Search

Timeout deploying assembly to SQL Server 2005

Last post 04-27-2009, 6:36 by Anonymous. 1 replies.
Sort Posts: Previous Next
  •  12-28-2006, 8:36 1430

    Timeout deploying assembly to SQL Server 2005

    Developers who begin to bloat the size of their assemblies destined for CLR-enabled SQL Server instances may be hit with the following timeout problem when attempting to deploy from Visual Studio to a remote server:

    Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

    This happens when SQL Server cannot complete the first statement to drop the old assembly (a very lengthy statement) within the 30 seconds Visual Studio gives it with LOCK_TIMEOUT. Run a Profiler trace on the server when the deployment takes place to witness this. What I could not easily find was how to adjust this timeout tolerance; it certainly does not exist in the database project's Database or Deploy sections, or any other for the matter.

    And here is a case when one has to step out of the "Google/MSN comfort zone" and manually search forum boards that search engines have not crawled well. One MSDN Forums thread talks of this very issue and the place to get Visual Studio to give some slack:

    From the menu Tools > Options...

    Expand Database Tools > Query and View Designers

    for Cancel long running query, either uncheck it, or set Cancel after to a longer period.

    Filed under: ,
  •  04-27-2009, 6:36 5639 in reply to 1430

    Re: Timeout deploying assembly to SQL Server 2005

    Thanks a lot!

    The same tip goes for VS2008 + SQL Server 2008.

View as RSS news feed in XML
Powered by Community Server, by Telligent Systems