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 |
|
jamiegirl764
Starting Member
30 Posts |
 Posted - 2001-10-29 : 15:31:15
|
| In SQL Server 2000, I'm planning to use SQL authentication instead of Windows Authentication. I need to keep and display a log of which user has done what with whatever data. For example, when the user inserts a new record how would I reflect that that user was the one who inserted the new record??? Would I create a column in the table where the data is being inserted and use the 'SYSTEM_USER' function upon insert??? Or would I have to use a trigger that will do the insert of the user??? When I use one of the above options will I still be able to query it so that it is reflected in the form??? Any tips would be appreciated... thanks in advance!!!Jay |
|
|
|
|
|
Selecting & Inserting the current user???