Thanks Koen...It worked...exactly what i needed ....

I read books only in English..and I have started to read Fundamentals Of T-SQL by Itzik Ben-Jan, I find it really Helpful thanks to "Jason-299789 " and other peole who...

That is how it we set it but still agent stopped...so i was just thinking if i can find a work around for it...

Anthony,

Can you provide me the script and the procedure to do this?

Anthony its happening with all queries and indexing i am not sure when it was done..

Yes Sanket same hardware configuration same number of databases in same domain..

Thanks for replying

I actully need the difference between one block to one unblock, within the specific range if date.

Ex: if customer is blocked on Monday, when did e got...