July 11, 2011 at 3:24 am
Hi, i have a user in the database that cannot expand the table view on a particular database. Everything seems normal, he can run a query but he cannot expand the table view. (when he presses the + symbol on the left after 10 sec he gets a timeout and the message with error 1222)
he also cannot run select on tempdb...sysobjects if that helps a bit. There is a process locking him, but why not the rest of the users?
anybody that can help? 😀
July 11, 2011 at 5:22 am
Looks to me that the particular user is opened some long running Transactions and now whatever he is doing is not working for him because the open transection is blocking the rest of it.
Look for all the SPID's getting blocked/Blocking
use 'Exec sp_Who ' to look for the login for these spid's
and kill the culprit process and hopefully that will release the locks on the table(s) and your user
will be back up and running.
Secondly you can get help from profiler to analyze what's going on your sql server.
Hope this help
Thanks
Imran
July 11, 2011 at 7:15 am
hi and thanx for your reply.
This user is not running anything else, there is only a stored procedure that is running and is causing some locks but i do not get why the other users have normal behaviour apart from him. If it was everyone locked it would make more sense 😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply