Create Database GetStarted

On Primary

(NAME = 'GetStartedDB_dat',

Filename ='C:\Documents and Settings\admin\My Documents\SQL Server Management Studio\Projects\getstarteddb.mdf',

SIZE = 5MB,

MaxSize=25MB,

FILEGrowth= 10%)

LOG ON

(NAME='GetStartedDB_log',

FILENAME = 'C:\Documents and Settings\admin\My Documents\SQL Server Management Studio\Projects\getstarteddb.ldf',

SIZE = 5MB,

MaxSize=25MB,

FILEGrowth= 10%)

Create Schema newdbs

Create Table EmployeeSummary

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

EmployeeFirstName varchar(50),

EmployeeLastName varchar(50),

EmployeeBirthDate smalldatetime,

EmployeeNumberofChildren int,

EmployeeBankBalance Money)

CREATE LOGIN LetMeStart

WITH PASSWORD = 'weneedtologinnow'

USE Getstarted

CREATE USER Geton FOR LOGIN Letmestart

WITH DEFAULT_SCHEMA = newdbs

go

GRANT Select, INSert, Update On Schema::newdbs TO Geton

GO