I have come across the same problem myself many times. I have found that if you back up the database first, then shrink it, it will reduce in size. It has something to do with the log file refusing to shrink unless there is a backup of it.
Programming today is a race between software...
ESquared,
True, you did post your answer 3 minutes before mine. But I can't help but wonder if Ambsgirl was able to implement your solution or mine faster and easier. Although, I must say yours looks very thorough! I guess it all depends on what Ambsgirl is doing with it. Thanks for your...
Hey AmbsGirl, I realize that sometimes a person is on a time constraint and is looking for an answer to quickly solve a problem, not for a long debate on the morals and ethics and writing standards for asking and answering questions. I've been down your road as well, and this select statement...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.