sysobjects

  • Correct me if I am wrong: the sysobjects table in the master Database is supposed to have information on all of the tables in the server correct?

  • I Don't think so,it will have the objects of the Master database only.For all the Individual databases it will be in sysobjects under that database.

  • Thanks, I think that you are correct.

  • This is a confirmation of what Mkumari has said. The sysobjects system table exists in every database. It only contains the objects for the database it is in. This is true of any database system table like syspermissions, sysprotects, syscolumns, sysindexes, etc.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply