Duplicate post, see responses at http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4011&FORUM_ID=8&CAT_ID=1&Topic_Title=0+Rows+Updated+%2D+NOT&Forum_Title=T%2DSQL

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Nothing that sticks out in my miond off hand. Could be one of the other settings of the server or something else in your code that changed the way it...

It would be nice but unfortunately the icon is based on last completion and won't update until you cancel then they will complain their task was canceled and want to...

Depending on the type of replication this is not an issue. In fact it should keep looping until it fails then it will restart or you stop it. If you...

Gotcha. Will have to look a bit for it but you will need to use a DTS package or job with active scripting to read each line and put in...

What are the steps you are doing?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I remember when we moved from Oracle 7 to Oracle 8i I got this problem and am looking for what fixed it. I beleive I just reinstalled the client software...

!= means does not equal, SO I am checking to make sure the value is not alreadys set, and if is we will not update as is not needed.

"Don't roll...

Yes a trigger sounds best however the flow here lost me. Can you write out the flow and provide the DDL of the tables so we can take a look...

Simply done this way on my server. First I installed the Oracle client with the OLE driver. Setup a namedinstance in NET8 so my server will know how to find....

So think about the break down and how they logically apply to each other and build tables that express it out. Then normalize by thinking about where items are used...

SET NOCOUNT ON

SELECT * FROM xtext

TRUNCATE TABLE xtext (

[user_id] [numeric](8, 0) NULL ,

[f1] [varchar] (100) NULL ,

[f2] [varchar] (100) NULL ,

[f3] [varchar] (100) NULL ,

[f4] [varchar] (100) NULL ,

[f5] [varchar]...

Try this, based on what you have provided this is the only possiblity I see.

SET NOCOUNT ON

CREATE TABLE xtext (

[user_id] [numeric](8, 0) NULL ,

[f1] [varchar] (100) NULL ,

[f2] [varchar] (100)...

The only item I find on this is http://support.microsoft.com/default.aspx?scid=kb;en-us;Q300180 but I don't think that is it. You may need to set Profiler up to trace the events for the merge...

Looks like MSDE merge modules are on the SP2 cd only. Check out http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Fservicepacks%2Fsql%2F2000%2Fsp2readme%2Easp

And I find no merge modle for the MDAC but several statements one may be available in...