Table lock after integrity maintanence completion

Question

I am using SQL Server 2000. I have a database with n number of tables in it. I have configured a maintenance plan. If I enable integrity check and run the plan, I am not able to enter any data through VC++/ODBC.

Is there anything I have to check?

Answer 1

I think you'll do yourself a service by reading CHECKDB From Every Angle: Complete description of all CHECKDB stages on Paul Randal's blog.

Specifically, locking happens in SQL 2000 during the Non-clustered index cross-checks portion of CHECKDB.

If you are unable to enter data AFTER the plan completes, you may have a database that is corrupt. I suggest reading the above blog, and run CHECKDB yourself in the Query Analyzer to monitor output.