You can see which files are changed in the kb article for each SP/CU. You will see quite a few files have their sizes and versions updated.

I'm a little late, but I'll add my $0.02 in there.

For the most part I don't think tables, stored procedures, and certainly not columns, need a prefix. The code itself...

Looks like The Thread is alive and well. Good to be back and hoping everyone behaved over the last week.

I think that's correct. Just add that failover partner to the string and you should be OK

What were you doing? Is this on startup? Or after you've connected to a system? Have you tried connecting to different systems?

Hopefully it's not a problem with Windows.

Two things: can you change another services ( like SSIS) to Local System?

If that works, can you reboot and see if something is just...

How is the job running? Typically this isn't under a user account. When you run it interactively, the package runs under your account. Those credentials might not work when a...

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?