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