We want to call some python from tsql on sql server 2008.

The python script is fully developed and works great. We cannot trigger anything from the client app because it is closed source and cannot be modified.

So we have full access to SQL Server (2005 and 2008), and can see that "trigger" record get inserted... and need to fire our python code when that happens.

Rather than using xp\_cmdshell to launch an old fashioned python script, we would like to do this as "sql native" as we can. (xp\_cmdshell will work, but is scary at a few levels.)

What is the path to do this?