Hi - All
I need to whilst working on one database (sql Query Analyser), create a view in another database and store it in the other database. I am thinking that this will be a distributed query - advice please.
Was trying to run something like
Use <Database A>
CREATE VIEW <Database B>.dbo.Test_View AS select * from <Database B>.dbo.<table>