This is interesting stuff. And I'm curious about the following situation:

We have a primairy server and a standby server. Via transactional replication we keep the standby server uptodate. Suppose the...

Well, I found out WHAT caused the problem and how to work around it. The systemvariable @@SERVERNAME is not accepted as input for the update. I now declare a VARCHAR...

That's how you generate 5000 postings...

Very nice question. Makes have an indept look at this Master/Target functionality. At first sight tho I wonder if this is very usefull.

Tnx David, I'll be sure to look into your procedure. It's just that this problem nags me. I have written something like your sp on ad-hoc basis, though not as...

I see what you mean. It is the same as properties under supportservices\sqlmail.

Tnx anyway.

Ronkyle,

Which 3 places are you referring to? I can think of SQLMail, SQLServerAgent, and no other. Do I miss something here?

Tnx for responding tho.

Alas, tried it, but did not work. Question remains open.

Tnx for responding tho.

SQL2K with sp3a, W2K OS with the latest patches.

If you mean with remote-sql: does xp_sendmail work when I have opened QA on my pc and exec it, yes, it does...

I did stop&restart the agent. Even had the server rebooted

I have looked at other smtp ways of sending email, but the ppl I have...

But it has. SQLMail works fine.

I have mixed feelings about this 1. Should I know about registrysettings about possible datasources? I guess so, when confronted with a situation like this. However, I tend to stay...

Shoe, to slow!

It did, and they usually do, even the convoluted(?) 1's. See, I even learned a new word! Looked it up at meriam-websters online.

It did, and they usually do, even the convuluted(?) 1's. See, I even learned a new word! Looked it up at meriam-websters online.