>>>Hi,,
>>>What is easiest way to return the server name (SQL Server Name) in a query?
>>>
>>>thanks,
>>
>>

SELECT @@SERVERNAME

>
>Thanks - figured it was something simple like that!

For SQL 2000 you can also take a look at SERVERPROPERTY() function.