"Query Builder" <querybuilder@gmail.com> wrote in message
news:1148668661.323711.304010@38g2000cwa.googlegroups.com...
>I have a complex query I use to populate reports. I need to move the
> reporting environment from actual production database that gets updated
> frequently. I have converted the reporting query into a view that pulls
> information from many tables with complex joins
>
> In my reporting databases, i have a simple table with the exact fields
> in my view.
>
> So here is the situation.
>
> Server A (Live production DB)
> Many tables
> View - V_abc (with complex joins and returns some columns)
>
> Server B (Reporting Server)
> View - V_abc (referencing T_abc with the same exact column on ServerA
> view columns)
> Table - T_abc (referenced by V-abc with the same column names)
>
> I am trying to set up transactional replicatin (as I need live data) to
> pull information from the Production Server A view and insert it into
> the reporting Server B db view (V_abc) which will place data to the
> underlaying table (T_abc).
>
> I keep getting the error message when I start the replication
> "Unable to replicate a view or function because the referenced objects
> or columns are not present on the Subscriber. - (Source: AGENT (Agent);
> Error number: 00000)"
>
> Its also dropping the View in ServerB.
>
> Is this even posible or am I just chasing ghost..???
>
> I would appreciate some help with this problem...
>