managing access to multiple stand alone installations

[masqazi]

hi i have same application with database installed in different cities, each one stand alone. the reason is network connectivity is very poor. with this, i have to manage user access in all the above installations seperately. i am facing delays / time waste with maintaining same access / password at all locoations. any suggestion..

[masqazi]

one of the solution is see is transactional replication with updatable subscriptions...but i can see microsoft is going to stop it in future the problem with triggers is that the network link may not be up all the time

[SilimSayo]

I'd say do the transactional replication for now. Then start planning for a more robust application e.g. one central database accessible over the web. Develop the web app such that very little data has to travel over the web at a given instant.

[bsdtux]

If you are using SQL Server 2008 policy based management might be a solution. But again I think this was something introduced in SQL 2008.