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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy