Try the SQL Native Client instead.

In that case you might try DMO as well.

As for the BINARY thing, I wouldn't know, the last time I wrote directly to the Registry was years ago and in...

Peter (11/5/2008)

---

Case 3 - Dynamic Switch Type SP) This is a good combination of the two. I need to look into our access/permissions model to know if dynamic sql is...

These do not seem well-normalized to me. It seems like you should have at least 2 different tables for each "group". One to describe the elements of the...

Yes, you can do this. However, you may need to separate the individual commands into separate batches by using Dynamic SQL invocations.

Glad we could help.

I have done something like this with SQL Mail (sadly, it is not possible with Database Mail).

Sadly, no.

COALESCE() is used to replace NULLs with another value:

COALESCE(A, B, C, .., Z)

The coalesce function searches through all of the parameters, left to right, and returns the first one that...

You have to use the "DEFAULT" keyword:

select dbo.CalculateNumber(DEFAULT, DEFAULT)

Granted, not very useful, but that's how it works. 🙁

What ODBC provider/driver are you using?

den put de right name in.

Race condition.

Like this:

UPDATE Tmp_DatabaseLog

Set Object = {YourNullReplacementValue}

From Tmp_DatabaseLog

Where Object IS NULL

Well, I would take it to Microsoft then.