Lowell,

This piece of code has been gold for me in a couple of other triggers. Thank you again.

The instance I am having issues with at this time is using it at this time are using it at the table level. I'm using it for "AFTER INSERT, DELETE, UPDATE" at the table level. Nothing is returning for:

@SCHEMANAME

@OBJECTNAME

@OBJECTTYPE

@COMMANDTEXT

@EVENTTYPE

Was hoping the @COMMANDTEXT would at least return what sql statement was run for those events.

Any suggestions?

Thanks again!