One that would take my dogs for a walk when the weather is nasty (I still would prefer to do it myself in nice weather)!

Or take them out in the...

OH I absolutely agree.  Column level permissions is the last thing I will do for security, only to be done when all else has failed.  Was just thinking if you...

Which value do you want to keep and which to discard?  How do you know when it is correct?

By the definition of a duplicate record there are none in the...

Couldn't you do column level permissions on the table and select straight from it?

Try distinct select and not select back the column that has the different data in it?

Finaly ended up calling MS PSS after this happened a few more times last week.  Turns out this is a bug fixed in SP1 relating to BLOB's.  What is weird...

Might also want to check the Windows event viewer for items around the same time.  It does explain why, someone or the OS decided to shut it down, as opposed...

Is there anything in the error logs?  Primarily the last few lines in the previous error log and the first one in the current one would be of interrest.

I had profiler running saving to a file for 2 months collecting over 15 million stored procedure calls, no visible effect on performance.  I imagine if your server is closed...

SQL Profiler.