__________create the removable database. A. sp_certify_removable

create-the-removable-database-a-sp-certify-removable

__________create the removable database.

A. sp_certify_removable

B. sp_certify

C. sp_removable

D. all of the mentioned

I got this question in final exam.

My query is from Stored Procedure in chapter Developing with SQL Server of SQL Server

Right answer is A. sp_certify_removable

To elaborate: You can’t use CREATE DATABASE or Enterprise Manager to create the removable database. You’ll need to run sp_create_removable with sysadmin privileges.