You probably need to go back and check your filter and join clauses. This is where you will have set up the way you want your data defined for each...

You could try to import the customers to a working table - with no identity column just use an INT to store the existing id.

Then you write a query to...

Salaried for 40 hours and most of the time that's how it works out.

I work with the principle that if I (we, the dev team) have stuffed it up,...

Sounds like a permissions problem with the user you are trying to create the pull subscription with. Try checking your user permissions.

Could it be that because there is no data selected the BCP isn't sure how to handle it or that the schema it is expecting in the file doesn't match...

The triggers I put in place to audit the updates to the table I am conerned with revealed that there were no updates occuring that were not expected.

So, what happens...

Interesting stuff thanks Pedro but may not be relevant as I am using SQL 2005 - so obviously no SP4 just yet.

Might be very useful for other projects we have...

As per my other post regarding the differences between replication in 2005 and 2000, this is a known issue with a simple resolution

http://support.microsoft.com/kb/917476/en-us

The issue of the excessive data on intialise was covered by the following article

http://support.microsoft.com/kb/917476/en-us

This article refers to a known issue with merge replication

OK, I understand your table links - franchise has an ID which is the FK of other tables in the replication scenario.

I suspect that you need to find out exactly...

I take it from your post that the developers have views, SPs and tables that are not related to any applications that use the database - or have I misread...

Just to make sure I am clear on this.

You make an update to your filter column.

Then you cascade those changes down to all of the related records.

Can I ask why...

What kind of replication are you doing?

Snapshot, Merge or Transactional?

At a guess (because I've never tried this before), take a look at the permissions of the "user" doing the connecting. A "could not connect" message is typically about permissions...

Is it not possible to put some conditional logic around the update of the datemodified column to only update when the right conditions are met (deleted versus not deleted?).

Also, I...