Got you! Thanks again for your help.

Shark Energy, The identity seed value is increasing in the source which is around 89million while it stayed constant in the subscriber which was few thousand less than the source....

We only have 1 hr maintenance window and that's not enough. I looked at the link that you copied in the last post. That doesn't apply to me because I...

Replication has been running fine. It's just that we can not insert directly into tables in the subscriber db.

DB size is 56GB. We are replicating data from NY...

i know I can replicate views to table (only indexed views) and i know i can use a query to replicate to table. But my question is HOW? I could...

First of all thanks for your help guys. Let me clarify a bit more:

I only need to read current cycle. I haven't decided how the data will be inserted I...

I got you, thanks for your help.. By the way I just got a reply from a MVP on Microsoft's website too which is:

"If Listen All is set to No...

Thanks for your reply... I think you are right IPAll will have only that port active for connection when working with Fixed ports ASSUMING that we will have Enabled set...

Thanks for all the help you guys gave me. Right now I am being pulled into another high priority task and can't continue to investigate this. You guys gave me...

To answer Steve: I checked sysdatabases table there is nothing weird there. It's just regular databases that I see in enterprise manager.

SQLBill: We don't have any applications on that server....