One thing that I observed is sometimes while creating a database, in the master database I find a whole set of system table and sometimes they are just few tables of them that showup, in particular dbo.MSreplication_options, dbo.spt_fallback_db, dbo.spt_fallback_dev, dbo.spt_fallback_usg,dbo.spt_monitor, dbo.spt_values. Is there any setting that exists to have all of them seen.
. The first time i saw this was so terrified, then my sr.DBA said it is ok it have it like that. I am still not sure why was this happening. Now another thing, is I am actually seeing all the system views. Question is how is that we are having views and without having the physical tables in the database. I want to make sure that I am on right direction as I have to take complete ownership of an instance and I want to get my thoughts cleared.