Press "Enter" to skip to content

Finding Windows Version With T-SQL

Jack Vamvas shows us several methods to figure out which version of Windows you have installed from within SQL Server:

Method 2 : Use xp_cmdshell –¬†although this does mean enabling xp_cmdshell , which is in many organisations as security violation¬†
exec master..xp_cmdshell 'systeminfo'

Click through for several less controversial methods.