Tuesday, February 14, 2012

DBCC CHECKDB command help...

I need a bit of a hand with coding the DBCC CHECKDB command in QA.

I have been trying to configure my helpdesk database after moving drives in the original box after the old one ran out of space.

Now when i try and start the server daemons, i get a database check error.

can anyone help out with a DBCC CHECKDB command that will only check the database named AHDTEST50?

Thanks!Assuming that you ae using SQL Server 2000, then I'd use:USE AHDTEST50
GO
DBCC CHECKDB ('AHDTEST50') WITH ALL_ERRORMSGS
GO-PatP|||Pat to the rescue again!

Thanks pat.

No comments:

Post a Comment