Sysprotectssyscommentssysreferencessysfilegroups Sysmemberssysfulltextcatalogssysforeignkeyssysfiles1 USERS & PERMISSIONS OBJECTS REFERENTIAL INTEGRITY STORAGE The following are the system tables present in MODEL and all databases: >Setting of database configuration options etc. >Inclusion of users who have permissions on all the databases. >Inclusion of user-defined datatypes, constraints, rules or defaults etc. Some of the common operations performed in the model database are: If you want to perform some common operations on all user databases then you can include those objects such as tables, procedures etc so that the new database also contains them. 0.75 MB so that the objects in the model database are copied onto the new database. Create database statement then SQL allocates this database the default size of model d/b i.e. For example if you create a new database without specifying any size i.e. whenever you create a new database the database objects present in this database get copied onto the new database. This database acts as a template for the new databases i.e. More information about these tables can be found in BOL. Sysremoteloginssyslockinfosyscursortables REMOTE SERVICES ACTIVE USER PROCESSES CURSORS The system tables in MASTER database can be categorized as follows: So it.s always preferable to have a recent backup of this database. If this database is corrupted then you can use the utility rebuildm.exe to rebuild the master database and then restore the other user databases accordingly. It also records the existence of other databases and the location of the primary files that contain the initialization information for the user databases. This database stores all critical information such as server specific configuration information, user login accounts, running processes, system error messages, system stored procedures etc. The four system databases that play a vital role in the successful operation of SQL Server are Master, Model, Msdb and Tempdb database. When you install SQL Server 7.0, the setup program automatically creates four system databases along with two sample user-defined databases i.e.
0 Comments
Leave a Reply. |