September 8, 2005 at 3:22 pm
Can anyone tell me if I can capture the users identity when placing a trigger on a file or column within sql server 2000. Can this same information be captured with SQL Profiler?
September 8, 2005 at 7:15 pm
what do you mean by when placing a trigger on a file or column ?
Amit Lohia
September 8, 2005 at 9:29 pm
Michael - Your question is not very clear - do you mean something like having a default constraint of suser_sname() on a column in your table where the insert/update is taking place ?!?!
**ASCII stupid question, get a stupid ANSI !!!**
September 9, 2005 at 7:22 am
I would like to be selective in auditing specific files (Tables) in SQL to record the user ID of all select,insert/update activity performed aginst a specific file, or ideally against a specific row and column within the specified table.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply