DBCC

[Rajiv Batheja]

Is there a way to view the script of DBCC statements provided by
SQL server

[David Pierri]

If you need to find out the list of DBCC related commands, look no further than your help menu in EM/transact-SQL help and type DBCC.

I hope this is what you want.

If you are looking for the actual code that encompases DBCC, I don't have a clue.

David


------------
Rajiv Batheja at 8/2/99 1:35:02 PM

Is there a way to view the script of DBCC statements provided by
SQL server

[Wayne Ferguson]

If you specify a report location, then a report will be generated by SQLMAINT.exe:

@echo off
sqlmaint.exe -S "yourServer" -U "yourUser" -P "yourPword" -D "yourDB"
-Rpt "C:MSSQLLogDatabaseDatadbmaintData.log"
-CkDB -CkAl -CkTxtAl -CkCat

Is this what you wanted?
W.



------------
Rajiv Batheja at 8/2/99 1:35:02 PM

Is there a way to view the script of DBCC statements provided by
SQL server

[dpierri]

I think you have slightly misunderstood my question.My question
is how do I view the T-SQL script or VB Script written behind each
DBCC Commands.
i.e What is the script behind DBCC Showcontig or DBCC DBREINDEX etc.

Hope to get the reply
Thanks
Rajiv

------------
David Pierri at 8/2/99 2:51:13 PM

If you need to find out the list of DBCC related commands, look no further than your help menu in EM/transact-SQL help and type DBCC.

I hope this is what you want.

If you are looking for the actual code that encompases DBCC, I don't have a clue.

David


------------
Rajiv Batheja at 8/2/99 1:35:02 PM

Is there a way to view the script of DBCC statements provided by
SQL server

[wferguson]

I hope you misunderstood my question. My question is how do I
view the T-SQL script or VB Script that that is executed when you
run DBCC Commands. i.e. What is script when you run DBCC SHOWCONTIG
or DBCC DBREINDEX

------------
Wayne Ferguson at 8/2/99 7:13:39 PM

If you specify a report location, then a report will be generated by SQLMAINT.exe:

@echo off
sqlmaint.exe -S "yourServer" -U "yourUser" -P "yourPword" -D "yourDB"
-Rpt "C:MSSQLLogDatabaseDatadbmaintData.log"
-CkDB -CkAl -CkTxtAl -CkCat

Is this what you wanted?
W.



------------
Rajiv Batheja at 8/2/99 1:35:02 PM

Is there a way to view the script of DBCC statements provided by
SQL server