Post reply

block data in table

  • January 19, 2009 at 1:57 am

    #72412

    i am using sql server 2000 enterprise edition, sometimes after open a table, its

    data is not visible and after fiew minutes a message occures that "exception timeout", please give me instruction to solve the problem

    thanks

    shohan

  • January 19, 2009 at 4:25 am

    #929090

    Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.

    Can you explain more what you're trying to do? Is the table large? Is there any blocking?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 19, 2009 at 6:44 am

    #929186

    I don't have 2000 installed currently, but you can change the timeout settings in Tools -> Options.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • January 19, 2009 at 7:27 pm

    #929452

    If someone else is doing the same thing and are in the process of modifying data, there may be an open transaction that is locking the table and no timeout in the world will be enough.

    --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)

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply