the host_name() function returns an empty value when it runs from a trigger. when I run the same update statement from query analyzer or set a value to trigger the trigger, the correct hostname is returned.
Here is what we did:
1) Setup a field called hostname, nchar, 20
2) Created a user defined function called hostname.
CREATE function HostName ()
3) Modified our trigger to include the function.
set Issuedby = dbo.username(), hostname = dbo.hostname(),
once that returned blanks, I modified the trigger to bypass the user defined function of hostname