To be clean I am running DBCC CHECKDB ('database name', noindex) WITH PHYSICAL ONLY.

This is actually a Microsoft recommendation, refer to Books Online, DBCC CHECKDB, Best Practice. No matter why I am doing it, it does not work.

I have already verified that there are no other spids using this database. I fact the last time a tried this was after a fresh server reboot on a Sunday when I knew that no users were on the system.

To give a few more details. This server wil not reboot on its own. It getting to the "Shutting Down" screen and just sets there for hours. I have to hard boot it. I just discovered that the SQL Server service will also not shutdown cleanly. The stop request gave an error, however, the Services list showed that it was stopped. So I opened Task Manager and sure enough the SQL service was still running.

As I said before this started with on database have an issue, I was able to delete it, now I have the same issue with another database. I have also tried to detach the database, drop the database, and backup the database. All fail. I can query the data with no problem. It is as if any time SQL needs to talk to the OS about this database, it locks up.

Any suggestions are greatly appreciated.

Thank