Simple sql-server creation script

Create db, login and user....

--drop database mydb;
--drop user myuser;
--drop login myuser;
CREATE DATABASE mydb
GO
ALTER DATABASE mydb MODIFY FILE
( NAME : N'mydb' , SIZE : 102400KB , MAXSIZE : UNLIMITED, FILEGROWTH : 102400KB )
GO
ALTER DATABASE mydb MODIFY FILE
( NAME : N'mydb_log' , SIZE : 1024KB , MAXSIZE : UNLIMITED , FILEGROWTH : 10%)
GO
USE mydb
CREATE LOGIN myuser
WITH PASSWORD    : N'xxxxxxxxx',
CHECK_POLICY     : OFF,
CHECK_EXPIRATION : OFF;
GO
CREATE USER myuser FROM LOGIN myuser;
exec sp_addrolemember 'db_owner', 'mydb';
GO