-
July 21st, 2009, 01:56 AM
#1
Table lock after integrity maintanence completion
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.
Last edited by ajbharani; July 21st, 2009 at 01:57 AM.
Reason: Attached image.
Rate the posts which you find useful
-
July 21st, 2009, 02:27 AM
#2
Re: Table lock after integrity maintanence completion
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.
-
July 21st, 2009, 02:29 AM
#3
Re: Table lock after integrity maintanence completion
Originally Posted by 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.
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.
Rate the posts which you find useful
-
July 21st, 2009, 07:47 AM
#4
Re: Table lock after integrity maintanence completion
Try checking the SQL Server log file to see if the integrity functionality have "crashed" or something similar.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|