We dont want to setup replication.. we would like to use the current setup.

When both database are on same SQL instance ( that is when the view is created without calling linked server ) we dont face this issue