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
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
>>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...
by Fabian.Lambe » Fri, 17 Oct 1997 04:00:00
On Thu, 16 Oct 1997 09:00:55 -0700, "Scott McNair"
Hope this helps.
Fabian Lambert
by Martin van Gi » Fri, 17 Oct 1997 04:00:00
On Wed, 15 Oct 1997 16:28:51 -0700, "Scott McNair"
>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
by Darryl Schaff » Sat, 18 Oct 1997 04:00:00
258 = SP3
>>>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
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
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