I have a publisher with multiple publications and all of the publications
are working fine. Then I set up a new publication base on the previous ones
and now it's giving me this "Invalid column name.." error. I've tried
reproduct this on the Northwind database and created several publications.
They all worked fine, until I created a new one with the following extended
SELECT <published_columns> FROM [dbo].[Employees] INNER JOIN
[dbo].[Orders] ON [Employees].[EmployeeID] = 2 AND
When I go and run the snapshot agent, it gave me the error:
Invalid column name 'EmployeeID'.
(Source: <server name> (Data source); Error number: 207)
Obviously, EmployeeID exists. Why would this error occur? Also, now all
other publications on the same database is giving me this same error when I
try to generate their snapshot. Is this a * BUG?