That is ok. You have been a big help to me. Thanks!

Yes. I even opened that table and the same table of a different server that works, side by side and went through every column. They matched up exactly.

Could I ask one more question?

I have about 10 SQL2000 servers. I have this working on about half of them now, but I ran into this.

I have two SQL2000 servers,...

I couldn't figure out why it kept saying the login was failing and I was logged in to both machines as that same user, so I change it from BE...

Thank you for you help. I double checked and did what you said, and I did already tried this. This is the one that gave me this

result.

If I change

@datasrc='computername'...

I don't know.

When I try to connect I get this error.

Server: Msg 17, Level 16, State 1, Line 1

SQL Server does not exist or access denied.

That is using for

Thank you for taking the time to reply. I am not sure why I use my email for this. On my 2005 servers, I have that account set up so...

Does this only run if the job fails? Can you make this run when jobs also complete? On our 2005 machines

we have all jobs will email on failure except the...