exec master..dbd_del_profile @profile sysname

Deletes a profile from the server. The profile that already set for a specific login or session can't be deleted. It must be unset prior to the deletion.

Related functions

master..dbd_create_profile - Creates and stores a profile

master..dbd_list_profiles - Lists profiles

master..dbd_set_session_profile - Sets and unsets a profile for the current session

master..dbd_set_profile - Sets (activates) or unsets (deactivates) a profile