= Creating Student Databases Script in SQL =

{{{#!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. Yes, you can put the last three lines on one line when using excel.