October 18, 2006 at 8:38 pm
Hi
I canot drop ,delete rows or rename a particular table in my DB.I facing time out error.Please let me know how to fix it.
Thanx
Usha
October 19, 2006 at 12:44 am
Usha
check whthr any process has locked up your table.
In EM - Management\CurrentACtivety\Locks/Object.
"Keep Trying"
October 19, 2006 at 8:08 am
I have had this a couple of times and its always when I have used BEGIN TRANSACTION without the follow up COMMIT or ROLLBACK.
Debbie
October 19, 2006 at 2:45 pm
Thanx for your help.I ll try to fix the prob and let u know.
Usha
October 20, 2006 at 11:58 am
If need be, you can kill all connections to the database except yours by setting it to single_user with rollback immediate. I use this in my restore commands. Like this:
Alter Database MyDatabase Set Single_User With Rollback Immediate
Drop Table dbo.MyTable
Alter Database MyDatabase Set Multi_User
However, if this is a production database, you should be aware that this will disconnect all users in the dataabase.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply