thanks dennis,

I saw the other code from replicationanswers.com but I'm trying the code above first..

anyway, the problem im encountering is the first part which is:

--5. On node B,...

Thanks to all of you, now we are using one database per tenant.

Anyway, I use sqlpubwiz to generate the sql file that will generate (when called) the database objects including...

Kenneth/GSquared, yes I'm trying to get rid of the schema parameter thing on our next meeting and you're right there will be so many things that are not yet apparent...

Thanks guys, I really appreciate all of your answers and suggestions.

Anyways, the company that I'm working for wants to build a multi-tenant data architecture using SQL Server 2005, and...

Because the database will be handling different companies, with their own schema. They actually wants a multi-tenant DB but the problem is that they don't want specific "logins".

Thats why I'm...