Does this issue solved in SP3a (SQL Server 2000)

[Goudarz]

Hi,

I had a problem and I guess this bug solved in SP3a. My problem is:
I have two table in SQL Server 2000 and they both have a key field which relate to each other through this field. I made a enforcement relationship between them. Every time I changed value of key field in Mail table, all related records in Detail table was changed. One time, value of one of my records changed incorrectly (Not key field). Of course this happend under low memory conditions. And not happend once again.

Please tel me if this can relate to SQL Server 2000 and can solve by installing SP3a?

P.S. I don't install any of servic packs

 

[Goudarz]

Maybe you think this question, is belong to SQL Server forum, But I did it with VB so ask it here!

 

[johnwm]

Read faq222-2244 for guidance on forum usage as this is off-topic for this forum (VB5/6). Try forum962

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'