which sql service pack am i running?

which sql service pack am i running?

Post by Paul » Thu, 05 Oct 2000 04:00:00




Microsoft SQL Server  7.00 - 7.00.623 (Intel X86)
 Nov 27 1998 22:20:07
 Copyright (c) 1988-1998 Microsoft Corporation
 Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 4)

I had a look at: http://www.serverfaq.com/ntfaq/sql28.html to check but I
can't work it out - according to this I have SQL Server 7.0 "gold" release -
what the heck is gold release?? I'm sure I installed SP2 on it.  Certain in
fact.  I'm also sure I installed NT SP6a as well - what's going on?

Thanks,

Paul

 
 
 

which sql service pack am i running?

Post by Lasse V?gs?ther Karlse » Thu, 05 Oct 2000 04:00:00


Gold release is plain vanilla original SQL Server 7.0.

If you had SP1, you would have build .699, and if you had SP2 you would have
.842.

In other words, it appears you do not have any service packs installed.

--
Lasse V?gs?ther Karlsen
Cintra Software Engineering AS
+47 35.93.22.03 Office / +47 35.93.22.11 Office fax
+47 90.86.82.73 Cellular
+47 35.55.83.63 Home / +47 35.55.83.64 Home fax
PGP Key: 0x8BF38D66 (ldap://certserver.pgp.com)



> Microsoft SQL Server  7.00 - 7.00.623 (Intel X86)
>  Nov 27 1998 22:20:07
>  Copyright (c) 1988-1998 Microsoft Corporation
>  Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 4)

> I had a look at: http://www.serverfaq.com/ntfaq/sql28.html to check but I
> can't work it out - according to this I have SQL Server 7.0 "gold"
release -
> what the heck is gold release?? I'm sure I installed SP2 on it.  Certain
in
> fact.  I'm also sure I installed NT SP6a as well - what's going on?

> Thanks,

> Paul


 
 
 

which sql service pack am i running?

Post by Dejan Sark » Thu, 05 Oct 2000 04:00:00


Paul,

Quote:> I had a look at: http://www.serverfaq.com/ntfaq/sql28.html to check but I
> can't work it out - according to this I have SQL Server 7.0 "gold"
release -
> what the heck is gold release?? I'm sure I installed SP2 on it.  Certain
in
> fact.  I'm also sure I installed NT SP6a as well - what's going on?

"gold" release means the same as RTM and this is final release without SP's.
Try to install SP2 again.

HTH,
Dejan Sarka

 
 
 

which sql service pack am i running?

Post by Tibor Karasz » Thu, 05 Oct 2000 04:00:00


Gold release it the same as no service pack (RTM). It seems like you didn't have much
success with your sp2 release... Are you sure that you are connected to the right
server?

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.
FAQ at: http://www.sqlserverfaq.com



> Microsoft SQL Server  7.00 - 7.00.623 (Intel X86)
>  Nov 27 1998 22:20:07
>  Copyright (c) 1988-1998 Microsoft Corporation
>  Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 4)

> I had a look at: http://www.serverfaq.com/ntfaq/sql28.html to check but I
> can't work it out - according to this I have SQL Server 7.0 "gold" release -
> what the heck is gold release?? I'm sure I installed SP2 on it.  Certain in
> fact.  I'm also sure I installed NT SP6a as well - what's going on?

> Thanks,

> Paul

 
 
 

which sql service pack am i running?

Post by Paul » Fri, 06 Oct 2000 04:00:00


Thanks for the replies guys.  What I'll do is re-apply SQL SP2, and NT SP6a,
and see if that makes a difference.

Paul

 
 
 

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. DB2 to Informix DB connectivity

3. Cannot run run analytical services pack 3

4. European Network Computing Survey

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

6. Alternate Printer Error 1801

7. Sheduling Executables to Run with SQL Server 6.5 (Service Pack 4)

8. Moving Informix RAW LV's onto a RAID

9. What service pack am I on now????

10. SQL Server or/and Analysis Services Service Pack

11. SQL Service 6.5 w/Service Pack 4

12. What Service pack is running?