Sorry Alex for the off-topic drift into browsers.

Back to your mail problem then.

The thing is that SQL Server has no clue about what addresses the Exchange server will actually...

I'm a bit curious as to why your client thought the process hung.

I'm not so sure that cancelling the operation was such a wise move. Whenever you're dealing with a...

Unfortunately, there's no such thing as a free lunch.

A default constraint can deal with inserts automagically, updates however must be dealt with

by a trigger, or by...

Thanks

Well, I'm over at sswug.org most of the times anyway, just thought I'd check how things were over here.

But if I can't get...

Ok, but how are you gong to do that?

I'd suggest that you just try to send the mail, and if it bounces, trap that

and display or log the offending address...

Well, Frank... It depends...

I use IE as browser, and just click the 'reply' button (or 'quote')

However, I onle get a single row...

Sort of a Moment 22 then?

How would you know if the address is valid without trying to send it? Only the mailserver knows if it can send the mail...

And you are still positive that you recieve no messages at all?

I must ask you if the query completes at all? If it does then you should recieve something in...

Can you provide your exact syntax for both attempts?

Both when it succeeds and when it fails.

If it fails.. You say you wait - Does the query...

So, what kind of error do you get?

Can you exec without the insert?

Are you using the correct syntax?

exec server.dbname.owner.procname

I assume here that you are trying to...

Oh, yes.

Being able to ping a server doesn't tell you anything at all except that the TCP/IP stack is up and running.

You still have no clue...

Not quite correct.

SQL Slammer uses UDP port 1434, not TCP 1433

=;o)

/Kenneth

No problem.

The clock keep on tickin' anyway

=;o)

/Kenneth

If you fail in QA as well, then there's not much hope of registreing through EM.

Is there any particular reason that you created an alias in client network utlity?

If not,...

Ok, I see.

That is the result when you tried the suggested syntax of

D:\readpga>c:\mssql7\binn\isql -Sclarcombe -dpga -Usa -P -w256 -h-1 -Q"exec AGGT_INRUNNING '''SCORE'''" -oaggtscoreir.htm ...I assume?

Your initial post had -Q"exec...