Computer name

Hello,
I need to know the computer name in an SQL Server 2005 User Defined
Functions. Inside the SQL Server I can't use the
System.Windows.Forms.SystemInformation.Computer, is there another function ?
AlanWhat about
SELECT host_name() ?
HTH, jens Suessmeyer.|||The name of the database server, or the name of the server that is calling
the function (e.g. from an app), or the end client?
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:587F8A8A-A788-4BF8-9DAA-11E3776C12FC@.microsoft.com...
> Hello,
> I need to know the computer name in an SQL Server 2005 User Defined
> Functions. Inside the SQL Server I can't use the
> System.Windows.Forms.SystemInformation.Computer, is there another function
> ?
> Alan|||thanks
"Jens" wrote:

> What about
> SELECT host_name() ?
> HTH, jens Suessmeyer.
>