What do you mean 'the delete does not delete'?
Fails with an error?
Hangs forever?
Completes but affects 0 rows?
Implodes the server and creates a black hole in the server room?
Something else?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability