Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't create database
Message
From
02/02/1999 08:34:59
 
 
To
01/02/1999 10:19:31
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00182199
Message ID:
00182887
Views:
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.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform