-
DBCC
Is there a way to view the script of DBCC statements provided by
SQL server
-
DBCC (reply)
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
-
DBCC (reply)
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
-
DBCC
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
-
DBCC
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|