Can python function be called by a SQL server trigger?

Question

I have a database in MS SQL Server 2008 that has 3 tables. I want to create a trigger for INSERT, UPDATE and DELETE for each row for these tables. For the trigger function I want to call a python function. The python script needs to write some of the columns from the row for which the trigger occurred and write it to a socket. I checked on the net but could not find how the python function can be called as a trigger function.

Edit: Or is there a way the trigger procedure in SQL can do this itself? Can it act as a TCP server and write the trigger data to the socket?

Cédric Julien · Accepted Answer · 2011-11-22 14:18:16Z

4

As explained here you can attach some .NET methods in SQL triggers, and then use IronPython to code your trigger, but it will cost you in term of security and performance.

You can also use Database Email which is able to send an email which the content of what you need to catch, and grab it elsewhere in your own mail server.

answered Nov 22, 2011 at 14:18

Cédric Julien

81.2k16 gold badges131 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lalitha Over a year ago

Is there a way the trigger function itself can do this? Can it work like a TCP server and keep posting the trigger data to the socket?

Collectives™ on Stack Overflow

Can python function be called by a SQL server trigger?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related