Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't create database
Message
From
02/02/1999 13:38:42
 
 
To
02/02/1999 09:18:30
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00182199
Message ID:
00183068
Views:
17
>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.

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

Click here to load this message in the networking platform