Creating a database in Sybase

Sybase is a little diffrent to mssql in that you need to create sybase on devices.

In sybase you have data devices and log devices.

to create a database use this sytax.
I useually create devices called datadev and logdev as this will distiqush the too.

I would always say to set the dbowner to sa too so you know the jobs will have all the rights to the database

USE master
go
CREATE DATABASE database
ON datadev1=1000
LOG ON logdev1=250
go
ALTER DATABASE database
ON datadev2=1000
go
ALTER DATABASE database
ON datadev2=348
go
USE database
go
EXEC sp_changedbowner 'sa'
go