What service pack am I on now????

What service pack am I on now????

Post by Scott McNai » Thu, 16 Oct 1997 04:00:00



I have inherited a number of servers and am trying to determine exactly what
service pack I have installed on a number of SQL6.5 servers.


etc, etc, BUT, I can't seem to determine what service packs have been
applied (ie: 1, 2, 3, etc,..)

Anyone know how to do this??

Please reply to:
scmcnair-at-themirage-dot-com

 
 
 

What service pack am I on now????

Post by Scott McNai » Fri, 17 Oct 1997 04:00:00


Martin,

Thanks for the info.
Sometime back (about a year or so ago), I placed a call to MS-Support and
they had me perform some sql to retrieve  additional info for them. This was

The SQL returned info that stated what "roll-up" and/or service pack I had
installed. I can't find where I wrote this down so I'm looking for it now. I
really don't want to spend $195 to call MS and ask them....

Thanks
Scott


>On Wed, 15 Oct 1997 16:28:51 -0700, "Scott McNair"

>>I have inherited a number of servers and am trying to determine exactly
what
>>service pack I have installed on a number of SQL6.5 servers.


>>etc, etc, BUT, I can't seem to determine what service packs have been
>>applied (ie: 1, 2, 3, etc,..)

>>Anyone know how to do this??

>>Please reply to:
>>scmcnair-at-themirage-dot-com


>6.50.258 (I am sure) means you got service pack 3 installed.
>6.50.231 (I Think) means SP 2 etc...


 
 
 

What service pack am I on now????

Post by Fabian.Lambe » Fri, 17 Oct 1997 04:00:00


On Thu, 16 Oct 1997 09:00:55 -0700, "Scott McNair"



>>6.50.258 (I am sure) means you got service pack 3 installed.
>>6.50.231 (I Think) means SP 2 etc...

If you have SP3 (or any SP) the readme.txt file shows all versions of
sql server returned by the SP version (build number)

Hope this helps.

Fabian Lambert

 
 
 

What service pack am I on now????

Post by Martin van Gi » Fri, 17 Oct 1997 04:00:00


On Wed, 15 Oct 1997 16:28:51 -0700, "Scott McNair"


>I have inherited a number of servers and am trying to determine exactly what
>service pack I have installed on a number of SQL6.5 servers.


>etc, etc, BUT, I can't seem to determine what service packs have been
>applied (ie: 1, 2, 3, etc,..)

>Anyone know how to do this??

>Please reply to:
>scmcnair-at-themirage-dot-com


6.50.258 (I am sure) means you got service pack 3 installed.
6.50.231 (I Think) means SP 2 etc...
 
 
 

What service pack am I on now????

Post by Darryl Schaff » Sat, 18 Oct 1997 04:00:00


258 = SP3



>On Thu, 16 Oct 1997 09:00:55 -0700, "Scott McNair"


>>>6.50.258 (I am sure) means you got service pack 3 installed.
>>>6.50.231 (I Think) means SP 2 etc...

>If you have SP3 (or any SP) the readme.txt file shows all versions of
>sql server returned by the SP version (build number)

>Hope this helps.

>Fabian Lambert


------------------------------------------------
Darryl Schaffer

 
 
 

1. which service pack am I running?

I have inherited a NT4 server running SQL7.  I was trying to apply Service
Pack 1 to this server, (it has service pack 6 for the NT).  After running
setup it said that I was already running something newer than the service

Analyzer and it came back with this:

SQL version 7.00 - 7.00.835  (Intel x86)
Standard Edition Windows NT (build 1381 sp6)

Can somebody tell me what I have here?  Is there a newer service pack
already applied to my SQL???????
The readme for installing Service Pack 1 states that if SP1 is installed the
version I should read should be  7.00.699.

2. q: diffrence between row_shared and row_exclusive lock ?

3. which sql service pack am i running?

4. Database for MS Windows with C++ API?

5. What Service Pack level am I at???

6. Saving ALL changes to a Database?

7. SQL Service 6.5 w/Service Pack 4

8. Q: Another how to question

9. Analysis Services Service pack 2

10. Analysis Services Service Packs installed : How to determine

11. Errors in Service Manager and Enterprise Manager after installing Service Pack 3

12. SQL Server or/and Analysis Services Service Pack

13. analysis services server disappear after installing service pack 2