>I've just started using SQL Server. How do I determine which version of SQL Server, which service pack(s) have been applied and if there any outstanding patches that need to be applied. Windows Update doesn't indicate if any patches are needed for SQL Server.
SELECT
SERVERPROPERTY ('Edition'),
SERVERPROPERTY ('EngineEdition'),
SERVERPROPERTY ('ProductVersion'),
SERVERPROPERTY ('ProductLevel')
--sb--