>does anybody have a problem with CursorAdapter when Enforcing the RI in SQL Server 2k? error occured when deleting a record that violates the RI

Are you saying an error occured when you tried to delete a record and that would have broken the RI of the data? Isn't an error "violation of foreign key FK_______" what you would expect?

BOb