Using a regEx search CLR (we already had one inhouse) does the job. Thanks for pointing me in the right direction.

the auto-set for affinity mask is turned on, so that's not it, I guess.

I changed everything to run DBCC manually and it's fine, but it's annoying that a) it's been...

Did anyone ever find/post a solution for this? I've encountered this problem occasionally but now every single check-integrity job on a particular server is failing (with completely useless information in...

We have individuals loaded into a DB with actual birthdates of 1/1/1900. (Granted, most of them aren't around anymore, afaik). There are also records loaded into the DB with...

thanks for the responses.

I don't think I'm explaining this well.

I understand that SQL Server treats blanks as '1/1/1900', at least in display. What I don't understand is the reverse, why a specific...

I'm specifically inserting a date value of '1/1/1900'. Not blank; not zero length; 1/1/1900. (the results are the same for datetime as well as smalldatetime, incidentally.)

It's getting treated as blank....

Not really. The server has 8Gb memory and not an inordinate amount of activity.