Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Location
    Buenos Aires
    Posts
    1

    Exclamation Unanswered: cannot list tables or other objects

    Sometimes, when a try to list tables or view (or access Management, etc) Enterprise Manager hungs up.
    Using SELECT * FROM SYSOBECTS also freezes the process. But the SQLServer is operational for data updates and retrieves.

    Anyone?

    thanx!

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    SYSOBJECTS along with SYSINDEXES, SYSPROTECTS, SYSDEPENDS, SYSCOLUMNS, and SYSCOMMENTS are the most frequently used system objects in every user database. You should ALWAYS use (NOLOCK) when attempting to directly retrieve data from those tables.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Aug 2004
    Posts
    1
    You might also want to use the information_schema views rather than looking up directly in the tables. They're more typing but if this is part of a script/procedure having a lifetime that might span generations of SQL Server, this is safer. The system tables can change; the views will be kept stable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •