The statement I gave might be wrong, as I intentionally done this, because i was in a hurry. But i was wondering if there is any hint/option that can be...

Thanks for the reply, I didnt quite understand you when you said do it in steps, do you mean

dbcc shrinkdatabase(parameter,10)

then next is

dbcc shrinkdatabase(parameter,12)

Thanks very much everyone.

This has sorted me out

Thanks very much with that idea, the problem is that the inserts would happen evry aftenoon, and this method has to bevery dynamic and automated, so it should not need...

Thanks very much for your solution, this worked a treat, the other question is what if I need to make 12 midnight 4AM in the midnight ?

Thanks for your reply let me elaborate more on the situation.

Its a very large database, again close to a terabyte in size, because we process data daily, this is still...

Than for your reply, the situation in my own case is that I haven't  got exchange server. but instead i have got around 3 email provideds (pop/smtp).

I only got to...