SQL Server Insert Row into Table as Trigger

Yes, I can see how such a trigger would be a very convenient thing to have. You might want to leave a vote on the respective feature request: Trigger workflow when new line added in SQL