|
|
Browse by Tags
All Tags » DBCC output (RSS)
-
Sometimes it may be useful to reuse the result of the DBCC commands. If the DBCC command resturns a resultset, it can be outputted to a table.
Consider the following command
DBCC useroptions
It returns a single resultset. To copy the resultset to a table, you can use the following
Create table #dbcc_useroptions ([set option] varchar(100), ...
|
|
|