sys.sp_certify_removable

Description

Verifies that a database is correctly configured for distribution on removable media and reports Specifies the database to be verified. Gives ownership of the database and all database objects to the system administrator, and drops any user-created database users and nondefault permissions. This feature will be removed in a future version of SQL Server.

Syntax

sp_certify_removable
[ @dbname = ]
N
'dbname'
[ , [ @autofix = ]
N
'autofix'
]
[ ; ]