Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-23 : 09:12:39
|
| Devteam writes "Hi,WIndows version 5.0 (SP4)I am using sql server 2000. in our application i am using simple select statement to retrieve the value from the database. Sometime the same query is accessed i did not get the result.i have tried to run the same query using query analyzer. but the query is keep on running. at the same time when accessing other rows in the table, it gets retrieve the values.what is the problem here... is there anything locked that the row before executing the select statement. if there is any lock is present then how to identify it and also how to prevent a row from locking... if the lock is occured then the other transactions also not executed. why the lock is placed in the first place." |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2006-02-24 : 23:26:37
|
| Hi,refer sp_who2 -- will gives you detailed information about the current connectionsand sp_lock -- gives you information on current lock but you need to give more information to us :is your sql server is dedicated one ?!is it patched up with letest SP and patches ?!when error comes ! while running application or from QA only !are other table populates record set / result set for you !?RegardsAndy DavisSql Shield Team--------------------------------------------SQL Server Encryption Softwarehttp://www.sql-shield.com |
 |
|
|
|
|
|
Row level lock in sql server 2000