Jay,
I was not able to VALIDATE the DATABASE using your first method. However, I created a new database and added the tables to it manually and recreated the relations among them. I copied and pasted the stored procedures as you suggested. So it is back to normal now. You are right that I should backup my database more frequently.
Thanks also for your second reply with more tips.
Gratefully,
Dawa
Dawa Tsering
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature