> I'm not sure that keeping all business rules in the database layer > is a good solution either. I'd rather keep the data integrity rules > IN the database, and off-load the TRUE business rules to the app server. > > The underlying determining factor being this in all my designs: > > Does the "rule" apply to ANY application that may access that piece of data? > Yes? Then it belongs in the database. > No? It belongs in the app server with the code for this particular > application. > Thanks Nuno, I think this makes more sense than the black and white arguments of the 'rules belong in the <insert your bias here>'. Jared