Newbie question - disk defrag

Hi all
Please ignore my lack of knowledge, im new to sql...
I would like to defrag my sql databases and have found several sources on
the net that recommend using the command DBCC INDEXDEFRAG.
When I try and run this from the command prompt i get DBCC is not a
recognised command? Do I need something additional installed or do i not
run this from a command prompt?
Many thanks
This is a SQL Server command, not an operating system command. So you run it from, for instance,
Query analyzer, SQL Server Management Studio, OSQL, SQLCMD etc.
Also, make sure you read this first:
http://msdn.microsoft.com/library/en...server2000.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Si" <Si@.discussions.microsoft.com> wrote in message
news:B964ED96-1F06-4801-BBF9-43A7867D4D6B@.microsoft.com...
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i not
> run this from a command prompt?
> Many thanks
|||Si wrote:
> Hi all
> Please ignore my lack of knowledge, im new to sql...
> I would like to defrag my sql databases and have found several sources on
> the net that recommend using the command DBCC INDEXDEFRAG.
> When I try and run this from the command prompt i get DBCC is not a
> recognised command? Do I need something additional installed or do i not
> run this from a command prompt?
> Many thanks
DBCC is a T-SQL command, which you execute within Query
Analyzer/Management Studio...
Tracy McKibben
MCDBA
http://www.realsqlguy.com