Hi Lee,

> I want to log changes in certain tables to a change_log table inside the same
> database and the SP logic, etc is no problem, but..and it seems this must be
> obvious, but how can I determine the name of the table that a running trigger
> applies to?

No way via context variables. You have to hard-code the table name
inside your trigger, which is usually done by the trigger code
generation facility, if you want to have that automated. ;-)


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/