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?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment