ya it's a 32 bit instance.

I have also enabled AWE from 0 to 1

After disabling AWE the query is working fine now...

Thanks for ur reply.