New System Tables

Microsoft® SQL Server™ includes these new system tables:

• backupfile contains one row per data or log file that was backed up.
• backupmediafamily describes each medium involved in the backup family backup set.
• backupmediaset describes the backup media set.
• backupset describes the backup set.
• MSagent_parameters contains parameters associated with an agent profile.
• MSagent_profiles contains one row for each defined replication agent profile.
• MSarticles contains one row for each article being replicated by a Publisher.
• MSdistpublishers contains one row for each remote Publisher supported by the local Distributor.
• MSdistributiondbs contains one row for each distribution database defined on the local Distributor.
• MSdistribution_agents contains one row for each Distribution Agent running at the local Distributor.
• MSdistribution_history contains history rows for the Distribution Agents associated with the local Distributor.
• MSdistributor contains the Distributor properties.
• MSlogreader_agents contains one row for each Log Reader Agent running at the local Distributor.
• MSlogreader_history contains history rows for the Log Reader Agents associated with the local Distributor.
• MSmerge_agents contains one row for each Merge Agent running at the Subscriber.
• MSmerge_contents contains one row for each row modified in the current database since it was published.
• MSmerge_delete_conflicts contains tombstone information for rows that were deleted and subsequently had the delete undone because it conflicted with an update performed at another replica.
• MSmerge_genhistory contains one row for each generation that a Subscriber knows about (within the retention period).
• MSmerge_history contains history rows for previous updates to Subscriber.
• MSmerge_replinfo contains one row for each replica made from the local server.
• MSmerge_subscriptions contains one row for each subscription serviced by the Merge Agent at the Subscriber.
• MSmerge_tombstone contains information on deleted rows and allows deletes to be propagated to other Subscribers.
• MSpublication_access contains a row for each Microsoft SQL Server login that has access to the specific publication or Publisher.
• MSpublications contains one row for each publication that is replicated by a Publisher.
• MSpublisher_databases contains one row for each Publisher/Publisher database pair serviced by the local Distributor.
• MSreplication_objects contains one row for each object that is associated with replication in the Subscriber database.
• MSreplication_subscriptions contains one row or replication information for each Distribution Agent servicing the local Subscriber database.
• MSrepl_commands contains rows of replicated commands.
• MSrepl_errors contains rows with extended replication agent failure information.
• MSrepl_originators contains one row for each updatable Subscriber from which the transaction originated.
• MSrepl_transactions contains one row for each replicated transaction.
• MSrepl_version contains one row with the current version of replication installed.
• MSsnapshot_agents contains one row for each Snapshot Agent associated with the local Distributor.
• MSsnapshot_history contains history rows for the Snapshot Agents associated with the local Distributor.
• MSsubscriber_info contains one row for each Publisher/Subscriber pair that is being pushed subscriptions from the local Distributor.
• MSsubscriber_schedule contains default merge and transactional synchronization schedules for each Publisher/Subscriber pair.
• MSsubscriptions contains one row for each subscription serviced by the local Distributor.
• MSsubscription_properties contains rows for the parameter information for pull Distribution Agents.
• restorefile contains one row per file restore.
• restorefilegroup contains one row per restored filegroup.
• restorehistory contains one row per restore operation.
• sysallocations contains one row for each allocation unit.
• sysaltfiles contains one row for each file in a database.
• sysarticleupdates contains information on the articles that are updated.
• syscacheobjects contains information on how the cache is being used.
• syscategories contains the categories used by SQL Server Enterprise Manager to organize jobs, alerts, and operators.
• sysdownloadlist holds the queue of download instructions for all target servers.
• sysfiles describes each database file.
• sysfilegroups describes each database filegroup.
• sysfulltextcatalogs lists the set of full-text catalogs.
• sysjobhistory contains information about the execution of scheduled jobs by SQL Server Enterprise Manager.
• sysjobschedules contains schedule information for jobs to be executed by SQL Server Enterprise Manager.
• sysjobs stores the information for each scheduled job to be executed by SQL Server Enterprise Manager.
• sysjobservers stores the association or relationship of a particular job with one or more target servers.
• sysjobsteps contains the information for each step in a job to be executed by SQL Server Enterprise Manager.
• syslockinfo contains information on all granted, converting, and waiting lock requests.
• sysmembers contains a row for each member of a database role.
• sysmergearticles contains one row for each merge article defined in the local database.
• sysmergepublications contains one row for each merge publication defined in the database.
• sysmergeschemachange contains information about the last schema change.
• sysmergesubscriptions contains one row for each known Subscriber and is a local table at the Publisher.
• sysmergesubsetfilters contains join filter information for partitioned articles.
• sysperfinfo contains a SQL Server representation of the internal performance counters that can be displayed through the Windows NT Performance Monitor.
• syspermissions contains information about permissions that have been granted and denied to users, groups, and roles in the database.
• sysoledbusers contains one row for each user and password mapping for the specified linked server.
• sysprocesses includes the addition of the open_tran column, which indicates how many transactions a process has.
• sysreplicationalerts contains information about the conditions that cause a replication alert to fire.
• systargetservergroupmembers records the target servers that are currently enlisted into this multiserver group.
• systargetservergroups records the target server groups that are currently enlisted into this multiserver environment.
• systargetservers records the target servers that are currently enlisted into this multiserver operation domain.
• systaskids contains a mapping of tasks created in earlier versions of SQL Server to SQL Server Enterprise Manager jobs in the current version.