Posted by Brian Cryer on 11/24/05 12:42

"Paul" <paulwragg2323@hotmail.com> wrote in message
news:1132826913.112745.10490@z14g2000cwz.googlegroups.com...
> Hi Erland
>
> Do you mean DBCC CHECKDB.
>
> I have never had any problems where I have needed to check any of the
> database structure before.
> I note in Books Online that there are a few DBCC CHECKxxx commands. I
> am guessing that you refer to the DBCC CHECKDB command?
>
> Thanks,
>
> Paul

Yes, 99.99999% sure he was referring to checkdb. That's how I read it when
reading the thread. All you want is:

dbcc checkdb('my-db-name') with no_infomsgs

That will check the database but won't do any repairs and won't flood you
with information messages.

Its worth running checkdb occasionally anyway. I got a fright recently when
running it against a database I thought was fine only to find it turned up
some problems.

Hope you resolve your issue.
--
Brian Cryer
www.cryer.co.uk/brian

[Back to original message]