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
|
|