>>>>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')
>>>
>>
>>I now know I am running SQL Server 2000 version 8.00.194. How do I determine the service pack level and if there are any outstanding patches to be applied?
>
>The SERVERPROPERTY ('ProductLevel') returns the name of latest service pack installed. If it returns empty string than you've original installation w/o service packs. The lates service pack for SQl Server is SP4.
ProductLevel = RTM
Which is meaningless.
Even if I know which service pack I have, there seems to be know way of knowing if I have all patches that have been released since that service pack.