Re: DBCC Permissions

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 08/26/03 

Date: Tue, 26 Aug 2003 10:53:02 -0600

The DBCC command is undocumented but it looks like sysadmin
is needed to execute this.

-Sue

On Tue, 26 Aug 2003 09:01:40 -0700, "Eric"
<nfskvnkjn@kjnvkjnv.com> wrote:

>Hi,
>
>What server permissions would I need to run the statement:
>
>DBCC log (tbl_Name)
>
>When I run this statement the system just returns:
>
>Server: Msg 2571, Level 14, State 1, Line 1
>User 'HQ\exd188' does not have permission to run DBCC log.
>
>TIA,
>Eric

Relevant Pages

  • Re: Access sometimes wont use index of linked view
    ... DBCC DBREINDEX or DBCC INDEXDEFRAG? ... SELECT * FROM foo ORDER BY fldSorting; ... If i execute this in the query analyzer, ...
    (microsoft.public.sqlserver.clients)
  • Re: Access sometimes wont use index of linked view
    ... DBCC DBREINDEX or DBCC INDEXDEFRAG? ... SELECT * FROM foo ORDER BY fldSorting; ... If i execute this in the query analyzer, ...
    (microsoft.public.sqlserver.clients)
  • Re: DTS fails on Stored Procedure warning
    ... I am calling a stored proc from a DTS package in SQL 2000 using Execute SQL ... DBCC execution completed. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Shrinkfile does not find the file
    ... could you execute the below ... > command to get the logical name for that database. ... > After that use this logical name in DBCC SHRINKFILE command and try. ...
    (microsoft.public.sqlserver.server)
  • Re: Shrinkfile does not find the file
    ... could you execute the below ... command to get the logical name for that database. ... After that use this logical name in DBCC SHRINKFILE command and try. ...
    (microsoft.public.sqlserver.server)