The T-SQL code snippet belows returns details regarding the Operating System using the NETSH utility.
It looks like that the April CTP of SQL Server 2005 is very close. According to Mark Bower, a Microsoft consultant in the UK Visual Studio Beta 2 and SQL Server 2005 April CTP are being prepped for download.
A commonly asked question is how to identify the SQL Server Service Pack that is installed. It is possible to identify what version is being run based on the build number returned from the @@VERSION