>I am trying to make a view in SQL server that takes data from two diferent databases. The two tables are exaclty the same and what i need it is a union between them.
>
>The query designer doesn't allow me to do so, so I'm wondering wether this is possible or not.
>
>any clues

You have to use SPT in order to do this. You can't use DBSETPROP() to set up the SQL statement, because the property is read-only.