Can Trigger do this?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

arun.sas SSChampion Points: 11831 More actions · Answer 1

[quote-0Is there a way to find out which program did that using Trigger?[/quote-0]

Add the columns of the following in the main table to avoid the trigger for this particular case,

1)user name by default suser_sname()

2)user_id by default suser_sid()

3)last modification date by default getdate()

Gives you the details of the data modifiers,

The new column not possible in the existing tables then uses the update trigger.

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 2

Try running profiler with filter in textdata for this table.

MJ

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

A server-side trace might be a better way to go than Profiler as Profiler tends to have a larger perfomance impact.