Accessing the current User code

[Former Member]

In order to find out who the current user is, we used to (in SQL 2000) use $[user]. However, this does not appear to work when the database is SQL 2005. Does anyone know of a solution to this? (Our current objective is to create a log file showing changes to the price lists, as there is not standard audit trail in SBO – so any advice in this regard much appreciated).

[former_member583013 · Accepted solution]

I believe you are talking about using the $[USER] from within SBO.

The $[USER] should work regardless of the SQL Server version. To record the Pricelist change as and when it happen would have to be done using the SBO_TransactionNotification Stored procedure provided by SBO to trigger action when on certain event.

Suda