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...

Conan (great name)

There are a few SQL Saturdays coming near you. One in Philly, one in Chicago.

http://www.st-maarten.com/

Friday shirts are being packed 😀

I think Mid v Sr encompasses a lot of things. However the big one is experience. Someone that is senior has more experience and has handled many situations. It's not...