sp_tran_dumpable_status

If you cannot make a transaction dump on a database, sp_tran_dumpable_status displays the reasons the dump is not possible.

Syntax

sp_tran_dumpable_status [database_name]

Parameters

Examples

Usage

This system procedure simply calls the tran_dumpable_status built-in function.

Permissions

Any user can execute tran_dumpable_status. Permission checks do not differ based on the granular permissions settings.