Hi, I restored a sql2000 database in sql2008 and set compatibility level to
Next executed DBCC UPDATEUSAGE (0) and DBCC CHECKDB. Ansi_nulls is Off.
Now, my problem is in a update trigger which contains an instruction like
from Inserted I inner join
Deleted D ON I.Id=D.Id left join
Invoices inv ON I.IdInvoice = inv.Id
where inv.SomeValue > 1
Now I know that it isn't a great query but it's just an example.
The weird thing is that when this query executes and there is NO Record in
the table Invoices to match with I.IdInvoice, so inv.Somevalue is Null, the
query returns the record being updated. Something Like null >1= True?
Even stranger is that I have a similar Database en sql2005(Comp. Level 80)
which after restoring it in sql2008 and doing the same steps works CORRECTLY.