<div>
Create a Linked server on sqlbox2 which may see all the tables on sqlbox1. No need to create a view.
</div>


Create a Linked server on sqlbox2 which may see all the tables on sqlbox1. No need to create a view.

<div>
Well for our needs, we need to create a view.
</div>


Well for our needs, we need to create a view.

Fay A

<div>
Fay, you're repeating your question: <a href="https://www.experts-exchange.com/questions/29093530/trigger-to-create-a-view-when-table-is-created.html?anchor=a42528210&notificationFollowed=206199252&anchorAnswerId=42528210#a42528210" rel="ugc">https://www.experts-exchange.com/questions/29093530/trigger-to-create-a-view-when-table-is-created.html?anchor=a42528210&notificationFollowed=206199252&anchorAnswerId=42528210#a42528210</a>
</div>


Fay, you're repeating your question: https://www.experts-exchange.com/questions/29093530/trigger-to-create-a-view-when-table-is-created.html?anchor=a42528210¬ificationFollowed=206199252&anchorAnswerId=42528210#a42528210 [https://www.experts-exchange.com/questions/29093530/trigger-to-create-a-view-when-table-is-created.html?anchor=a42528210&notificationFollowed=206199252&anchorAnswerId=42528210#a42528210]

<div>
yes, I would like to get more attention to the question that I got in return by posting it differently.
</div>


yes, I would like to get more attention to the question that I got in return by posting it differently.

<div>
<div class="content wysiwyg-content">
I am trying to make a trigger (create/alter and delete) when a table is created on database1 on sqlbox1 then I want a view of this table to be created on database2 on sqlbox2 (a different database box)<br />
<br />
any ideas?<br />
<br />
thanks.
</div>
</div>


I am trying to make a trigger (create/alter and delete) when a table is created on database1 on sqlbox1 then I want a view of this table to be created on database2 on sqlbox2 (a different database box)

any ideas?

thanks.

create a trigger

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

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.