Replication TO MS SQL Server is better (only) handled with DB2 Tools.

ansz5 (7/2/2008)

---

I took a full backup of the db to be replicated and restored on server to be configured as subscriber.Then I configured Transactional replication with updatable subscriptions, Immediate updating,push...

vsjayashri (7/2/2008)

---

hi

INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=c:\test\Test.xls;',

'SELECT id,col1 FROM [Sheet1$]')

SELECT id,col1 FROM temp_test

This works fine,

When I open my excel it is inserted in a1,b1 cells.

I...

sead.j (7/2/2008)

---

Steve, you're right, but this is not a key thing - it can be Customes instead of Employees if you like... the problem is the same... and is not...

Erik (7/1/2008)

---

My ops team is going to move the physical storage of our SAN into a

different rack. They will be powering down my dedicated distributor,

used for brokering transactional replication...

look in "View details" menue of the snapshot agent.

sead.j (7/1/2008)

---

It's not homework, but it is...

are you sure the initial snapshot was delivered successfully ?

try:

UPDATE d SET Observe.Ob_Date = '2008-06-30 00:00:00'

FROM Observe d

INNER JOIN

(SELECT MAX(Observe.Ob_Date) AS OBDATE, Quest_Current.Qu_Ref, Quest_Current.Qu_Text,...

Kingsleen Solomon Doss (7/1/2008)

---

hi

The Parameter i am getting is (Name1,NAme2,Name3) I need to join the parameter as ('Name1','Name2',Name3') how can i do...

ajithrulz.j (7/1/2008)

---

hi all

i get the following error sometimes and because of this error the connection is getting closed during transaction.

i am using SQL Server 2005 jdbc driver and tomcat 5.5...

sead.j (7/1/2008)

---

USE Northwind

SELECT Title, Customerid

FROM Employees

CROSS JOIN Orders

So, what I wanna do is to get the same results but using subquery (subqueries) and/or UNION operator(s). Also WHILE loops are permitted...

I would go a bit further and use a "calendar" table. Pretty much like the tally table but with the dates already stored 😉

This is how you are supposed to do it: http://msdn.microsoft.com/en-us/library/ms345408.aspx?s=1

Merge replication add triggers to all replicated tables if in addition you have custom triggers you could definitely experience a performance penalty. You should check also if rplication is using...