exec master..dbd_list_profiles

Lists existing profiles. Active profile marked with *.

It shows that there are 3 profiles on the server and the profile named p3 is active. It will be applied for new databases created with CREATE DATABASE.

A DBA can unset (deactivate) a profile with dbd_set_profile.

It is not possible for an unprivileged login to unset a profile.

Related functions

master..dbd_create_profile - Creates and stores a profile

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

master..dbd_del_profile - Deletes a profile