My company is using a SQL server 2012 in combination with an IP barcode scanner. The software bundled with the barcode scanner insert records in a specific table in a SQL Server database. So far everthing works fine.
I would like to run some code (in my case VB) or an external .EXE every time a new record is inserted. So I am basically looking for a solution/service/task that monitors my table and fires an exe on insert.
I have looked at a trigger and EXEC MASTER XP_CMDSHELL but our DBA wont let me do anything on the SQL server.
Who's can point me out towards a proper and stable solution ?