The document is archived and information here might be outdated
Returns the workstation name.
The following example creates a table that uses
HOST_NAME() in a
DEFAULT definition to record the workstation name of computers that insert rows into a table recording orders.
CREATE TABLE Orders (OrderID int PRIMARY KEY, CustomerID nchar(5) REFERENCES Customers(CustomerID), Workstation nchar(30) NOT NULL DEFAULT HOST_NAME(), OrderDate datetime NOT NULL, ShipDate datetime NULL, ShipperID int NULL REFERENCES Shippers(ShipperID)); GO