Category: SQL

SELECT CompName.Name0 as ‘Computer Name’, CompSys.Manufacturer0 as ‘OEM’, CompSys.model0 as ‘Model’, BIOS.SMBIOSBIOSVERSION0 as ‘BIOSVersion’, BIOS.ReleaseDate0 as ‘Release Date’ FROM V_R_System as Sys LEFT JOIN V_GS_PC_BIOS as BIOS on Sys.resourceid = BIOS.resourceid LEFT JOIN V_GS_COMPUTER_SYSTEM as CompSys on Sys.resourceid = CompSys.resourceid LEFT JOIN V_GS_SYSTEM as CompName on Sys.resourceid = CompName.resourceid GROUP BY CompSys.Manufacturer0,CompSys.model0, BIOS.SMBIOSBIOSVersion0, CompName.Name0, BIOS.ReleaseDate0…

Query testsp_configure ‘clr enabled’ Query changesp_configure ‘show advanced options’, 1; GO RECONFIGURE; GO sp_configure ‘clr enabled’, 1; GO RECONFIGURE; GO https://msdn.microsoft.com/en-us/library/ms131048.aspx