Software >> Services >> RDBMS >> SQL Server >>  How to determine service pack version

1. From Query analyser run the following select @@VERSION GO 2. Use following table to identify No SP SP1 SP2 SP3 SQL 7 7.00.623 7.00.699 7.00.842 7.00.961 SQL 2000 8.00.194 8.00.384 8.00.534