April 20, 2011 at 1:35 pm
Hi all,
Is there any way which is better than adding a default column to the _CT table with the value of SUSER_SNAME() to get the user who has changed the data of the table?
Pramod
April 20, 2011 at 1:49 pm
Assuming you are using windows authentication this is a pretty efficient way of doing it and takes away any requirement for developers to "remember" or potentially manipulate their code.
April 20, 2011 at 2:35 pm
I agree, but I would choose to use ORIGINAL_LOGIN() instead of SUSER_SNAME() to provide for cases when impersonation is employed.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply