The two instance names are

server\MSSQLSERVER - Default

server\prsvr

Not the server name itselfs. Is this possible with Network??

I included a screen shot that shows the 2 instances and that they have the same files for master. Is it possible that there is 2 names for the same...

I checked the server and all databases is exactly the same. As if they are in a cluster. Even sys databses is the same files.

No worries found the problem. Experiencing the monday stupidity.

No worries found the problem. Experiencing the monday stupidity.

That is correct. Code runs fine in SSMS but not in the job. It fails with the above mentioned message.

What can I post for you guys. I thought that it...

Can anyonde else help please

It is the same as the script I use to attach manualy. I just copy and past.

The upgrade is not the problem. I am attaching flashcopy from mirror on SAN. When I attache the DB in the job it gives that error. If I do it...

Hello

I see that the output of the upgrade is too long for the job execution. Is there a way to get around this. Swith off output maybe

In place of having the select in the join replace the select part with a temp table here and create the temp table before you run this query. This is...

Just a suggestion. The subquery used now can be put in a temp table or table var that should increase the performance.

Try changing you loggin on the SQL service. Both instances should login with domain user that have rights on the other server and have right to SQL server. Add the...

Excesive wait times on the memory could increase wait times on the cpu. cpu usage should not increase but the waittimes would.

Hello again

What we suggested was reducing the memory for the mirror instances to 256mb each and see how that works. SQL will try to use all memory you allocate if...