In SS2000 I used this to truncate the log:
dbcc shrinkfile ('MyDatabase_Log', 2)

At 1st that worked in SS2005, but not anymore. It runs, but doesn't reduce
the file size. When I first installed SS2005, Shrink File in Management
Studio reduced the log file, but now that doesn't reduce it either.

Any ideas why ?

Craig

How to concatenate strings from a column into a single row (with NULL value)?
Query help
Single to Multiple columns
Assistance with SQL Script
Need help with self-join