dbcc checkdb WITH NO_INFOMSGS

Question

dbcc checkdb WITH NO_INFOMSGS

sqlstar2011

SSCertifiable

Points: 6000
More actions
June 7, 2006 at 2:24 pm

#60963

I am running trace using sql profiler and see following message for some databases
for database RUP_CQ_I3T --
use [RUP_CQ_I3T]
dbcc checkdb WITH NO_INFOMSGS

whats the purpose of this statement?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

Google and SQL Server Books On Line are your friends! use them first, and use the forums to clarify anything you didn't understand.

the first link in google for a search of "dbcc checkdb WITH NO_INFOMSGS"

http://doc.ddart.net/mssql/sql70/dbcc_3.htm

DBCC CHECKDB (T-SQL)

Checks the allocation and structural integrity of all the objects in the specified database.

NO_INFOMSGS

Suppresses all informational messages and the report of space used.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

sqlstar2011 SSCertifiable Points: 6000 More actions · Answer 2

Lowell

I saw that on web before asking the question. I think I should have phrased my question better. Instead what I wanted to ask is that why SQL Server is running this statement in the background?

thanks

Lowell SSC Guru Points: 323518 More actions · Answer 3

If you've created any maintenance plans for those databases, this specific operation would be part of the scheduled job:

Data Base Maintenance>>Integrity Tab>>Checkboxes for Check Database Integrity & Include Indexes

you would probably see this command nested in the middle of other maintenance type sqls;

I don't believe SQL Server runs this command automatically whenever it wants, but I'll research that and double check.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!