August 27, 2002 at 3:25 am
Hi, Can anyone tell me the script that must be run to findout what service pack is currenty on SQL Server.
Thanks
Scott
August 27, 2002 at 3:48 am
Run SELECT @@VERSION and you will see output like this.
Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Then check out various locations on the net including Microsoft or goto http://www.sql-server-performance.com/service_packs.asp as they have a fairly good list of the service pack number and you will notice the first line of my output is
Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
which correspondes with
2000.8.00.534 SQL Server 2000 SP2
The other way to get this number is to open Enterprise Manager, drill to the server you want to look at, right click it's icon and choose properties. On the default tab is the version which SQL 7 servers just show the number, 2000 servers will show the number and usually (SP2) beside the number (service pack based on the number installed).
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 27, 2002 at 5:34 am
Thanks once again for your help. Much appreciated.
Scott
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply