I do have separate customers and that’s my prime reason for creating a database for each, to ensure they never see each other’s data. I realise that I can code...

Can you advise how, if I go for the multiple database option I can best keep the structure and sp's in sync? Can this be automated?

Also what do I need...

Firstly I want to say thank you for all the information you’re giving me, although I’ve read many forums, this is the first time I’ve actually posted and your assistance...

Real questions for a commercial system I'm developing. Ordinarily I'd create a single table with a type mapping, and go for the multiple database option within a single instance. But...