Hi All, Through EM, Only one TABLE in database could not open. Other tables in same database have no this problem. When I right click the table, It get stuck there. By Query Anayzer, I can do query on this table. I used DBCC CheckDB,DBCC CHECKCATALOG,DBCC DBREINDEX,DBCC CHECKFILEGROUP(1),DBCC CHECKTABLE, no any error. So I use "Select * into *** from &&&" to recreate a new table, It can get open through EM. Does anyone know the reason? Thanks
Run the profiler and see what it is doing when you are opening the table in EM... And check if there is any blockings using "exec sp-who2 active" No errors in sql error logs too? MohammedU. Moderator SQL-Server-Performance.com
What is the rowcount of that particular table? Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
