Opening Table in Enterprise Manager, Cause Timeout

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Opening Table in Enterprise Manager, Cause Timeout

Author

Topic

cdanczak
Starting Member

2 Posts

Posted - 2002-12-18 : 12:49:23

I am running SQL Server 7.0.

Everytime I open my main table (tblOrder) in Enterprise Manager, our data entry people experience a timeout when trying to insert a new record to the table. But as soon as I close the table in EM, the timeout problem disappears.

This problem only began happenning about 3 days ago, and for the life of me, I don't recall altering a single thing administative... anything is possible though.

The table really isn't all that big, roughly 70,000 records.
I realize, the dangers of opening production tables, but here it is a necessary evil in some instances.

To elaborate a little...
I just ran a test where I opened a different table (tblClients) in EM in the same database, and had our data entry people create a new record for that table... no timeout problem.
The timeout problem only occurs when the one specific table (tblOrder) is opened.

Any help would be greatly appreciated. Thank you.

nr
SQLTeam MVY

12543 Posts

Posted - 2002-12-18 : 13:08:11

Easy answer is don't open tables in enterprise manager.

If you are just looking at the data then I would do it in query analyser and always run
set transaction isolation level read uncommitted
first.
This should stop you affecting the production system but may not give correct results.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.