I am sorry.. and thanks for reply

Thanks for the reply. what i m doing it is only for test purpose.

I having two instances - "Rajesh\SQLINST1 " and Rajesh

1. My database is in "Rajesh" instance -...

your Linked server is working fine. test it and reply

Hi subahan - Now there is no blocking but user has told if blocking isssue will come you have to resolved. So i am finding the solution if blocking will...

Hi subahan,

Still is in same conditions. user told that if will face some blocking issue u have to resolve it. So I m finding the solution If problem will come...

Het john.. Thank you very much but here i have one more thing to ask.. Now my user tolt it is ok.. but If he will say you have to...

John,

I am DBA, except me only primary DBA can kill this. I told that user i m getting confuse so can you wait some time. He told ok for this....

Jon,

Its not giving any thing harm but I m getting request from User to kill the process.

Thanks for reply. I killed from SQL server. My command execute successfully but when i did

select * from sys.sysprocesses where sid = 100

still that session was present and its...

Thank you...... Any more ans ...

Thank you...:-)

Can some please reply for this....

In 15th line.... just remove >10 and give >0

WHERE migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) > 0

urgent ......................

My question was Is it possible to copy a resource database files when instance is ruining. if not why and yes then how to do simply copy and pest.

So i...