<div>
Create a linked server with the sybase and then use open query to update the table in sybase.
</div>


Create a linked server with the sybase and then use open query to update the table in sybase.

<div>
This is how you can do it <br />
1.Create an odbc to the sysbase database <br />
2.sp_addlinkedserver<br />
Creates a linked server, which allows access to distributed, heterogeneous queries against OLE DB data sources. After creating a linked server with sp_addlinkedserver, this server can then execute distributed queries. If the linked server is defined as Microsoft® SQL Server™, remote stored procedures can be executed.<br />
3.Run Open Query to update the table <br />
4.Create a trigger on orignal table &nbsp;to include this openquery statement.<br />

</div>


This is how you can do it
1.Create an odbc to the sysbase database
2.sp_addlinkedserver
Creates a linked server, which allows access to distributed, heterogeneous queries against OLE DB data sources. After creating a linked server with sp_addlinkedserver, this server can then execute distributed queries. If the linked server is defined as Microsoft® SQL Server™, remote stored procedures can be executed.
3.Run Open Query to update the table
4.Create a trigger on orignal table  to include this openquery statement.


<div>
this is how you can do update in open query<br />
<br />
update openquery(LinkedServerName<wbr />, &nbsp;'select &nbsp;LAST_UPDATE_DATE from schemax.tablex &nbsp;where transaction_id = 1') set LAST_UPDATE_DATE &nbsp;= 'newvalue'<br />
go
</div>


this is how you can do update in open query

update openquery(LinkedServerName,  'select  LAST_UPDATE_DATE from schemax.tablex  where transaction_id = 1') set LAST_UPDATE_DATE  = 'newvalue'
go

<div>
<div class="content wysiwyg-content">
Is it possible to write a trigger on a SQL Server table that will update data in a sybase database?<br />
<br />
If so, how does one do it? what is the syntax<br />
<br />
thanks<br />
paul<br />

</div>
</div>


Is it possible to write a trigger on a SQL Server table that will update data in a sybase database?

If so, how does one do it? what is the syntax

thanks
paul


SQL server trigger to update sybase 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.