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 |
|
JoePec
Starting Member
14 Posts |
 Posted - 2004-12-24 : 15:00:45
|
| I have recently had my phpbb message board crippled by a worm attack. I had to upgrade my existing phpbb software.Now since doing that, I have been getting an error message that is telling me that my table : phpbb_sessions is full. I need to empty it and don't know how. I have EM but am not sure if I use a query or exactly what. And what command I use either.Any help at all much appreciated and have a happy and safe holiday. |
|
|
JoePec
Starting Member
14 Posts |
Posted - 2004-12-24 : 15:02:17
|
| By the way, this is an SQL 2000 db. Sorry. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-12-24 : 21:57:16
|
| Your table is full??? Can you type out the exact error message please? How many rows does this table have?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
JoePec
Starting Member
14 Posts |
Posted - 2004-12-25 : 06:59:14
|
| I don't think it was full, but the error message indicated that I should empty it. I just did a DELETE FROM table and they cleared. But it didn't help. Thanks for posting. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-28 : 02:58:38
|
| can you post the exact error message?--------------------keeping it simple... |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-12-28 : 17:30:45
|
| There is no error message in SQL Server indicating you should just "empty" a table, so I'm sure your solution didn't work.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
JoePec
Starting Member
14 Posts |
Posted - 2004-12-28 : 20:09:59
|
| Thanks but I have gotten by. |
|
|
|
|
|
|
SQL empty table help