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.
I wouldn't sweat it. The real system tables on 2005 and 2008 servers are hidden behind several layers. So it's not a surprise that you're not seeing them listed. Even if you do see them listed, what you're seeing are not really system tables anyway, they're special views that are functioning like the system tables used to in 2000.
answered Apr 29, 2010 at 11:50 AM
Grant Fritchey ♦♦