Home / server / Questions / 184299
Accepted
atricapilla
Asked: 2010-09-25 04:43:06 +0800 CST

What rights do I need to run DBCC commands?

  • 772

Do I need to be sysadmin to run DBCC commands on SQL Server? Or is db_owner rights enough?

sql-server sql-server-2008 dbcc

1 Answers

  1. Best Answer

    Not all of them are the same, but at least one explicitly requires sysadmin.

    See the Permissions section of DBCC INPUTBUFFER on msdn- this requires sysadmin. DBCC CHECKDB only requires db_owner.

    Are there any in particular that you're looking to use?

    • 3