Is the instance a virtual machine

Is the instance a virtual machine. The second column will display a NONE value or the virtual machine name.

Last updated: 19 September 2016

Warning: Review and test in a non-production environment before running.

Back to results

SELECT
@@SERVERNAME AS server_name,
virtual_machine_type_desc
FROM sys.dm_os_sys_info