Home Forums SQL Server 2008 SQL Server 2008 - General view time out RE: view time out

  • September 20, 2017 at 10:26 am

    #1960202

    tomashons - Tuesday, September 19, 2017 9:55 AM

    Hello there is solution:

    Run -> regedit -> Computer\HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0(or 14.0 depends on version of SSMS)\DataProject\SQLQueryTimeout

    Change Value 30 to 300

    Problem solved.

    I'm thinking that's putting a band-aid on a stab-wound.  Having things timeout is an important clue in the detection of really bad code.  Making registry changes to accommodate such things is also not what I'd consider a best practice, either.  The real problem is the code... not some settings.  Until you fix the code, the problem is not solved.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)