I thank you each and every individual

SSC Eights!

Mr or Mrs. 500

SSC Veteran

Grasshopper

SSCrazy

Minaz Amin

for such a great support and help.

Well i have checked and there is no jobs that...

thank you all for your information

And sorry for answering late.

what i actually figured out is that, the former DBA have written some sort of code in the application which actually...

I am new on SQL server. I have worked on Oracle but very little experience of SQL Sever. I mean i have to compile the procedure and triggers again and...