| System tables are the groups of table that helps sql | | | | 4) The MSDB contains information regarding backup |
| server to track the information regarding users, | | | | and restore information. |
| databases, tables, replications tasks and so many | | | | 5) The master database contains a set of tables that |
| task and also helps in sql query just like insert query, | | | | hold name of publishing and subscribing servers. |
| delete sql query, update sql query,. All information | | | | 6) The distribution database contains information on |
| regarding database that is knows by sql server are in | | | | replication schedules and transactions. |
| system tables. These system tables are break down | | | | 7) The databases that participate in replication |
| into server groups. | | | | objects with in those databases. |
| 1) The master databases contain information | | | | There are almost 100 of system tables and some |
| regarding databases, logins, server and some system | | | | examples of queries are here: |
| wide information. | | | | Sql Server 2000 query on systems tables: |
| 2) Each data base contains some table which holds | | | | 1) To get name of primary files from system table |
| information on objects, indexes, columns and some | | | | database |
| database information. | | | | Selectname, filename from sysdatabases |
| 3) The MSDB database contains a set of tables that | | | | 2) How t get name of all files used by database with |
| used by SQL SERVER Agent which store information | | | | the help of Sql Server 2000 queries |
| on alerts, jobs and others items that manages by | | | | Select name, filename from sysfiles. |
| agents. | | | | |