Transactional Replication

[qsac]

Here is what is happening, any help as always is greatly appreciated.

I can get a snapshot of all tables but one. If i leave this table out the snapshot complets and the replication works.

If I add that table, it freezes the snapshot and returns that it has been inactive for 10 minutes.

This is a small table.

ANy Ideas?

Corruption?

Thanks,
Q

 

[AccordingToDale]

Do you have any row or column filters on the table? Any join filters?

Dale

 

[qsac]

No Filters, good thought though.

I am so baffled by this. I have spent hours on this.

any additional help would be awesome.

Thanks,
Q

 

[qsac]

I also noticed that blocking is occuring. I dont get why. This database has not outside connections.



Q

 

[AccordingToDale]

Is there any possible way that this table may contained some orphaned records?

Dale

 

[qsac]

Not to my knowledge.

The table has no foreign keys to or from. So even if a record was "Orphan" the system would not know.

Q

 

[AccordingToDale]

Got me on that one then. My replication experience is somewhat limited.

The inactive error is the only error you get?

Dale

 

[qsac]

Unfortunately it is.

And it is inactive casue the block never goes away.

So fusterating.

Thanks for trying


Q