Oh yes, it returns it!
It returns ALL the information
in a single row. See the result
of the query:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>>The solution from Borislav
>>" SELECT @@VERSION "
>>is a good option too.
>>It gives you all the information
>
>It doesn'ty provide info about service pack
***
TONY Nascimento
*****************
"Your mind is like a parachute. It only works if it is open" - Anthony J. D'Angelo
"The desire to know is natural to good men" - Leonardo da Vinci