Query to get Operating System information?

I need to get my operating system from SQL Server. Would love to have @.@.OperatingSystem or ServerProperty('WindowsVersion') or something like that.

Anyone have any ideas?

thanks ahead,

One of the simple way...

Select Substring(@.@.Version , CharIndex('Edition on ',@.@.Version) + len('Edition on ') ,LeN(@.@.Version))

If your output :

Windows NT 5.0 = Windows 2000

Windows NT 5.1 = Windows XP

Windows NT 5.2 = Windows 2003 Server & etc.

|||

The following query also help you to find the windows os version..

xp_msver N'Platform', N'WindowsVersion'