hi all,

Thanks for all the responses. I figured out how to solve this problem.

BY altering the update statement in the stored procedure to forcibly use

the index, as

"UPDATE...

Thanks Marshall, I would be eagerly waiting for your post.

Rgds,

Mallik

Hi Paul,

  Thanks for the response. But that would throw an out of range error as sql server would not allow dates prior to 01-01- 1753. Just wanted to know if...