Where is DBCC

[siznad]

I am trying to run DBCC on my SQL Server 2000 machine, but it is saying that the program does not exist. Where can I get DBCC.exe?

Thanks.

 

[gmmastros]

DBCC does exist, but it is a SQL Server command. To run it, open the Query Analyzer, make sure you are connected to the proper database, and then run the command.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[JayKusch]

AND BE CAREFUL OF WHAT DBCC COMMANDS YOU ARE FIRING OFF!!!

The DBCC commands can be VERY powerful. Make sure you understand their intent, defualt usage and available parameters. Some of these commands can take you database into single user mode and if that DB were a production server ... that may not be a wise choice - lol.

Thanks

J. Kusch

 

[hmckillop]

As Jaykusch said you need to be careful what ones you use and be fully aware of what they do before you execute them.

On the other side there are many undocumented procedures which are exceptionally useful, you can find these on the web such as :

http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp

What is it you are trying to do?


"I'm living so far beyond my income that we may almost be said to be living apart