Miscellaneous Statements:

In this post we will discuss the miscellaneous statements or DBCC statements, their functions, and the permissions required to run them are as follows:

  • DBCC dllname (FREE) Unloads a specific extended stored procedure DLL from memory. The user must be a member of the sysadmin fixed server role or the db_owner fixed database role.
  • DBCC FREESESSIONCACHE Flushes the distributed query connection cache. The user must be a member of the sysadmin fixed server role.
  • DBCC FREESYSTEMCACHE Flushes all unused cache entries from all caches. Access requires the ALTER SERVER STATE permission.
  • DBCC HELP Provides information on a specific DBCC command. The user must be a  member of the sysadmin fixed server role.
  • DBCC TRACEOFF Disables specific trace flags. The user must be a member of the sysadmin fixed server role.
  • DBCC TRACEON Enables specific trace flags. The user must be a member of the sysadmin fixed server role.