How to create a new database in SQL Server
Right click on databases, and click 'New Database...'
Enter 'sa' as owner (or whatever owner)
Hit OK
Create a new query for the database and add yourself as a user
EXEC sp_grantdbaccess 'YOUR\LOGIN'
In the main security node, open the properties for your login, select 'User Mapping' and change the default schema to dbo.
Right click on databases, and click 'New Database...'
Enter 'sa' as owner (or whatever owner)
Hit OK
Create a new query for the database and add yourself as a user
EXEC sp_grantdbaccess 'YOUR\LOGIN'
In the main security node, open the properties for your login, select 'User Mapping' and change the default schema to dbo.
Created By: amos 7/14/2015 10:07:55 AM
Updated: 7/14/2015 10:07:55 AM
|
|