November 11, 2002 at 10:50 am
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
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
Thanks, I think that you are correct.
November 12, 2002 at 8:29 am
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