Hi Guys,

We use this generic lookup table design. Our team has agreed that it is a good replacement for the reference tables with two columns.

We enforce RI using the  check constraint with...

We have experienced similar problems.

I always suggest to drop and recreate the stored procedures that drags..and it worked 99%.

Thanks for your tips Mr.Jones.

Baskar