Thanks Grant for all your help.

Appreciated!

Hmmm.... you are right about the flexibility part. Two separate DBs gives you lot of flexibility and control too.

I have already started making up my mind to go for this...

Thanks for the prompt reply.

The solution you have provided will be perfect. But what if we want to have some stored procedures that acesses the DB tables from both the...