Some of the DBCC commands wont show the total results when we execute. like DBCC PAGE.
If we execute DBCC PAGE, SQL Server show the result as DBCC execution completed.
So If you want to results to Display in result pane, need to enable trace flag 3604.
DBCC TRACEON(3604)
If you want to results to Display in error Log, need to enable trace flag 3605.
DBCC TRACEON(3605)
If we execute DBCC PAGE, SQL Server show the result as DBCC execution completed.
So If you want to results to Display in result pane, need to enable trace flag 3604.
DBCC TRACEON(3604)
If you want to results to Display in error Log, need to enable trace flag 3605.
DBCC TRACEON(3605)
No comments:
Post a Comment