Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't create database
Message
From
02/02/1999 13:47:26
 
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00182199
Message ID:
00183076
Views:
31
>>Might have been better then to have SQL Server to default to the Master database whenever we create a new database. :)
>
>You would still have to be in the master database context to issue the command. The permission to execute CREATE DATABASE is stored in Master's sysprotects. SQL Server can't automatically change you database context, you may not have permission to change you database context to master.

OIC

I guess this naming convention or way of doing things in SQL Server might be a little bit confusing. I mean, all the settings we need to have shouldn't be part of a database or at least not one appearing among the list of other databases.
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
Previous
Reply
Map
View

Click here to load this message in the networking platform