Create Database GetStarted

On Primary

(NAME = 'GetStartedDB_dat',

FILENAME = 'E:\MS_DFiles\getstarteddb.ldf',

SIZE = 5MB,

MaxSize=25MB,

FILEGrowth= 10%)

LOG ON

(NAME='GetStartedDB_log',

FILENAME = 'E:\MS_Log\getstarteddb.ldf',

SIZE = 1MB,

MaxSize=5MB,

FILEGrowth= 10%)

GO

Create Schema GetStartedsch

Create Table EmployeeSummary

(EmpID int Identity(1,1) Primary Key,

EmployeeFirstName varchar(50),

EmployeeLastName varchar(50),

EmployeeBirthDate smalldatetime,

EmployeeNumberofChildren int,

EmployeeBankBalance Money)

GO

CREATE LOGIN LetMeStart

WITH PASSWORD = 'Pass007'

USE GetStarted

CREATE USER LetmestartU FOR LOGIN LetMeStart

WITH DEFAULT_SCHEMA = GetStartedsch

USE GetStarted;
GRANT CREATE TABLE,CREATE VIEW,EXECUTE, ALTER,Select,Insert, Update TO LetmestartU;
GO