I have a perl script which updates some table records in sqlserver 2000, the flow is like below:
* A select query
This select query selects IDs(with other records too)
* An update query
This update query updates a bit column from 0 to 1 for the IDs retrieved from above select query.
The problem I am facing is: the update query can not update the records because the table is being locked by the first select query( only when select query returns records more than some threshold, let say if it return 18 records update runs fine but if select returns more than 18 records, update fails as table gets locked by select query.
Please help me out.
May 1, 2008 9:32 PM
May 2, 2008 10:48 PM