Dylan Davis
Ten Centuries
Points: 1283
More actions
October 18, 2005 at 2:39 pm
#89489
Pretty much exactly as the subject says: I want to figure out the name of the base table from within the trigger.
Thanks in advance!!
Ninja's_RGR'us
SSC Guru
Points: 294069
October 18, 2005 at 2:43 pm
#598066
SELECT Object_name(parent_obj) AS TableName from dbo.SysObjects WHERE id = @@procid
October 18, 2005 at 2:59 pm
#598070
AWESOME! Thanks for the help!!!
October 18, 2005 at 3:01 pm
#598072
HTH.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply