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