I discovered a couple of more ways to detect version information while studying for a certification exam.
xp_msver
select @@MICROSOFTVERSION
Most of you reading this were probably already aware, but I'm a career student of SQL Server and there's always more to learn. Enjoy.
