Commands for creating and managing user databases

create database...on dev_name

or

alter database...on dev_name

Makes database devices available to a particular Adaptive Server database.

When used without the on dev_name clause, these commands allocate space from the default pool of database devices.

dbcc checktable(syslogs)

Reports the size of the log.

sp_logdevice

Specifies a device that will store the log when the current log device becomes full.

sp_helpdb

Reports information about a database’s size and devices.

sp_spaceused

Reports a summary of the amount of storage space used by a database.