__________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.