Thanks Hanslindgren for the reply; and yes I agree interpreting rules for the normalization would be bit hard and quite subjective, and finding a tool that can analyze normalization rules...

Folks I am a seasoned programmer but relatively new in sqlserver world. I am amazed and really disappointed with the error handing quirks and transaction issues in sqlserver. I am already doing all...

Thanks for your help.

I tried it, but having a null value for the column (name of my table). Here is my sp which gets executed each time a insert, delete,...