tag:blogger.com,1999:blog-7900840635064993788.post6417633258564573799..comments2020-08-12T17:48:44.648+05:30Comments on Bits from the software front...: SQL Server 2005 & A Global TriggerNitin Koshyhttp://www.blogger.com/profile/14545332672510258866noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7900840635064993788.post-70549337997021151882010-02-09T20:48:00.712+05:302010-02-09T20:48:00.712+05:30@@PROCID doesn't work in a CLR trigger.@@PROCID doesn't work in a CLR trigger.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7900840635064993788.post-41192946148621292522008-10-13T22:21:00.000+05:302008-10-13T22:21:00.000+05:30Hmmm... shouldn't that be sys.triggers and, I'm no...Hmmm... shouldn't that be sys.triggers and, I'm not entirely sure that that would work on 2005 without privs.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7900840635064993788.post-30791870803811452622008-09-05T21:08:00.000+05:302008-09-05T21:08:00.000+05:30this sql to get the tablename is a bit simplersele...this sql to get the tablename is a bit simpler<BR/><BR/>select object_name(parent_obj) as TABNAME from sysobjects where id = @@procidAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7900840635064993788.post-17290889920676464422008-04-01T14:07:00.000+05:302008-04-01T14:07:00.000+05:30Hmmmm, trying to find the table name for a trigger...Hmmmm, trying to find the table name for a trigger called as a result of action taken by another trigger (on another table). <BR/>IOW: insert trigger on table A inserts data into table B which causes table B insert trigger, how to get table B name from table B trigger in this case)Anonymousnoreply@blogger.com