Posted by serge on 09/22/05 04:08

Can you create an UPDATE TRIGGER and use some type
of code to figure out which SP just updated the current table?

If not how can i achieve what i want?

I tried to run SQL Profiler and i don't understand why i can't
simply have the Profiler filter events only for the specific database id
and the table's object id i chose?

What am i doing wrong with SQL Profiler? I was testing this
through SQL EM. I had the filters chosen for a specific database id
and a specific table's object id, yet when i open another table SQL
Profiler captures that information too.

Thank you

• Next in forum: Re: Dynamic data elements for a data collection application
• Prev in forum: Re: Dynamic data elements for a data collection application
• Thread view: Any way to find out which SP is updating data in a specific table?

[Reply to this message]