USE [#DBNAME#]
GO
/****** Object:  Login [aisadmin]    Script Date: 11/13/2007 15:24:12 ******/
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'aisadmin')
CREATE LOGIN [aisadmin] WITH PASSWORD=N'aisPW2007', DEFAULT_DATABASE=[#DBNAME#], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [aisadmin] ENABLE
GO
/****** Object:  User [aisadmin]    Script Date: 11/13/2007 16:58:20 ******/
CREATE USER [aisadmin] FOR LOGIN [aisadmin] WITH DEFAULT_SCHEMA=[dbo]
GO
EXEC sp_addrolemember [db_owner], [aisadmin]
GO
