i still have one confusion,
Why i was getting "blocking by internal processes" for all above mentioned commands , is it normal (though i havent experienced in past) behaviuor ?
i know the best apporach on that moments was to wait for command to get completed.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)