1.	USE master
2.	GO
3.	IF EXISTS (SELECT * FROM   master.sysdatabases WHERE  name =
4.	'UserAcc')
5.	  DROP DATABASE UserAcc
6.	GO
7.	CREATE DATABASE UserAcc
8.	GO
9.	USE UserAcc
10.	GO
11.	CREATE TABLE [Users] (
12.	  [UserName] [varchar] (20) NOT NULL ,
13.	  [PasswordHash] [varchar] (40) NOT NULL ,
14.	  CONSTRAINT [PK_Users] PRIMARY KEY  CLUSTERED
15.	  (
16.	    [UserName]
17.	  )  ON [PRIMARY] 
18.	) ON [PRIMARY]
19.	GO
20.	CREATE PROCEDURE RegisterUser
21.	@userName varchar(25),
22.	@passwordHash varchar(30)
23.	AS
24.	INSERT INTO Users VALUES(@userName, @passwordHash)
25.	GO
26.	CREATE PROCEDURE LookupUser
27.	@userName varchar(25)
28.	AS
29.	SELECT PasswordHash 
30.	FROM Users
31.	WHERE UserName = @userName
32.	GO
33.	exec sp_grantlogin [Computer Name\ASPNET]
34.	exec sp_grantdbaccess [Computer Name\ASPNET]
35.	grant execute on LookupUser to [Computer Name\ASPNET]
36.	grant execute on RegisterUser to [Computer Name\ASPNET]