Thanks Luis.

I will take of that NoLock.

Thanks once again.

Hi Durga,

Thanks for the reply.

It worked.

Before trying this I had uninstalled and installed everything.

It's big help. I had spent so much time on trying to resolve this.

Thank you once again....

Both are same. I checked as you mentioned.

Hi Everyone,

Thanks for the reply.

It's not about any specific SP. I can access all other SQL objects such as Functions, Tables, Views etc.

If I try to check SP, it shows...