Database Options

Enabled Options

select into/bulkcopy/pllsort

Placement

Device Name	Size	Usage
data_dev5	10	data only
log_dev1	1	log only
log_dev1	1	log only
log_dev1	1	log only
log_dev1	1	log only

Database Usage

Data	5.12 (51.17 %)
Indexes	2.81 (28.14 %)
Unused	1.73 (17.34 %)
Unreserved	0.33 (3.34 %)

Log Usage

Log Used	1.54 (38.53 %)
Log Unused	2.46 (61.47 %)

DDL

USE master
go
CREATE DATABASE publications
    ON data_dev5=10
    LOG ON log_dev1=1,       
    log_dev1=1,       
    log_dev1=1,       
    log_dev1=1
go
USE master
go
EXEC sp_dboption 'publications','select into/bulkcopy/pllsort',true
go
USE publications
go
CHECKPOINT
go
USE publications
go
EXEC sp_changedbowner 'isopma'
go
EXEC sp_addsegment 'default','publications','data_dev5'
go
EXEC sp_addthreshold 'publications','default',150,'sp_lastchancethreshold'
go
EXEC sp_addsegment 'logsegment','publications','log_dev1'
go
EXEC sp_addthreshold 'publications','logsegment',136,'sp_thresholdaction'
go
EXEC sp_addthreshold 'publications','logsegment',800,'sp_lastchancethreshold'
go
EXEC sp_addsegment 'system','publications','data_dev5'
go