!!! Why it said timeout expired when I open a table in SQL DB?

[Lilyli]

Hello,

We have a product DB in SQL Server. Only one table can not be opened. It said Microsoft ODBC SQL Server Driver Timeout Expired. But we can open all the other tables in this DB. What problem is for this table? How to solve it?

Thanks for any help!

 

[mrdenny]

This table is probably very large. SQL Enterprise manager has a very small timeout set within it (which can not be changed). Use Query Analyzer to view the data.

Enterprise Manager wasn't designed to be a data editor. It was designed as a managment system which can be used to view and edit small bits of data as needed.

You can try right clicking on the table select Open Table > Return Top and entering a number like 500 into the box.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[Lilyli]

Hello mrdenny,

Thanks for your help!

Have a good day!