Thanks for sharing. I will treasure it and keep it handy in case I ever need it.

This was very helpful to me. I was able to use this within an SSIS package and send an email notification when command failed.

giles.clapham (11/9/2010)

---

I've come from the school of thought that shrinking a database is only putting it into a state where it has to grow again and hence should be avoided,...

Thank you for this great explanation.

I will start looking for views that may be useful to change.