Re: who can execute DBCC commands ?

From: Hassan (fatima_ja_at_hotmail.com)
Date: 11/19/04 

Date: Thu, 18 Nov 2004 21:15:57 -0800

Its dbcc inputbuffer..

"Adi" <adico@clalit.org.il> wrote in message
news:1100840640.763054.210050@c13g2000cwb.googlegroups.com...
> It depends on which DBCC command you are talking about. There are
> commands that you need to sysadmin in order to run them (for example
> DBCC traceon) and other commands that you can be dbo (for example DBCC
> opentran). Sometimes you can find DBCC statements that you also don't
> need to be the dbo. For example DBCC Checkident can be used by
> ddladmin and DBCC sqlperf can be used by anyone that can logon to the
> server.
>
> Adi
>

Relevant Pages

  • Re: Permissions to run DBCC SHOWFILESTATS
    ... There are many commands for which permission cannot be granted; many DBCC ... > that uses the undocumented command "DBCC SHOWFILESTATS" to get data file ... As I am not an SQL Server Admin, ...
    (microsoft.public.sqlserver.security)
  • Re: Curious performance experiment
    ... Before starting to tune the query after re-creating an index run the ... following commands ... DBCC FREEPROCCACHE clears the procedure cache and causes ad hoc queries to ...
    (microsoft.public.sqlserver.server)
  • Re: Backup...
    ... dbcc log ... I tried the following commands ... >>TRANSACTION LOG. ... >>You might also try using the undocumented DBCC LOG ...
    (microsoft.public.sqlserver.server)
  • Re: Curious performance experiment
    ... >following commands ... >DBCC FREEPROCCACHE clears the procedure cache and causes ad hoc queries to ... >if you want to clear the data cache you will need to use DBCC ... >specific database on a SQL Server, ...
    (microsoft.public.sqlserver.server)
  • Re: DataFile
    ... >> Before using the above three commands my 'Health_Data' DataFile size ... >> dbcc shrinkfile ... > Imceda Software ... Prev by Date: ...
    (microsoft.public.sqlserver.clients)