Post reply

You are a database developer and you want to log..

  • July 29, 2003 at 2:15 am

    #176121

    You are a database developer and you want to log who makes a change to the database....

    I answered SESSION_USER which according to books online....

    Is a niladic function that allows a system-supplied value for the current session's username to be inserted into a table when no default value is specified. Also allows the username to be used in queries, error messages, and so on.

    Isnt this therefore the correct answer as well??????

  • July 29, 2003 at 4:05 am

    #467418

    The problem with this one and the others that are wrong is that they actually return the database username. For instance if an account is a dbo in the database they will get dbo instead of their actual login name. The one that is correct will return the actual user account and not the database username. They don't make this extremly clear in BOL but test each and you will see what the difference is.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply