A very useful function called HOST_NAME is available in T-SQL which will give you the workstation name from where the data modification request was initiated. Following is the example of usage:
SELECT HOST_NAME() AS HOST_NAME
Since it is a system function, you can use it as a Default value for your column to always store the Workstation name.
SOURCE | LINK | LANGUAGE | ENGLISH |
Retrieve Client PC or Workstation name (T-SQL) http://heelpbook.altervista.org/2012/retrieve-client-pc-or-workstation-name-t-sql/ via @HeelpBook