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?
>Try
>
SELECT @@VERSION
>in Query Analyzer.
>
>Bill
>
>>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.