<div>
What's a linked server? How do I do that?<br />

</div>


What's a linked server? How do I do that?


<div>
What's a linked server? How do I do that? Let me know if you need more points for that.<br />

</div>


What's a linked server? How do I do that? Let me know if you need more points for that.


<div>
a linked server is a remote database which you can connect to your sql server and use it as local.<br />
You can create a linked server by using Enterprise manager. Open your server, then open Security and there is a folder called Linked Servers. If remote server is SQL Server then it is easy to add - choose SQL Server from teh dialog box, and as name of the linked server enter the name or your remote server. Then in your queries you can use the following syntax to refer remote tables:<br />
remote_server_name.remote_<wbr />database_n<wbr />ame.dbo.re<wbr />mote_table<wbr />_name<br />
<br />
here if dbo is not owner of the remote table you must change dbo with the appropriate user name.<br />
Read in books online about linked &nbsp;servers - hope this helps<br />

</div>


a linked server is a remote database which you can connect to your sql server and use it as local.
You can create a linked server by using Enterprise manager. Open your server, then open Security and there is a folder called Linked Servers. If remote server is SQL Server then it is easy to add - choose SQL Server from teh dialog box, and as name of the linked server enter the name or your remote server. Then in your queries you can use the following syntax to refer remote tables:
remote_server_name.remote_database_name.dbo.remote_table_name

here if dbo is not owner of the remote table you must change dbo with the appropriate user name.
Read in books online about linked  servers - hope this helps


<div>
<div class="content wysiwyg-content">
I know how to use triggers to update another local table in the same database. But can I use triggers to insert a record to a table in a remote database when a local table is being updated/inserted? How and what do I need to do?
</div>
</div>


I know how to use triggers to update another local table in the same database. But can I use triggers to insert a record to a table in a remote database when a local table is being updated/inserted? How and what do I need to do?

Use Trigger to Update Remote 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.