I just was making some performance tests with some batches going one by one, that was returning only times of durations.
At start of every batch I called statements for cold start, so - in result - it added doubled
DBCC execution completed. If DBCC printed error messages, contact your system administrator."
for every batch.
So, I found, that there is possibility to call it in silent mode by use WITH NO_INFOMSGS clause:
DBCC FREEPROCCACHE WITH NO_INFOMSGS DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS
Published under: SQL Server Tips · · · ·
Thanks. Good to know !
This is good stuff and voted a "Like this", though when testing, I normally like the visual reminders that these things have occured so I can remember to remove them before I move the code to production. ;-)