or code clients with an alias to connect to that particular server/port.

There are a few tools, AdeptSQL has one, RedGate another.

http://www.sqlservercentral.com/columnists/awarren/sqlcomparereview.asp

http://www.sqlservercentral.com/columnists/chedgate/reviewofsqldiffbylockwood.asp

http://www.sqlservercentral.com/columnists/rmarda/reviewofsqlcomparev3.asp

Above is correct and log shipping isn't that hard to implement yourself. Basically run the backups, move them to server 2 and restore them in stnadby.

The boxes should not be marked. These show explicit individual permissions. If they are marked, then I suspect that you or someone has actually set something which may be part...

agree with above.

Not sure about SQL 7. Have to check BOL on that one.

For licensing, I've asked this ? of MS before and they say you have to license all physical processes....

1. SA/sysadmin permission

2. Is this 8cpu per node? Then you need 16. You have to license each CPU in an active cluster node.

I agree. Check the query and then repost and we can help. One thing that you do need to understand, if you want to check for any of those values...

You are correct. You should be able to do this.

create trigger tri_h8summ on h8summ for insert

as

update h

 set hcaseworker = b.hcaseworker

 from inserter i

   inner join h8summ h

      on i.pk =...

Hey, post your suggestions, results. Or better yet, write an ariticle or two about what you've done (articles@sqlservercentral.com)

I don't believe that it can. I think you should just setup a local user account on the system.

The transmission is completely dependent on the TCP/IP and OS. Windows can handle this fairly well, but SQL is less tolerant, especially for some things like backups. Your connections may...

Is the agent started?

Did you give them the sysadmin fixed role? If not, the calls that the stored procedure makes will fail.

Interesting. I've run into the issue with single NIC/single IP, but NT auth works with named pipes. However since it's disabled with most servers (sockets only), it was blind luck...