[sourcecode language=”sql”] SELECT createdate AS [SQL Server Install Date] FROM sys.syslogins WHERE [sid] = 0x010100000000000512000000; [/sourcecode] – This T-SQL command helps to determine the date and time that SQL Server was installed
[sourcecode language=”sql”]SELECT windows_release, windows_service_pack_level, windows_sku, os_language_version FROM sys.dm_os_windows_info OPTION (RECOMPILE); [/sourcecode] – Gives you major OS version, Service Pack, Edition, and language info for the operating system
[sourcecode language=”sql”] SELECT @@VERSION AS [SQL Server and OS Version Info]; or SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) [/sourcecode] – This T-SQL command will help to determine the version of SQL server you are running and corresponding Windows Operating System version