Hi, when will i get shared lock in sql server 2000? i am performing 2 operations select,update on the same table is there any possiblity for...
I did not used any procedures. i have just written a code for select statement. then how can i specify the begin tran. quote:Originally posted...
i am using sql server 2000. while i am using my application, simple select query also blocking... i have used default transaction...
Hi, In that blocking process executed query is select property_value from application_property where system_code='DEFCRTNAM' and relation_key=21234...
Hi, why the lock is placed in the first place? why the other transactions are not executed. In the previous reply process id 57 is blocking and...
Hi, i am using sql server 2000. while running my application, sometimes the row is locked.. i have given my locking status result.. can u tell me...
Hi, I am using sql server 2000. while running my application, some times the row is locked. When the row is locked, i have used dbcc opentran...
Hi, i have ran this command .. it show the given below result Oldest active transaction: SPID (server process ID) : 64 UID (user ID) : 1...
Hi, Thanks for ur information. onething i did not get it... open transaction has not been chosen as a deadlock victim.. can u explain abt what are...
Hi, I am using sql server 2000. some times when i was executing a simple select query against in the database, the select query is keep on running....
Hi,<br /><br />When an user accessing the query, in the same time another user also accessing the same query. <br />For ex:<br />select...
Hi,<br /><br />While accessing my application, it retrieves the values from the errors table and contains assined_to,error_status_key.<br />errors...
Hi all, I am using sql server 2000. after few hours while selecting value from the particular table with different values, it doesn't retrieve the...
Hi all, I am using sql server 2000. i have a method in java which is used to retrieve the error_key,error_parent_key value from the database. i...
Hi, How to check the problem exist in tomcat or sql server... after few days running our application, each page takes time to display the details....
Hi, I am using sql server 2000 . after few days in our application gets slow to display the details. I have used sql profiler to check which is the...
Hi, How to check the query using sql profiler while running the application... What are steps have to follow to check it and what are all the...
Hereby i am sending the server.xml for our application named sample<br /><br /> <Context...
Hi, I am using tomcat 4.12 and jdk 1.4.0.. sql server 2000 is the back end. when we accessing our application contionusly for more than 4 days,...
Separate names with a comma.
