<div>
check for OpenRowset in the BOL (books on line) to see if you can use it. You could then schedule a query to run once a day.
</div>


check for OpenRowset in the BOL (books on line) to see if you can use it. You could then schedule a query to run once a day.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I have a view on one MS SQL server that I want to be copied to a table on another MS SQL server once a day. I'm not sure whether to use replciation or not. When I did is required me to replicate all the tables that the view referenced which is not what I want.<br />
Any help much appreciated.<br />
Thanks
</div>
</div>


Hi,
I have a view on one MS SQL server that I want to be copied to a table on another MS SQL server once a day. I'm not sure whether to use replciation or not. When I did is required me to replicate all the tables that the view referenced which is not what I want.
Any help much appreciated.
Thanks

Copy data from a MS SQL View to a table on another SQL server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.