ASE : Database Creation

/* create a 1 gig database, with a 50 mb transaction log */
/* for load clause allows quick creation when dump is available */

1> create database
2> dbname
3> on device18 = 1000
4> log on device8 = 50
5> for load
6> go
CREATE DATABASE: allocating 512000 pages on disk 'device18'
CREATE DATABASE: allocating 25600 pages on disk 'device8'


/* change the database owner */

use dbname
go
1> sp_changedbowner 'jmith'
2> go


/* set up automatic log truncate, for development mode */

use master
go
sp_dboption 'dbname','trunc log on chkpt',true
go