>We'll you dug back pretty far for that message. You will not be able to shrink the size of the log file until the active segment (virtual log) is towards the front.
>
>Check out this FAQ:
>
>
http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14337>
>-Mike
I JUST realized that this message was from October of 2000! I though it was 1-2 days old.
I did some reading on it and I see how it works in SQL 2000. Is that a change from SQL 7? Also, is the equivalent of "Truncate Log on Chckpoint" of SQL 7 the "Auto shrink" in SQL2K?
Thank you,
Aristotle