SQL Server Performance

Only one table could not open through EM

Discussion in 'General DBA Questions' started by whygh, Feb 26, 2007.

  1. whygh New Member

    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?

  2. MohammedU New Member

    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?

  3. satya Moderator

    What is the rowcount of that particular table?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    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.

Share This Page