Than you very much. I moved the databases from local drive to SAn and

reboot the server. I did it on Wednesday night and so far the Log file is...

Thanks a lot for the reply. I have the job which run every minute to update and delete .

when the job is running , it's opening the transaction and then...

I am using sql server 2000.

Thanks

Hammad

After i put the http.exe in the path it worked.

Thanks

khan

getting the same error.

I am going removed the Begin trans and create the missing

index on QUEUE_ID in Queue_entry table.Any more suggestions .

Thanks

Thanks for the Information. when two spids call the stored procedure then they are blocking each other.