<div>
<div class="content wysiwyg-content">
Hi - All<br />
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.<br />
Was trying to run something like<br />
Use &lt;Database A&gt;<br />
code<br />
code<br />
CREATE VIEW &lt;Database B&gt;.dbo.Test_View AS select * from &lt;Database B&gt;.dbo.&lt;table&gt;<br />
<br />
Thanks<br />

</div>
</div>


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>
code
code
CREATE VIEW <Database B>.dbo.Test_View AS select * from <Database B>.dbo.<table>

Thanks


Working on one database and creating and storing a view on another database

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.