Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't create database
Message
De
02/02/1999 09:18:30
 
 
À
02/02/1999 08:34:59
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
00182199
Message ID:
00182903
Vues:
13
>>However, I don't understand why we need to set the default to Master. I mean I am creating a new database. I don't see the relation to set the default database to master.
>
>SQL Server is meta-data driven. The meta-data is stored in the system databases with the majority and most important meta-data being stored in the master database. Every database contains some system tables which begin with sys. For instance, sysobjects contain one row for every object (table, view, stored procedure, etc.) in the database. The master database contains some additional system tables, one of which is sysdatabases. sysdatabases contains one row for every database on the server.

Might have been better then to have SQL Server to default to the Master database whenever we create a new database. :)
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform