Hi,
Could someone please tell me if there's a way to suppress the message sent to the sql error log after running the 'DBCC CHECKTABLE' command?
Thanks.Yes, there is a way to suppress it, but I don't remember the details off the top of my head. What are you trying to accomplish?
-PatP|||Well, instead of using checkdb, I'd like to run checktable in my script to avoid checking historical tables. However, running checktable keeps adding unnecessary entries to the sql log since I already have a log to hold the information. I don't need additional ones in the sql log.|||Running WITH NO_INFOMSGS for any DBCC statement will suppress all informational messages.|||Running with NO_INFOMSGS won't suppress the message in the sql server log.|||I'm just curious as to why you want to do this?|||What is the Audit level setting on SQL Server --> Security tab?|||The reason of using checktable is that there's a decision to keep the historical data in the same db but to a different table. Checktable is used in order to shorten the run time.
How does the Audit level in the Security affect the result in this circumstance?
Showing posts with label suppress. Show all posts
Showing posts with label suppress. Show all posts
Subscribe to:
Posts (Atom)