>>>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?Mine says:
Standard Edition
2
8.00.818
SP3
so you have patches to apply.
http://support.microsoft.com/?kbid=815495http://www.microsoft.com/technet/prodtechnol/sql/2000/security.mspx