> I'm having a major beef with Management Studio Express when it comes to
> editing Views that contain a UNION statement. For starters, it can't
> display the View, which I guess is OK, the old tool couldn't do that
> either. But, the syntax verification doesn't work either.. I get an
> "Incorrect Syntax near UNION" error each time. But, if the syntax is
> valid, saving is no problem.. and neither is a select on the view.
>
> Why does MSE choke on a union even if the query is valid? I can understand
> the issues regarding displaying a query that contains unions, but if valid
> syntax is used, why can a query not be syntax checked?