Exec Console using TSQL SP?

Question

I have a console application (in C #) for reading data from an SQL server (Microsoft SQL 2005) and writing data to an SQL server. Now I need to add a trigger to the table to start the console application when any data row is changed.

Not sure which SP on a Microsoft SQL Server (2005) launches a console application? and how can I pass the result from the application? Will they be run as synchronous or asichi estates? Is there any resolution issue that I have to configure?

Answer 1

, . , xp_cmdshell CLR. Service Broker SEND , , .

Answer 2

xp_cmdshell , .

#, , SQLCLR?

Answer 3

. , ? , , , . , , .

? , , SQL.

Answer 4

, . - , .

, , , , .

, , [LastUpdatedDateTime] GetDate(), . . , .

Answer 5

, , . SQL-, ? , / , .