January 14, 2009 at 2:20 am
Hi,
I'm using SQL Server 2005 Standard Edition. When I open my database and tyr to expand the tables sections on the left hand side of the pane an error pops up stating that " Tables are locked". How to unlock the tables. can any one the chaps here suggest me how to go ahead.
Narayanamoorthy
January 14, 2009 at 2:53 am
You might not have GRANT on this table. Check with your administrator about the access.
Regards,
Nitin
January 15, 2009 at 11:34 pm
aanryn (1/14/2009)
Hi,I'm using SQL Server 2005 Standard Edition. When I open my database and tyr to expand the tables sections on the left hand side of the pane an error pops up stating that " Tables are locked". How to unlock the tables. can any one the chaps here suggest me how to go ahead.
Narayanamoorthy
Use databasename
go
dbcc opentran
run above query anf foung spid, kill spid
u will able to unlocak table..
January 16, 2009 at 3:39 am
it's not the problem of open transactions, the user does not have permission to view the table(GRANT)
Abhijit - http://abhijitmore.wordpress.com
January 16, 2009 at 5:28 am
Yes it is table access problem. Check access rights.
Regards,
Nitin
January 16, 2009 at 5:56 am
I don’t know what the problem is, but I don’t think that it is because of permissions. If a user has no permission to work and see any table, SSMS just won’t show it to him without giving him an error message that the tables are locked.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 16, 2009 at 6:54 am
Abhijit More (1/16/2009)
it's not the problem of open transactions, the user does not have permission to view the table(GRANT)
This is the problem due to some one has the process of table in transaction.. and tranaction is remain open..
So that'y i want to suggest u to check open transaction and kill it..
January 16, 2009 at 11:59 pm
Hey chaps,
Thanks a lot i was able to expand the tables. Used the command "dbcc opentran" and killed the id's.
Thanks a lot.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply