|
|
Posted by Erland Sommarskog on 03/11/06 20:43
Dan Guzman (guzmanda@nospam-online.sbcglobal.net) writes:
> Unfortunately, I don't have the original script or file I used to repro
> Ryan's problem. I changed both with the intention of including simplified
> versions with a bug report but I can no longer reproduce the error! I'm
> fairly certain this wasn't a procedural error on my part because I copied
> the script into a SQL 2005 window and it executed successfully.
>
> I suspect the problem may be data related for some subtle difference I'm
> now missing. The SQL script was similar to:
Case-insensitive collation on SQL 2000 and case-sensitive on SQL 2005?
Somehow, the only way I could see that this sequence could lead to
this error is that either the DELETE is incompletes with the incoming
data, or the incoming data itself has duplicates. I've seen many weird
bugs, but that DELETE would not have completed when the next statement
runs sounds a little fantastic to me.
But I've been wrong before.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|