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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-27 : 09:03:41
|
| Desmond writes "I have a table which store the log files in a database . Due to the size of logs is getting larger (approach 5 GB) , I would to delete the all the logs. When I tried to delete the logs by opening table (return all rows) , a error message displayed " Microsoft][ODBC SQL Server Driver]Timeout expired" . 1. Why the error message displayed ? 2. How to empty the table contents without deleting the table ? Thank you SQL server 2000 SP3 Windows server 2000 std edition " |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-09-27 : 09:19:43
|
| 1. Because the query didn't respond in time. You can change this time in Connection tab of Server Properties.2. How about using TRUNCATE TABLE from QA?? |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-09-27 : 09:45:14
|
| also...using a smaller commit count, within a while loop would assist this process.Also are you using EM??..."opening table (return all rows),"....this practice is not advised.Use QA to write scripts to create T-SQL statements to perform any actions you wish to have implemented...less chance of errors...also QA gives more power/control to a DBA.EM...is o.k for getting started...but QA is the "tool of experience...and a better friend!!". |
|
|
|
|
|
|
[Microsoft][ODBC SQL Server Driver]Timeout expired