General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
>I had created a fetched grid. Sometimes there was too many records being on grid so fetch wasn't ending. User was trying append new record when that time. All machines on SQL server was locking. After that I prevented fetch and my problem solved.
I think there is a bug here.
>
>>>SQL server process your commands in a queue. if you use a server side fetch, your select command not ended until you end the fetch. If you try another sql command with same handle you'll see your server's all station will locked!.. It's strange but, true. It had reasoned me a big trouble. I can't forget my scary movie. :)
>>
>>Can you post a sketch of code ?
>>Thanks
Previous
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