CREATE DATABASE TEKNISA
GO

SP_ADDLOGIN 'TEKNISA','TECNISA','TEKNISA','BRAZILIAN'
GO

USE TEKNISA
GO

SP_ADDUSER 'TEKNISA'
GO

SP_ADDROLEMEMBER 'DB_OWNER','TEKNISA'
GO 

SP_ADDROLEMEMBER 'DB_DATAREADER','TEKNISA'
GO 

SP_ADDROLEMEMBER 'DB_DATAWRITER','TEKNISA'
GO 

SP_ADDROLEMEMBER 'DB_ACCESSADMIN','TEKNISA'
GO 

SP_ADDROLEMEMBER 'DB_SECURITYADMIN','TEKNISA'
GO 

SP_ADDROLEMEMBER 'DB_DDLADMIN','TEKNISA'
GO 

SP_ADDROLEMEMBER 'DB_BACKUPOPERATOR','TEKNISA'
GO 

SP_PASSWORD NULL,'SA','SA'
GO

EXIT