ASE : Create second tempdb

steps to follow for creating second tempdb on sybase server

- create data and log devices using disk init
- turn off dsync on both devices

sp_deviceattr tempdb_report_data, dsync, false
go

sp_deviceattr tempdb_report_log, dsync, false
go

- create second tempdb
create temporary database tempdb_report
on tempdb_report_data = 2000
log on tempdb_report_log = 500
go

- make the second tempdb the first user db to be recovered.

sp_dbrecovery_order tempdb_report, 1
go

sp_tempdb 'bind', 'lg', loginname, 'db', 'tempdb_report'
go