HEELPBOOK - Retrieve Client PC or Workstation name (T-SQL) ###########################

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.

############ ARTICLE INFO #############

Article Month: November
Article Date: 27/11/2012
Permalink: http://heelpbook.altervista.org/2012/retrieve-client-pc-or-workstation-name-t-sql/comment-page-1/
Source: http://blog.namwarrizvi.com/?p=127
Language: English

View more articles on: http://www.heelpbook.net/
Follow us on Facebook: http://it-it.facebook.com/pages/HeelpBook/100790870008832
Follow us on Twitter: https://twitter.com/#!/HeelpBook
Follow us on RSS Feed: http://feeds.feedburner.com/Heelpbook
Follow us on Delicious: http://delicious.com/heelpbook
Linkedin: http://it.linkedin.com/pub/stefano-maggi/27/73a/b20
Google+ : https://plus.google.com/116990277568167008289/posts