Configuration Statements for Custom DDL Scripts

Add these missing configuration statements to DDL generated from the data model.

These edits modify the tempdb and model database size, change the database settings, and bind the cache to memory.

Add the following statements immediately after the file header and before the first domain statement that begins on line 7.
use master
go
alter database tempdb on master=100
go
alter database model on master=100
go
use model
go
sp_logiosize '16K'
go
exec sp_addsegment s1 , model, master
exec sp_addsegment s2 , model, master
exec sp_addsegment s3 , model, master
exec sp_addsegment o1 , model, master
go


Created March 26, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com