From: Alex_tring on
Hi,

I am setting up transaction log replication with a view to having a
failover/reporting server available (more reporting really as failures
are relatively rare). As such we are pretty much sending across
everything, including stored procedures.

Unfortunately we are getting a lot of syntax errors such as
"ORDER BY items must appear in the select list if the statement
contains a UNION, INTERSECT or EXCEPT operator."

which is strange as this stored procedure is totally valid on the
database that it has been sent from. Any ideas on how to help
From: Hilary Cotter on
I take it you are using transactional replication.

If this is the case can you post the schema of a typical object which
generates a syntax error on replication?

"Alex_tring" <alexays(a)yahoo.co.uk> wrote in message
news:d1cdf8d9-46d3-40f8-8a4b-f9468e497d9e(a)a6g2000yqm.googlegroups.com...
> Hi,
>
> I am setting up transaction log replication with a view to having a
> failover/reporting server available (more reporting really as failures
> are relatively rare). As such we are pretty much sending across
> everything, including stored procedures.
>
> Unfortunately we are getting a lot of syntax errors such as
> "ORDER BY items must appear in the select list if the statement
> contains a UNION, INTERSECT or EXCEPT operator."
>
> which is strange as this stored procedure is totally valid on the
> database that it has been sent from. Any ideas on how to help