Sorry, hit "Post" accidentally. fixed now.

Jonathan Kehayias (1/7/2009)

---

RBarryYoung,

Just curious why you don't use DBNull.Value? The other thing would be to set a default value in the SP to null as in:

create procedure insertproc

(

@datetimevar datetime...

Joe Celko (1/7/2009)

---

>> Why do you have to be so acerbic? Not a good way to make friends and influence people. <<

Quit being a whining child who expects...

Joe:

Your point is that if you use UPDATE..FROM incorrectly you can produce incorrect results? I am pretty sure that that is a unversal truth, not something unique...

My gut feel is that the sqlservr.exe on the failing box does not have some DLL loaded that it needs to make the CDO..smtp stuff work. This would be...

OK, I would recommend that you rewrite the properties of your BusinessObject like so:

Imports Microsoft.SqlServer

Imports system.Data

Public Class Funerals

'...

Private mFirstName As Data.SqlTypes.SqlString = Data.SqlTypes.SqlString.Null

...

What version of VS is this?

That's interesting Joe, I never heard the "unpredictable"...

I do not see any files.

This is a client code problem. Show us the VB that writes the values to the database (executes the SP...).

I do not remember SQL 2000 minutia that well, but don't you have to set something at startup to get it to create it's PerfMon objects? I am wondering...

Yeah, that article confirms what I thought about DTS: unlike SQL commands which execute in Server context, DTS executes in Client context, which is to say that it executes in...

This seems like an unusual (and possibly unreliable) approach....

Do the objects/counters show up in Perfmon if your rerun it interactively?

Jeff Moden (1/6/2009)

---

So, to me, it would appear that CDOSys is setup and working just fine on both servers. I've also verified that the jobs run as the same...