database
<p>Create db, login and user....</p>
<pre><code>--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 </code></pre>