Computer name

[Jose Perdigao]

I have a UDF to identify the user name, using the folloing funtion
SUSER_SNAME()
In SQl server 2000 there is ane function to know the computer name?

Thanks,
José Perdigão

 

[giorgio rancati]

Hi Jose

View

 

[Jose Perdigao]

Hi Giorgio,
This is what I want

Thanks a lot
José

Hi Jose

View
----
HOST_NAME()
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ha-hz_05r9.asp
----

for more client's instances
----
SELECT HOST_NAME()+HOST_ID()

HOST_ID()
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ha-hz_23s4.asp
----

bye
--
Giorgio Rancati
[Office Access MVP]

I have a UDF to identify the user name, using the folloing funtion
SUSER_SNAME()
In SQl server 2000 there is ane function to know the computer name?

Thanks,
José Perdigão