查询database所在的空间位置和日志模式

SELECT trim(name) dbname,trim(owner) owner, created||' T'  created_time,

TRIM(DBINFO('dbspace',partnum)) AS dbspace,

CASE WHEN is_logging+is_buff_log=1 THEN "Unbuffered logging"

    WHEN is_logging+is_buff_log=2 THEN "Buffered logging"

    WHEN is_logging+is_buff_log=0 THEN "No logging"

ELSE "" END Logging_mode

FROM sysdatabases

where trim(name) not like 'sys%';