What are your PKs? Are they integers or characters? You could have conflicts. Typically if you are merging things, you want GUIDs to minimize conflicts.

Depending on what you are bringing...

I'd follow Jason's advice. Without knowing if the I/O is saturated for those DBs, it's hard to know if changing disks around would help.

You might also reanalyze the access of...

Check the default trace in SQL Server 2005 (search default trace on this site)

You can use one IP, and set specific ports for the named instances (and even the default) in the SQL Server Configuration Manager.

This is where experience really shines. The ability to make good judgment calls about when to cut those corners and when you must bite the bullet and do the work...

In addition, consider using joins to update.

UPDATE ProfileTable

SET CustType = @CustType

from inserted i

WHERE i.CustID = ProfileTable.custID

;

I would verify that the account can connect to SQL. Check the Agent error log for startup messages, along with the Windows event logs (app + system)

First, can each machine see the other on the network? Using IP or the Explorer network browser, can you find the VM from the host and vice versa?

I tend to agree with #3 as well

I think it's about 8 hours. I've never seen them, so it would be a fun day or two trip. Plus the Negro baseball HOF is there.

I'm not sure where...

And buy him a few lunches. That will go a long way when you call later.

😀

If you error out on remote desktop, it sounds like the rights are messed up in Windows.

connections to one server, or SQL Server instance, don't necessarily mean that the rights...

Please pass the word to MS, and vote for SP4. Let everyone know that this is important.

I would expect that two conferences a year would still be 2-3 days, and that most of the same speakers would attend and you would have the same content. Maybe...