Didn't Panorama claim the same thing not so long ago?

This sounds SQL Server 2000. Am I right?

If so, you're in the wrong forum.

I don't know much about DTS2000. Are you able to reinstall SQL?

Ed,

I think the different behaviour more likely due to some server setting, perhaps default language as suggested by Dave Ellard. As I eluded to in my blog post, if you don't follow the guidelines...

In case anyone's bothered I've blogged about this here.

PW,

Whether it fails or not its useful to know - so definately worth trying.

As it happens, it worked.

Lets take the next logical step - test YYYYMMDD using a CAST...this worked as well.

So lets...

I can confirm that the error occurs when using CAST as well.

2 lessons learnt:

1. Use the third parameter when using CONVERT

2. Because you can specify the third parameter, use CONVERT instead...

OK,

This is what I've done.

1. Cleared all the comments out of the SP. Still fails

2. Issued DBSS FREEPROCCACHE - still fails

3. Added + '00:00:00'    -  still fails

4. Took code out...

Hi,

No, as I said before "Certainly in the code snippet I posted at the top there are no NULLs involved.".

I like your other suggestions though...I'm trying them out now.

Thanks for...

The records I am updating are NULL prior to the update. Afterwards, any row that gets updated will have a non-NULL value. So, I can't see why this would be...

I do have comments in the code (although they're not near the bit its complaining about) so I'll check this out tomorrow (I'm at home at the mo).

Thanks Steve.

I'll reply if...

I never knew about that sproc. Fantastic.

Thanks geezer!

Ah right, I understand now.

Sorry, can't help you though!

SQL Server 2005 is currently beta software so it is bound to be buggy, and it is. There have been literally thousands of issues/bugs raised with the beta releases up till...

You need to capture all the queries that are fired against your server. SQL Server Profiler is the best tool to do this that I know of.

This is not a...

Hi,

Are you an MSDN subscriber? If so you will be able to get it from MSDN Subscriber downloads.

If you're not then you're not permitted to use it anyway!