SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: SQL Server Versions
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 3

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 03/17/2002 :  23:52:22  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.

Article Link.

izaltsman
A custom title

USA
1139 Posts

Posted - 03/18/2002 :  09:02:00  Show Profile  Send izaltsman an AOL message  Send izaltsman an ICQ Message  Reply with Quote
Here is a more complete (includes hotfixes) list of versions that I pulled down from http://www.toomuchblue.com/versions.html
I don't guarantee it is entirely accurate, but since MS won't publish a comprehensive list...


SQL Server 6.0
6.00.121 6.0 "gold" release
6.00.124 Service Pack 1
6.00.139 Service Pack 2
6.00.151 Service Pack 3



SQL Server 6.5
6.50.201 SQL 6.5 "gold" release
6.50.213 Service Pack 1
6.50.240 Service Pack 2
6.50.252 Service Pack 3 (known bad version)
6.50.258 Service Pack 3a
6.50.259 6.5 as included with Small Business Server only
6.50.281 Service Pack 4 (cannot be installed on SBS or Enterprise Edition)
6.50.297 "Site Server 3.0 Commerce Edition" hotfix
6.50.339 Y2K hotfix
6.50.415 Service Pack 5 (SQL 7.0 compatibility)
6.50.416 Service Pack 5a, 24Dec1998 (readme, fixlist, download)
6.50.464 Hotfix: error 213 on insert <table> exec <proc> (Q275483)




SQL Server 7.0
7.00.623 SQL 7.0 "gold" release
7.00.643 Hotfix: clustering servers with "-" in name (Q220156)
7.00.657 Hotfix: automated install (Q229875)
7.00.658 Hotfix: AV under high cursor stress (Q244763)
7.00.662 Hotfix: in with subquery may be slower than in 6.5 (Q232707)
7.00.699 Service Pack 1, 31Jul1999 (readme, fixlist, download)
7.00.722 Hotfix: oledb connections to DB2 (Q239458)
7.00.745 Hotfix: SQLAgent memory leak (Q253738)
7.00.770 Hotfix: Slow compile on join with unfiltered table (Q252905)
7.00.776 Hotfix: Error during shutdown (Q258087)
7.00.842 Service Pack 2, 20Mar2000 (readme, fixlist, download)
7.00.857 Hotfix: Publications with numeric filter do not replicate (Q260346)
7.00.879 Hotfix: Linked Index Server/OLEDB/or in where clause (Q281185)
7.00.889 Hotfix: Replication memory leaks (Q243741)
7.00.905 Hotfix: Data Modification Query with a Distinct Subquery on a View May Cause Error 3624 (Q274266)
7.00.910 Hotfix: SQL RPC That Raises Error Will Mask @@ERROR with Msg 7221 (Q275901)
7.00.917 Hotfix: bcp fails with long query (Q279180)
7.00.918 Hotfix: xp_ buffer overflow exploit (Q280380)
7.00.919 Hotfix: Incorrect results on join to convert([var]binary,) (SP2) (Q282243)
7.00.921 Hotfix: "nested queries" setting ignored on linked server (SP2) (Q283837)
7.00.961 Service Pack 3, 15Dec2000 (readme, fixlist, download)
7.00.970 Hotfix: "nested queries" setting ignored on linked server (SP3) (Q283837)
Hotfix: Incorrect results on join to convert([var]binary,) (SP3) (Q282243)
7.00.977 Hotfix: SQL Server Profiler and SQL Server Agent Alerts May Fail to Work After Installing SQL Server 7.0 SP3 (Q284351)
7.00.978 Hotfix: Update with table aliases may miss rows (Q285870)
7.00.1004 Hotfix: SQL Server Text Formatting Functions Contain Unchecked Buffers (Q304851)



SQL Server 2000 (8.0)
8.00.194 SQL 2000 "gold" release
8.00.204 Hotfix: Optimizer Slow to Generate Query Plan for Complex Queries that have Many Joins and Semi-Joins (Q274329)
8.00.205 Hotfix: Sending Open Files as Attachment in SQL Mail Fails with Error 18025 (Q274330)
8.00.210 Hotfix: Linked Server Query with Hyphen in LIKE Clause May Run Slowly (Q275900)
8.00.211 Hotfix: Complex Distinct or Group By Query Can Return Unexpected Results with Parallel Execution Plan (Q276329)
8.00.217 Hotfix: CASE Using LIKE with Empty String Can Result in Access Violation or Abnormal Server Shutdown (Q279293)
Hotfix: Using ALTER TABLE to Change Column Type Can Result in Unexpected NULL Values on INSERT (Q279296)
8.00.218 Hotfix: Scripting Object with Several Extended Properties May Cause Exception (Q279183)
8.00.222 Hotfix: AV in query normalization (Q281769)
8.00.223 Hotfix: xp_ buffer overflow exploit (Q280380)
8.00.225 Hotfix: SQLOLEDB leaves an open transaction (Q281663)
8.00.226 Hotfix: Extreme Memory Usage When Adding Many Security Roles (Q278239)
8.00.231 Hotfix: sp_OACreate can cause server shutdown (Q282279)
8.00.233 Hotfix: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time (Q282416)
8.00.239 Hotfix: AV on complex ANSI joins of multiply distributed queries (Q285290)
8.00.249 Hotfix: Lock Monitor Uses Excessive CPU (Q288122)
8.00.250 Hotfix: xp_sqlagent_param Problems with Windows Authentication (Q291683)
8.00.287 Hotfix: Deletes, Updates and Rank Based Selects May Cause Deadlock of MSSEARCH (Q297209)
8.00.384 Service Pack 1, 12Jul2001 (readme, fixlist, download)
8.00.428 Hotfix: SQL Server Text Formatting Functions Contain Unchecked Buffers (Q304850)
8.00.443 Hotfix: SQLTrace Start and Stop is Now Reported in Windows NT Event Log for SQL Server 2000 (Q307538)
8.00.444 Hotfix: SQLPutData May Result in Leak of Buffer Pool Memory (Q307540)
Hotfix: Querying Syslockinfo with Large Numbers of Locks May Cause Server to Stop Responding (Q307655)
8.00.452 Hotfix: SELECT DISTINCT from Table with LEFT JOIN of View Causes Error Messages or Client Application May Stop Responding (Q308547)
8.00.534 Service Pack 2, 30Nov2001 (readme, fixlist, download)


Go to Top of Page

mphelps
Starting Member

South Africa
12 Posts

Posted - 03/19/2002 :  01:27:50  Show Profile  Reply with Quote
One additional service pack for SQL 6.5

6.50.479 - Post service Pack 5a

quote:
I don't suffer from insanity, I enjoy every minute of it


Go to Top of Page

Argyle
Yak Posting Veteran

53 Posts

Posted - 03/21/2002 :  10:44:56  Show Profile  Reply with Quote
Here is the list I have. Think you will find some additions to the ones posted already. Not sure how it will look when I paste it here.

**************** SQL Server ****************

ProductVersion Service Pack Level
-------------- ------------------
6.00.121 SQL Server 6.0 Original release
6.00.124 SQL Server 6.0 SP1
6.00.139 SQL Server 6.0 SP2
6.00.151 SQL Server 6.0 SP3

6.50.201 SQL Server 6.5 Original release
6.50.213 SQL Server 6.5 SP1
6.50.240 SQL Server 6.5 SP2
6.50.252 SQL Server 6.5 SP3 BAD release - use .258
6.50.258 SQL Server 6.5 SP3
6.50.259 SQL Server 6.5 SP3 for Small Business Server only
6.50.281 SQL Server 6.5 SP4
6.50.297 SQL Server 6.5 SP4 included in Site Server 3
6.50.339 SQL Server 6.5 SP4 with "Y2K" hotfix
6.50.415 SQL Server 6.5 SP5 BAD release - use SP5a
6.50.416 SQL Server 6.5 SP5a
6.50.464 SQL Server 6.5 SP5a with "Insert exec" hotfix. Q275483
6.50.479 SQL Server 6.5 SP5a with post SP5a update

7.00.517 SQL Server 7.0 Beta 3
7.00.583 SQL Server 7.0 RC1
7.00.623 SQL Server 7.0 Original release or MSDE 1.0
7.00.643 SQL Server 7.0 with "Cluster Name" hotfix. Q220156
7.00.657 SQL Server 7.0 with "Automated Installation" hotfix. Q229875
7.00.658 SQL Server 7.0 with "Access Violation" hotfix. Q244763
7.00.658 SQL Server 7.0 with "Slow Complex View" hotfix. Q232707
7.00.677 MSDE from Office 2000 Developer, incorrect registry value, should be 0.623. Q234915
7.00.689 SQL Server 7.0 SP1 Beta
7.00.699 SQL Server 7.0 SP1
7.00.722 SQL Server 7.0 SP1 with "DB2 OLEDB" hotfix. Q239458
7.00.745 SQL Server 7.0 SP1 with "Memory Leak" hotfix. Q253738
7.00.770 SQL Server 7.0 SP1 with "Slow Complex Join" hotfix. Q252905
7.00.776 SQL Server 7.0 SP1 with "Shutdown Assertion Error" hotfix. Q258087
7.00.835 SQL Server 7.0 SP2 Beta
7.00.842 SQL Server 7.0 SP2
7.00.857 SQL Server 7.0 SP2 with "Replication Filter" hotfix. Q260346
7.00.879 SQL Server 7.0 SP2 with "Linked Server" hotfix. Q281185
7.00.889 SQL Server 7.0 SP2 with "Replication Handle Leak" hotfix. Q243741
7.00.905 SQL Server 7.0 SP2 with "Data Modification Assertion Error" hotfix. Q274266
7.00.910 SQL Server 7.0 SP2 with "RPC Wrong Error" hotfix. Q275901
7.00.917 SQL Server 7.0 SP2 with "BCP Assertion Error" hotfix. Q279180
7.00.918 SQL Server 7.0 SP2 with "xp_ Buffer Overflow" hotfix. Q280380
7.00.919 SQL Server 7.0 SP2 with "Incorrect Join Result" hotfix. Q282243
7.00.921 SQL Server 7.0 SP2 with "Linked Server Nested Query" hotfix. Q283837
7.00.961 SQL Server 7.0 SP3
7.00.970 SQL Server 7.0 SP3 with "Incorrect Join Result + Nexted Query" hotfix. Q282243, Q283837
7.00.977 SQL Server 7.0 SP3 with "Profiler + Agent" hotfix. Q284351
7.00.978 SQL Server 7.0 SP3 with "Update With Self Join" hotfix. Q285870
7.00.1004 SQL Server 7.0 SP3 with "Text Formatting Unchecked Buffer" hotfix. Q304851 (KB now includes 1020 instead)
7.00.1020 SQL Server 7.0 SP3 with "Text Formatting Unchecked Buffer" hotfix. Q304851
7.00.1021 SQL Server 7.0 SP3 with "Security Update (RDS + Text)" hotfix. Q317979, Q318268

7.50.198 SQL Server 7.5/2000 Beta 1
8.00.047 SQL Server 8.0/2000 EAP4
8.00.078 SQL Server 8.0/2000 EAP5
8.00.100 SQL Server 8.0/2000 Beta 2
8.00.194 SQL Server 8.0/2000 Original release
8.00.204 SQL Server 8.0/2000 SP1 with "Slow Optimizer" hotfix. Q274329
8.00.205 SQL Server 8.0/2000 SP1 with "Mail Attachment" hotfix. Q274330
8.00.210 SQL Server 8.0/2000 SP1 with "Slow Linked Server Query" hotfix. Q275900
8.00.211 SQL Server 8.0/2000 SP1 with "Unexpected Results" hotfix. Q276329
8.00.217 SQL Server 8.0/2000 SP1 with "Access Violation + Unexpected NULL" hotfix. Q279293, Q279296
8.00.218 SQL Server 8.0/2000 SP1 with "Scripting Object" hotfix. Q279183
8.00.222 SQL Server 8.0/2000 SP1 with "Access Violation During Normalization" hotfix. Q281769
8.00.223 SQL Server 8.0/2000 SP1 with "xp_ Buffer Overflow" hotfix. Q280380
8.00.231 SQL Server 8.0/2000 SP1 with "sp_OACreate" hotfix. Q282279
8.00.233 SQL Server 8.0/2000 SP1 with "Opening Database Folder" hotfix. Q282416
8.00.239 SQL Server 8.0/2000 SP1 with "Complex Join Access Violation" hotfix. Q285290
8.00.249 SQL Server 8.0/2000 SP1 with "Lock Monitor" hotfix. Q288122
8.00.250 SQL Server 8.0/2000 SP1 with "xp_sqlagent_param" hotfix. Q291683
8.00.287 SQL Server 8.0/2000 SP1 with "Deadlock" hotfix. Q297209
8.00.384 SQL Server 8.0/2000 SP1
8.00.428 SQL Server 8.0/2000 SP1 with "Text Formatting Unchecked Buffer" hotfix. Q304850
8.00.443 SQL Server 8.0/2000 SP1 with "SQLTrace" hotfix. Q307538
8.00.444 SQL Server 8.0/2000 SP1 with "Memory Leak + Lock" hotfix. Q307540, Q307655
8.00.452 SQL Server 8.0/2000 SP1 with "Select Distinct" hotfix. Q308547
8.00.471 SQL Server 8.0/2000 SP1 with "Lock Escalation" hotfix. Q313302
8.00.532 SQL Server 8.0/2000 SP2
8.00.552 SQL Server 8.0/2000 SP2 with "Lock Escalation" hotfix. Q313302
8.00.578 SQL Server 8.0/2000 SP2 with "Security Update (RDS + Proxy)" hotfix. Q316333

**************** OLAP/Analysis ****************

ProductVersion Service Pack Level
-------------- ------------------
7.0.1073 SQL Server 7.0 OLAP Original release
7.0.1295 SQL Server 7.0 OLAP SP1
7.0.1325 SQL Server 7.0 OLAP SP2 Beta
7.0.1458 SQL Server 7.0 OLAP SP2
7.0.1508 SQL Server 7.0 OLAP SP3

8.0.194 SQL Server 8.0/2000 OLAP Original release
8.0.382 SQL Server 8.0/2000 OLAP SP1
8.0.532 SQL Server 8.0/2000 OLAP SP2

***********************************************

Go to Top of Page

Argyle
Yak Posting Veteran

53 Posts

Posted - 03/21/2002 :  10:51:47  Show Profile  Reply with Quote
Ops, was an old version. this is the correct one

**************** SQL Server ****************

ProductVersion Service Pack Level
-------------- ------------------
6.00.121 SQL Server 6.0 Original release
6.00.124 SQL Server 6.0 SP1
6.00.139 SQL Server 6.0 SP2
6.00.151 SQL Server 6.0 SP3

6.50.201 SQL Server 6.5 Original release
6.50.213 SQL Server 6.5 SP1
6.50.240 SQL Server 6.5 SP2
6.50.252 SQL Server 6.5 SP3 BAD release - use .258
6.50.258 SQL Server 6.5 SP3
6.50.259 SQL Server 6.5 SP3 for Small Business Server only
6.50.281 SQL Server 6.5 SP4
6.50.297 SQL Server 6.5 SP4 included in Site Server 3
6.50.339 SQL Server 6.5 SP4 with "Y2K" hotfix
6.50.415 SQL Server 6.5 SP5 BAD release - use SP5a
6.50.416 SQL Server 6.5 SP5a
6.50.464 SQL Server 6.5 SP5a with "Insert exec" hotfix. Q275483
6.50.479 SQL Server 6.5 SP5a with post SP5a update

7.00.517 SQL Server 7.0 Beta 3
7.00.583 SQL Server 7.0 RC1
7.00.623 SQL Server 7.0 Original release or MSDE 1.0
7.00.643 SQL Server 7.0 with "Cluster Name" hotfix. Q220156
7.00.657 SQL Server 7.0 with "Automated Installation" hotfix. Q229875
7.00.658 SQL Server 7.0 with "Access Violation" hotfix. Q244763
7.00.658 SQL Server 7.0 with "Slow Complex View" hotfix. Q232707
7.00.677 MSDE from Office 2000 Developer, incorrect registry value, should be 0.623. Q234915
7.00.689 SQL Server 7.0 SP1 Beta
7.00.699 SQL Server 7.0 SP1
7.00.722 SQL Server 7.0 SP1 with "DB2 OLEDB" hotfix. Q239458
7.00.745 SQL Server 7.0 SP1 with "Memory Leak" hotfix. Q253738
7.00.770 SQL Server 7.0 SP1 with "Slow Complex Join" hotfix. Q252905
7.00.776 SQL Server 7.0 SP1 with "Shutdown Assertion Error" hotfix. Q258087
7.00.835 SQL Server 7.0 SP2 Beta
7.00.842 SQL Server 7.0 SP2
7.00.857 SQL Server 7.0 SP2 with "Replication Filter" hotfix. Q260346
7.00.879 SQL Server 7.0 SP2 with "Linked Server" hotfix. Q281185
7.00.889 SQL Server 7.0 SP2 with "Replication Handle Leak" hotfix. Q243741
7.00.905 SQL Server 7.0 SP2 with "Data Modification Assertion Error" hotfix. Q274266
7.00.910 SQL Server 7.0 SP2 with "RPC Wrong Error" hotfix. Q275901
7.00.917 SQL Server 7.0 SP2 with "BCP Assertion Error" hotfix. Q279180
7.00.918 SQL Server 7.0 SP2 with "xp_ Buffer Overflow" hotfix. Q280380
7.00.919 SQL Server 7.0 SP2 with "Incorrect Join Result" hotfix. Q282243
7.00.921 SQL Server 7.0 SP2 with "Linked Server Nested Query" hotfix. Q283837
7.00.961 SQL Server 7.0 SP3
7.00.970 SQL Server 7.0 SP3 with "Incorrect Join Result + Nexted Query" hotfix. Q282243, Q283837
7.00.977 SQL Server 7.0 SP3 with "Profiler + Agent" hotfix. Q284351
7.00.978 SQL Server 7.0 SP3 with "Update With Self Join" hotfix. Q285870
7.00.1004 SQL Server 7.0 SP3 with "Text Formatting Unchecked Buffer" hotfix. Q304851 (KB now includes 1020 instead)
7.00.1020 SQL Server 7.0 SP3 with "Text Formatting Unchecked Buffer" hotfix. Q304851
7.00.1021 SQL Server 7.0 SP3 with "Security Update (RDS + Text)" hotfix. Q317979, Q318268

7.50.198 SQL Server 7.5/2000 Beta 1
8.00.047 SQL Server 8.0/2000 EAP4
8.00.078 SQL Server 8.0/2000 EAP5
8.00.100 SQL Server 8.0/2000 Beta 2
8.00.194 SQL Server 8.0/2000 Original release
8.00.204 SQL Server 8.0/2000 with "Slow Optimizer" hotfix. Q274329
8.00.205 SQL Server 8.0/2000 with "Mail Attachment" hotfix. Q274330
8.00.210 SQL Server 8.0/2000 with "Slow Linked Server Query" hotfix. Q275900
8.00.211 SQL Server 8.0/2000 with "Unexpected Results" hotfix. Q276329
8.00.217 SQL Server 8.0/2000 with "Access Violation + Unexpected NULL" hotfix. Q279293, Q279296
8.00.218 SQL Server 8.0/2000 with "Scripting Object" hotfix. Q279183
8.00.222 SQL Server 8.0/2000 with "Access Violation During Normalization" hotfix. Q281769
8.00.223 SQL Server 8.0/2000 with "xp_ Buffer Overflow" hotfix. Q280380
8.00.231 SQL Server 8.0/2000 with "sp_OACreate" hotfix. Q282279
8.00.233 SQL Server 8.0/2000 with "Opening Database Folder" hotfix. Q282416
8.00.239 SQL Server 8.0/2000 with "Complex Join Access Violation" hotfix. Q285290
8.00.249 SQL Server 8.0/2000 with "Lock Monitor" hotfix. Q288122
8.00.250 SQL Server 8.0/2000 with "xp_sqlagent_param" hotfix. Q291683
8.00.287 SQL Server 8.0/2000 with "Deadlock" hotfix. Q297209
8.00.384 SQL Server 8.0/2000 SP1
8.00.428 SQL Server 8.0/2000 SP1 with "Text Formatting Unchecked Buffer" hotfix. Q304850
8.00.443 SQL Server 8.0/2000 SP1 with "SQLTrace" hotfix. Q307538
8.00.444 SQL Server 8.0/2000 SP1 with "Memory Leak + Lock" hotfix. Q307540, Q307655
8.00.452 SQL Server 8.0/2000 SP1 with "Select Distinct" hotfix. Q308547
8.00.471 SQL Server 8.0/2000 SP1 with "Lock Escalation" hotfix. Q313302
8.00.532 SQL Server 8.0/2000 SP2
8.00.552 SQL Server 8.0/2000 SP2 with "Lock Escalation" hotfix. Q313302
8.00.578 SQL Server 8.0/2000 SP2 with "Security Update (RDS + Proxy)" hotfix. Q316333

**************** OLAP/Analysis ****************

ProductVersion Service Pack Level
-------------- ------------------
7.0.1073 SQL Server 7.0 OLAP Original release
7.0.1295 SQL Server 7.0 OLAP SP1
7.0.1325 SQL Server 7.0 OLAP SP2 Beta
7.0.1458 SQL Server 7.0 OLAP SP2
7.0.1508 SQL Server 7.0 OLAP SP3

8.0.194 SQL Server 8.0/2000 OLAP Original release
8.0.382 SQL Server 8.0/2000 OLAP SP1
8.0.532 SQL Server 8.0/2000 OLAP SP2

***********************************************

Go to Top of Page

TJ
Posting Yak Master

USA
201 Posts

Posted - 04/02/2002 :  09:56:22  Show Profile  Reply with Quote
These links helped me figure out what an error code meant and how to fix it.

SQL Server 7.0 SP3 articles


http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com/support/servicepacks/SQL/7.0/SP3.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274797&&GSSNB=1

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274798&&GSSNB=1



I'm learning to be more of an investigator before asking for help from this team of wonderful, patient people. I should have read this article first! :o)

Thanks,
Teresa



"Someday I'll know enough to help someone else!"
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 03/17/2004 :  17:32:28  Show Profile  Reply with Quote
I just got version 8.00.919 from SAP


exec master..xp_msver


Index  Name                             Internal_Value Character_Value                                                                                                          
------ -------------------------------- -------------- ------------------------------------------------------------------------------------------------------------------------ 
1      ProductName                      NULL           Microsoft SQL Server
2      ProductVersion                   524288         8.00.919
3      Language                         1033           English (United States)
4      Platform                         NULL           NT INTEL X86
5      Comments                         NULL           NT INTEL X86
6      CompanyName                      NULL           Microsoft Corporation
7      FileDescription                  NULL           SQL Server Windows NT
8      FileVersion                      NULL           2000.080.0919.00
9      InternalName                     NULL           SQLSERVR
10     LegalCopyright                   NULL           © 1988-2003 Microsoft Corp. All rights reserved.
11     LegalTrademarks                  NULL           Microsoft® is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation
12     OriginalFilename                 NULL           SQLSERVR.EXE
13     PrivateBuild                     NULL           NULL
14     SpecialBuild                     60227584       NULL
15     WindowsVersion                   170393861      5.1 (2600)
16     ProcessorCount                   1              1
17     ProcessorActiveMask              1              00000001
18     ProcessorType                    586            PROCESSOR_INTEL_PENTIUM
19     PhysicalMemory                   320            320 (335069184)
20     Product ID                       NULL           NULL

(20 row(s) affected)



-ec
Go to Top of Page

Frank Kalis
Constraint Violating Yak Guru

Switzerland
413 Posts

Posted - 03/18/2004 :  03:48:49  Show Profile  Visit Frank Kalis's Homepage  Reply with Quote
I wonder why nobody mentioned this site http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37



--Frank
http://www.insidesql.de
Go to Top of Page

TimS
Posting Yak Master

USA
198 Posts

Posted - 02/16/2006 :  10:49:33  Show Profile  Reply with Quote
I use http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
and http://www.aspfaq.com/sql2000builds.asp

Tim S
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 05/23/2006 :  01:42:37  Show Profile  Reply with Quote
www.sqlsecurity.com version page (SQL 2000 and SQL 2005) has moved to:

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

SQL2005: http://www.aspfaq.com/sql2005/show.asp?id=20

Go to Top of Page

spejbl
Starting Member

28 Posts

Posted - 01/14/2007 :  07:49:31  Show Profile  Visit spejbl's Homepage  Reply with Quote
better source:
Microsoft SQL Server 2005, 2000 and 7.0 Builds:
http://SQLServerBuilds.blogspot.com
Go to Top of Page

Ian83
Starting Member

Austria
5 Posts

Posted - 01/20/2007 :  09:51:18  Show Profile  Visit Ian83's Homepage  Reply with Quote
(Spam Removed)
Go to Top of Page

Sinds
Starting Member

South Africa
1 Posts

Posted - 03/03/2008 :  07:53:12  Show Profile  Click to see Sinds's MSN Messenger address  Reply with Quote
Anybody know what SP is 9.00.1399.06 ?
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

USA
4137 Posts

Posted - 03/03/2008 :  07:59:38  Show Profile  Visit graz's Homepage  Reply with Quote
quote:
Originally posted by Sinds

Anybody know what SP is 9.00.1399.06 ?



That is SQL Server RTM (no service pack)

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page

dbist
Yak Posting Veteran

USA
52 Posts

Posted - 01/28/2009 :  14:45:01  Show Profile  Visit dbist's Homepage  Send dbist an AOL message  Click to see dbist's MSN Messenger address  Send dbist a Yahoo! Message  Reply with Quote
Version 8.0.2050 released recently for SQL 2000.
Go to Top of Page

GaryF
Starting Member

USA
4 Posts

Posted - 01/30/2009 :  10:12:24  Show Profile  Reply with Quote
This is my "gold standard" when trying to discern version information:

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx



No trees were killed in the sending of this message. However, some electrons were seriously inconvienenced.
Go to Top of Page

panam
Starting Member

1 Posts

Posted - 02/04/2009 :  10:42:31  Show Profile  Reply with Quote
At least in SQL2005 instead using @@VERSION & master..xp_msver
consider this:
SELECT SERVERPROPERTY('MachineName'), SERVERPROPERTY('ProductVersion'), SERVERPROPERTY('ProductLevel'), SERVERPROPERTY('Edition'), @@VERSION –- etc
BOL = ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/11e166fa-3dd2-42d8-ac4b-04f18c612c4a.htm
Go to Top of Page

jerryhung
Starting Member

2 Posts

Posted - 02/05/2009 :  14:46:47  Show Profile  Reply with Quote
I usually use this website

http://sqlserverbuilds.blogspot.com/
Go to Top of Page

pjstreiff
Starting Member

USA
12 Posts

Posted - 02/06/2009 :  09:25:37  Show Profile  Visit pjstreiff's Homepage  Reply with Quote
I didn't see this KB article mentioned yet:
http://support.microsoft.com/kb/321185

Also, there is a pretty comprehensive list here:
http://www.krell-software.com/mssql-builds.asp

..and of course, there is the system stored procedure sp_server_info which displays some pretty detailed information.

HTH,

-pjstreiff
Go to Top of Page

919
Starting Member

1 Posts

Posted - 02/06/2009 :  11:14:41  Show Profile  Reply with Quote
9.00.3068.00 SQL Server 2005 Express Edition with Advanced Services
Go to Top of Page

sawmeonline
Starting Member

1 Posts

Posted - 02/26/2009 :  19:18:46  Show Profile  Reply with Quote
Hi,

Iam using visual basic 6.0 & SQL Server 2000 RTM [8.00.194]

Is it required to install service pack 4.

Iam getting this "odbc sql server driver dbnetlib connectionwrite wrapperwrite()" periodically, say for example, long process.

can you tell me about RTM?

Thanks in advance,
sara
Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 1.38 seconds. Powered By: Snitz Forums 2000