Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2018-01-25 20:01:15 →
Size: 286
Editor: scot
Comment:
← Revision 2 as of 2018-01-25 20:24:25 → ⇥
Size: 393
Editor: scot
Comment:
Deletions are marked like this. Additions are marked like this.
Line 8: Line 8:

Above is the T-SQL needed to add a database. We'll create the scripts based on the usernames in Excel.

Creating Student Databases Script in SQL

CREATE DATABASE DELETEME; 
GO 
USE DELETEME; CREATE LOGIN DELETEME WITH PASSWORD='HelloJunkBonds123'; CREATE USER DELETEME FOR LOGIN DELETEME WITH DEFAULT_SCHEMA=[db_owner]; EXEC sp_addrolemember 'db_owner', 'DELETEME';

Above is the T-SQL needed to add a database. We'll create the scripts based on the usernames in Excel.

DatabaseManagementSystems/CreateStudentDatabasesSql (last edited 2020-02-05 13:32:04 by scot)