I would implement a transactional replication.

been pune the (publisher, distributor) and mumbai the suscriber. I would chosse continous update.

The read and Write operation would be routed in the appication with...

I always wanted to share my code snippets and templates. Really nice idea. Thanks.

Should I update this for SQL2005 ?

Can you put the link to buy the software ?

🙂

If you server host more than one application, you can have an instance in the cluster by application. On this case you archive failover and scaling out. (1 DB by...

nice trick.

use this

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

you will need to develop further.

It does not make send that sub server push the data to Main data server, they supose to pull ? . right ?

Can you give specification for your server ?

are you doing push or pull suscription ?

how many machines are involved ?

if you answer does question it would help.

"But there doesn't seem to be anything to suggest that you can stick your distributor on your subscriber."

You are completed right. You can do that, the distributor takes the data...

in other news http://www.joelonsoftware.com/items/2008/01/29b.html

don't be mad 🙁

A collage degree on Computer Sciences will not prepare you to be a DBA but will give you the tools to put oder in the Chaos when you become a...

Thank's Paul Ibison good article , thank god this have been greatly improve in 2005.

some info http://msdn2.microsoft.com/en-us/library/ms143550.aspx

My experience on merge replication ( if you have a database with to many...

Agree with Ninja, but if you can;t after you get your resut do a

convert(varchar(10), datevalue , 103)

as in previous post, but after you get the reults, if not you...

The faster way to convert columns into rows is this make a cross join with a generic table that have one columns and as much rows as column you have...