3

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

atricapilla
  • 615
  • 6
  • 12
  • 15

1 Answers1

3

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?

Will
  • 408
  • 3
  • 8