mwagh (2/19/2013)
Thanks!! works in my case as i have a lot initially allocated space which was never touched.
Hi, sorry, I was not aware of this, anyway, with truncate only option only available for sql 2005 right? because I know they took away this option for 2008 and above. Just curious which version you are using.
SueTons.
Regards,
SQLisAwe5oMe.