block data in table

Question

block data in table

shohan_db

SSC Rookie

Points: 44
More actions
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

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

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

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

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

Jeff Moden SSC Guru Points: 1004642 More actions · Answer 3

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)