<div>
Thanks for that though i must admit the exe was my plan b - as i was going to use the exe to hit a url/webservice.<br />
<br />
But in the interests of avoiding that extra layer of maintenance is there anything simular for calling a url / webservice?
</div>


Thanks for that though i must admit the exe was my plan b - as i was going to use the exe to hit a url/webservice.

But in the interests of avoiding that extra layer of maintenance is there anything simular for calling a url / webservice?

<div>
No there isnt any way of calling url or webservice.
</div>


No there isnt any way of calling url or webservice.

<div>
what about using a sql agent or alt sql?
</div>


<div>
I guess, not with sql agent too, and i am not sure about others.
</div>


I guess, not with sql agent too, and i am not sure about others.

<div>
actually the 2nd option of using your application exe is better way i think.
</div>


actually the 2nd option of using your application exe is better way i think.

<div>
<div class="content wysiwyg-content">
Can i use a trigger in SQL 2005 to hit a url, call a webservice or update a file?<br />
<br />
And if not can i get a trigger to run an exe located?
</div>
</div>


Can i use a trigger in SQL 2005 to hit a url, call a webservice or update a file?

And if not can i get a trigger to run an exe located?

Can i use a trigger in SQL 2005 to hit a url or update a file

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.