Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: SQL Server Versions

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-17 : 23:52:22
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

1139 Posts

Posted - 2002-03-18 : 09:02:00
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

12 Posts

Posted - 2002-03-19 : 01:27:50
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 - 2002-03-21 : 10:44:56
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 - 2002-03-21 : 10:51:47
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

201 Posts

Posted - 2002-04-02 : 09:56:22
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
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-03-17 : 17:32:28
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

413 Posts

Posted - 2004-03-18 : 03:48:49
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

198 Posts

Posted - 2006-02-16 : 10:49:33
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

22859 Posts

Posted - 2006-05-23 : 01:42:37
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 - 2007-01-14 : 07:49:31
better source:
Microsoft SQL Server 2005, 2000 and 7.0 Builds:
[url]http://SQLServerBuilds.blogspot.com[/url]
Go to Top of Page

Ian83

5 Posts

Posted - 2007-01-20 : 09:51:18
(Spam Removed)
Go to Top of Page

Sinds
Starting Member

1 Post

Posted - 2008-03-03 : 07:53:12
Anybody know what SP is 9.00.1399.06 ?
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2008-03-03 : 07:59:38
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

52 Posts

Posted - 2009-01-28 : 14:45:01
Version 8.0.2050 released recently for SQL 2000.
Go to Top of Page

GaryF
Starting Member

4 Posts

Posted - 2009-01-30 : 10:12:24
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 Post

Posted - 2009-02-04 : 10:42:31
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 - 2009-02-05 : 14:46:47
I usually use this website

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

pjstreiff
Starting Member

12 Posts

Posted - 2009-02-06 : 09:25:37
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 Post

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

sawmeonline
Starting Member

1 Post

Posted - 2009-02-26 : 19:18:46
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
    Next Page

- Advertisement -