March 4, 2002 at 9:59 am
I would like to be able to tell what service packs a SQL server is sitting on. If I do a Select @@Version I get the version number, but where can I correlate this information with a service pack/Hot fix? The MS HF Tool is very unreleiable to use, it didn't even see a SQL Server running on one machine.
- Vega
March 4, 2002 at 10:08 am
The readme files for the latest service packs contain this information.
SQL Server 2000:
SQL Server 7:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q274798
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
March 4, 2002 at 10:19 am
For SQL 7
7.00.623 if SQL Server 7.0 with no service pack applied
7.00.699 if SQL Server 7.0 Service Pack 1
7.00.842 if SQL Server 7.0 Service Pack 2
7.00.961 if SQL Server 7.0 Service Pack 3
SQL 2000
8.00.194 SQL Server 2000 RTM
8.00.384 Database Components SP1
8.00.532 Database Components SP2
Of course this list wll have adds as it goes. And I have seen a Stored Procedure to make this easier as far as current SP's but I forget the title to point you in the right direction.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply