General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
File locking using Sql Update in Windows2003 Server
Environment versions
Network:
Windows 2003 Server
I have a problem and I am seeking a little help. I have an application that's trying to do 13000 Sql Updates in a transaction to 2 tables. It runs fine for about 2000 or so updates and then hangs. When I check the server for file locks, I notice that there are 2000 or so locks on each file. I cannot identify what's causing this and I am wondering if there is a lock limit on the server that maybe an issue here? Thanks in advance for any help.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only