db_attr

Returns the durability, dml_logging, and template settings, and compression level for the specified database.

Syntax

db_attr('database_name' | database_ID | NULL, 'attribute')

Parameters

Examples

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute db_attr.