The last code sample returns 'Yukon' on 2000. Even though @@version says:
Microsoft SQL Server 2000 - 8.00.926 (Intel X86) Mar 17 2004 14:06:24 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: )