If you get something to work, I'd be interested to see what happened here.

And good luck

You should probably read the security sections in Books Online to understand this. Not to beat on you, and I know you just want to get something working, but not...

You can also see the code in the master database. I thought that 'domain\user' would work, but perhaps it's user in the database and not login.

You can always call Microsoft PSS and perhaps they can help you with getting some data, but we can't do anything with had header files.

And please make an attempt to do the work. This almost sounds like a homework or exam question.

Hint: Use UPDATE for the SQL side.

I haven't seen this before. My guess is that you didn't complete something on the first instance that was installed. Did you install any hotfixes or patches on that first...

The paths from EM are paths that the SQL Server service account sees, not what your account sees. Don't forget this is a server service, it is not running under...

It sounds like a tool corruption issue or perhaps memory on the workstation. Are you opening SSMS from the console or your workstation?

I have used MOM briefly and What's Up Gold, but not Idera. You can download an eval and give it a try. See what you think. Most of these package...

Has the key been copied to the other database?

As Paul mentioned, if the headers are corrupted, there is no way to attach it. They saying goes:

Good resume

Good backup

You only need one.

You can check sp_who2 to look for blocking, check the CPU as another query might be taking up resources. If the server was recently restarted, the first query can be...

The reason that everyone recommends backing up locally is that the backup process is similar to UDP on the network. It is optimized for speed and sends pages out as...

SQL Server is a server service, not a program like Access. It needs to be running for a client to connect. For both your questions, you really need to look...

I guess I meant it's harder to say I worked 10 hours at home and took Friday off instead of 8 hours. It's more that you just have to get...