<div>
Here is some links I found that might help you.<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms189799.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms189799.aspx</a><br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms190273.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms190273.aspx</a><br />
<br />
<a href="http://ss64.com/sql/" rel="ugc">http://ss64.com/sql/</a>&nbsp; &nbsp;( 2005 Sql Commands A-Z)<br />
<br />
Hope this helpds
</div>


Here is some links I found that might help you.

http://msdn.microsoft.com/en-us/library/ms189799.aspx [http://msdn.microsoft.com/en-us/library/ms189799.aspx]

http://msdn.microsoft.com/en-us/library/ms190273.aspx [http://msdn.microsoft.com/en-us/library/ms190273.aspx]

http://ss64.com/sql/ [http://ss64.com/sql/]   ( 2005 Sql Commands A-Z)

Hope this helpds

<div>
The link has an example of a Trigger:<br />
<br />
<a href="http://www.dotnetspider.com/resources/19073-INSERT-UPDATE-using-Trigger-SQL-Server.aspx" rel="ugc">http://www.dotnetspider.com/resources/19073-INSERT-UPDATE-using-Trigger-SQL-Server.aspx</a><br />
<br />
THanks
</div>


The link has an example of a Trigger:

http://www.dotnetspider.com/resources/19073-INSERT-UPDATE-using-Trigger-SQL-Server.aspx [http://www.dotnetspider.com/resources/19073-INSERT-UPDATE-using-Trigger-SQL-Server.aspx]

THanks

<div>
<div class="content wysiwyg-content">
I would like to create a trigger in a SQL 2005 database to run a table update script that I have created. &nbsp;I would like the trigger to execute my update script whenever data is inserted or updated into the table. &nbsp;It should not be very complicated.<br />
<br />
Could someone please share with me the syntax on how to create such a trigger? &nbsp;I'd be grateful.
</div>
</div>


I would like to create a trigger in a SQL 2005 database to run a table update script that I have created.  I would like the trigger to execute my update script whenever data is inserted or updated into the table.  It should not be very complicated.

Could someone please share with me the syntax on how to create such a trigger?  I'd be grateful.

writing a basic trigger in SQL 2005

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.