Table lock after integrity maintanence completion

[ajbharani]

Hi All
I am using MS-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++/ADO.
Is there anything I have to check?

Thanks.

[davide++]

Hi all.

I don't know MS-SQL, and I don't know what exactly maintenance plan is. But I image that it means to check integrity data between tables, and you shouldn't insert new records when the plan runs, otherwise results won't be reliable. So the db engine locks tables to avoid users to add new records.

I hope this will help you.

[ajbharani]

Hi all.

I don't know MS-SQL, and I don't know what exactly maintenance plan is. But I image that it means to check integrity data between tables, and you shouldn't insert new records when the plan runs, otherwise results won't be reliable. So the db engine locks tables to avoid users to add new records.

I hope this will help you.

Thanks David. This is a good input. But my issue does not end here. Even the maintenance plan finishes, I am not able to insert anything in that particular table. Other tables are fine.

[Alsvha]

Try checking the SQL Server log file to see if the integrity functionality have "crashed" or something similar.