Where can I find SQL DBCC coomands on local drive.

[aceofbase]

Where do I find DBCC commands in SQL 2000?


Is in c:\program files\microsoft sql server\80\tools or ?

Thanks.

 

[SonOfEmidec1100]

From BOL: The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for Microsoft® SQL Server™ 2000.

So there is no separate command file, its part of sql client and can be executed like any other T-SQL command. For example using SQL Query Analyzer or as a scheduled Job.

Hope this helps.

 

[aceofbase]

Thanks.