December 8, 2008 at 3:46 pm
Hi All,
I have a database lock which happens when I have index page lock.
how I can get rid of that.
is there any parameter to set SQL 2k index locking as row locking?
regards
December 8, 2008 at 11:28 pm
Hello,
In SQL 2000, it is possible to disallow Page Level locks for an Index. Please see the BOL Topic “Customizing Locking for an Index”.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
December 9, 2008 at 11:50 am
thank you for your reply, please give me more detail, URL or something .
Regards,
December 9, 2008 at 1:23 pm
kebrith (12/9/2008)
thank you for your reply, please give me more detail, URL or something .Regards,
John Marsh (12/8/2008)
Hello,In SQL 2000, it is possible to disallow Page Level locks for an Index. Please see the BOL Topic “Customizing Locking for an Index”.
Regards,
John Marsh
1. Open books online
2. Click search
3. Type "Customizing Locking for an Index"
4. Hit enter
5. Click on the article "Customizing Locking for an Index"
6. Read
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply