Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-14 : 01:20:00
|
| Duane writes "I want to audit record updates and inserts. This would mean, of course, that there would be two additonal columns in my table -- one for a datetime of an insert or update and one for the inserting or updating userid. On an insert, the default values for the columns would be used -- getdate() for the ChangeDate. What would I use to retrieve the userid similarly? On an update, a trigger would perform the same functions -- do I have to worry about recursive calls? -- the trigger will be updating the record." |
|
|
|
|
|
record change audit