Yes, triggers will always be fired if you have return it on an insert statement. It is independent on whether you are using cursors or using any other alternative to insert rows in a table..

Try using "no count off" and writing an insert or update statement in trigger. It will show you the rows affected