Thank you so much you solved my problem.

I have written COLLATE DATABASE_DEFAULT everywhere, where i use "where" clause in my procedure.

After reading your article i just remove COLLATE DATABASE_DEFAULT from...