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

Not that we're the most dilligent, but we don't have any real information about anyone on this site (no SSNs, credit cards, etc). Any billing we do for http://www.sqlserverstandard.com is...

Thanks. Glad that after a year or so, this stuff still applies.

Can you post the code? What does the proc do? This is usually when a connection cannot find the server. Are you sure you have a connection at this point?

If you login as the SQL Server Agent account and run EM, does it still run? It's a connection problem of some sort. It's like the source server isn't running...

Wow, you're asking a tough one. Not sure how much there is on the web. Swynk used to have some stuff, might search there (it's not dbjournal or something).

I do...