DBCC CHECKDB permissions

From: Mike Mullane (mike.mullane@hpinc.com)
Date: 08/07/02 

From: "Mike Mullane" <mike.mullane@hpinc.com>
Date: Wed, 7 Aug 2002 13:43:50 -0700

How can I give a database user permission to run DBCC
CHECKDB without assigning them to the sysadmin role?

Relevant Pages

  • Re: Help-Corrupt table
    ... table corruption that DBCC repairs will not fix so you must restore from ... >clustered, hypothetical index. ... >>BTW CHECKTABLE and CHECKDB are different if you check ...
    (microsoft.public.sqlserver.server)
  • Re: DBCC error 913
    ... You don't need to run DBCC CHECKALLOC as well as DBCC CHECKDB - CHECKDB ... >> I assume that you use ALTER DATABASE to set in single user mode... ... >>> This is simple DBCC script I am running on the server every sunday. ...
    (microsoft.public.sqlserver.server)
  • REPAIR_ALLOW_DATA_LOSS
    ... bringen die checkdb befehle zu akzeptieren. ... DBCC CHECKDB ... Database 'AE1' cannot be opened because some of the files ... Could not restart database 'AE1'. ...
    (microsoft.public.de.sqlserver)
  • =?Utf-8?Q?Re:_Konsistenzpr=C3=BCfung_fehlgeschl?= =?Utf-8?Q?agen?=
    ... Nun habe ich gleich die nächste Frage. ... for the errors found by DBCC CHECKDB (msdb). ... DBCC execution completed. ...
    (microsoft.public.de.sqlserver)
  • =?Utf-8?Q?Re:_Konsistenzpr=C3=BCfung_fehlgeschl?= =?Utf-8?Q?agen?=
    ... Wie rep ich die DB nun? ... CHECKDB found 0 allocation errors and 2 consistency errors in database 'msdb'. ... DBCC execution completed. ... Als SQL war bei der erstinstalltion die standrat SQL von dem SBS 2003 ...
    (microsoft.public.de.sqlserver)
Loading