Hi Gila,

Thanks for your reply, I have attached the execution plan, Table and index script for your reference. For your informaiton i have used nolock because it is an dataware...

Please run re-index and update statics after the migration. The will help to increase the performance.

Same thing is happend for me. But after 2 days it came to normal.

As far as connection is concerned, we are remote connecting to the server thru mstsc. when we login to the server and try to connect to the database engine thru...

Yes i restarted after the installation!

After the restart also it is showing me the same..

Thanks Greg. it is working now.

Please help me how to use view server state permssion. It will be thankfull if u give the exact query.

Thanks. Thank you so much to all. It is working fine..