Post reply

sysobjects

  • November 11, 2002 at 10:50 am

    #64614

    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?

  • November 11, 2002 at 11:07 am

    #440969

    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.

  • November 11, 2002 at 11:22 am

    #440972

    Thanks, I think that you are correct.

  • November 12, 2002 at 8:29 am

    #441126

    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