Use Sql Server Profiler and look what statement exactly passed to server to run.
If it wouldn't help, write here your stored procedure and the statement from Sql Server Profiler.
-------------------------
- Name?
- Abu Dalah Sarafi.
- Sex?
- 3 times a week!
- No, no. Male or Female?
- Male, female, sometimes camel...