You could do what you want to do and it will work just fine. There are many examples to be found of simple trigger code like you need.

I would still do this using a sproc personally. If you have someone do the insert using SSMS then that isn't via the app and you either wouldn't need the trial license or the person doing it would know that it is required and simply use the sproc in the first place because they were a support staffer. This is known as production control. :w00t: