Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
velnias2010
Posting Yak Master
125 Posts |
 Posted - 2011-07-13 : 07:31:53
|
| down vote favorite Hey when I try open table I receive the messageTimeout ExpiredThen when I try and rename the table I getRename Failed Lock Request Time out ExpiredBasically I just want to empty the content of this table but every step there is something stopping me.Any Ideas ? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-07-13 : 07:34:27
|
The table is possibly locked by another session?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
velnias2010
Posting Yak Master
125 Posts |
Posted - 2011-07-13 : 07:36:53
|
| Hi webfred,Yeah maybe im not sure, or maybe its gotten to large ?Anyway thats what I am unsure about, im wondering simply how can I empty this table and get access to it again ? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-07-13 : 07:39:04
|
truncate table tablenamein a query window
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
velnias2010
Posting Yak Master
125 Posts |
Posted - 2011-07-13 : 07:48:54
|
| Cool that worked |
|
|
|
mr_abuzer
Starting Member
1 Post |
Posted - 2012-02-02 : 02:47:32
|
| hi,i have the same problem, but i don't want to delete the table, i just want to release it, how can i do that?Maher Abu Zer |
|
|
|
|
|
|
SQL Server Unable to Open Table or Rename