Replication is not a good choice to do that because the overhead that you are going to put in production is not necessary. If you use transactional, for example your...

Todd,

You can subscribe 2005 to 2000 ONLY if 2005 is a PULL subscription. The rule always is that the distribution agent should be the Highest Version in the topology if...

Sergiy (10/3/2007)

---

Would not UPDATE() work in INSERT case?

It will work perfectly.

Yes, it will return "TRUE" for every column, but what does it change?

We still have to run the same...

Oh Boy ... This is probably going to be a big one 😀

Hehe, R E A L L Y ????

Can you...

RD (10/3/2007)

---

I'm quite the junior scripter so any extra info would be appreciated.

1) are u saying use 2 triggers, 1 for update, 1 for insert?

2) where would @@rowcount be used?...

Make sure that SQL Server Account has rights to read and execute the app on that folder.

declare @variable varchar(2000)

set @variable = 'select * ...from' + @server + '.' +......

exec (@varible)

NOTE that is_subscribed does not work in all cases

sqlquery (10/3/2007)

---

Hi , I have two publication of two different database and they are replicating data to other server but both are sending data to same database with transactional replication...

Andy Warren, One of the Site Owners has done it in the past:

http://www.sqlservercentral.com/articles/Replication/noncontinuousreplication/111/%5B/url%5D

Bruce,

continuos mode is really not that "continuos" if you look in the profile it is actually polling. I am not sure about your "latency" requeriments which is what really counts....

That makes us 2 😉

Replication is a bad choice for doing that. You should use BCP, SSIS or SMO instead.

Try :

SELECT E.id

, E.postedOn

, E.code

, E.title

, MIN(CASE WHEN X1.extensionRef = 'field1' THEN X1.value END ) AS field1

, MIN(CASE WHEN X1.extensionRef = 'field2' THEN X1.value END ) AS field2

.....

FROM...