Find OS version from SQL Server

-- Windows information (SQL Server 2008 R2 SP1 or greater)

SELECT windows_release, windows_service_pack_level,

windows_sku, os_language_version

FROM sys.dm_os_windows_info OPTION (RECOMPILE);

-- Gives you major OS version, Service Pack, Edition, and language info for the operating system

Recent Posts

--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...

select schema_name(tab.schema_id) as [schema_name], pk.[name] as pk_name, substring(column_names, 1, len(column_names)-1) as [columns],...

--Execute the following script against the User Database where you need to find DB User permission. DECLARE @sql VARCHAR(2048) ,@sort INT...