deciphering the @@version info to get the SP version 
Author Message
 deciphering the @@version info to get the SP version
Hi All,
   I *know* there has to be a knowledge base article out there that will tell me
what SQL Server 7 service pack has been applied based on the info returned

Thanks,

BillR



Tue, 12 Aug 2003 01:33:00 GMT
 deciphering the @@version info to get the SP version

7.00.517     7.0 B3
7.00.583     7.0 RC1
7.00.623     7.0 RTM
7.00.689     7.0 SP1 B1
7.00.699     7.0 SP1
7.00.842     7.0 SP2
7.00.843     7.0 SP2 + "Extended Stored Procedure Parameter Parsing"
Vulnerability patch
   http://www.microsoft.com/technet/security/bulletin/ms00-092.asp
7.00.961     7.0 SP3

--
Keith
==============
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Hi All,
   I *know* there has to be a knowledge base article out there that will
tell me
what SQL Server 7 service pack has been applied based on the info returned

Thanks,

BillR



Tue, 12 Aug 2003 01:52:43 GMT
 deciphering the @@version info to get the SP version
Thanks Keith!
Quote:
-----Original Message-----

7.00.517     7.0 B3
7.00.583     7.0 RC1
7.00.623     7.0 RTM
7.00.689     7.0 SP1 B1
7.00.699     7.0 SP1
7.00.842     7.0 SP2
7.00.843     7.0 SP2 + "Extended Stored Procedure Parameter Parsing"
Vulnerability patch
   http://www.microsoft.com/technet/security/bulletin/ms00-092.asp
7.00.961     7.0 SP3

--
Keith
==============
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.



Hi All,
   I *know* there has to be a knowledge base article out there that will
tell me
what SQL Server 7 service pack has been applied based on the info returned

Thanks,

BillR

.



Tue, 12 Aug 2003 01:55:49 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Getting Informix engine version info

2. Master, msdb and model (old version and new version) i need old version

3. Getting info about SP parameters

4. Checking Version and Copy New Version of ADP

5. Standard version x Desktop version

6. Version 7 to version 2000?

7. installing full version of SQL server 6.5 over the trial version

8. What is the difference between MSDN version and enterprise SQL Server version

9. Trying to Upgrade from Demo version to licensed version

10. SQL Server version /updates and MDAC version

11. Managing version 7 from a version 2000 system


 
Powered by phpBB® Forum Software