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
 General SQL Server Forums
 New to SQL Server Administration
 what is the meaning of four dot version notation o

Author  Topic 

bala001_sqldba
Starting Member

18 Posts

Posted - 2013-11-18 : 06:27:51
hello,

what is the meaning of four dot version notation of SQL server 9.00.1399.06? and what does it stand for

actually, i have got for first two dpt notation.. for instance, 9.00.1399.06 in which 9 stands for major version and 00 stands for minor version.. what about the other two dots


thanks for your time

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-11-18 : 08:59:40
It's Major, Minor, Build, and Revision numbers. It is a standard publish versioning scheme that Microsoft uses in applications generated using Visual Studio. http://msdn.microsoft.com/en-us/library/system.version(v=vs.110).aspx (I am making an educated guess that Microsoft builds SQL Server using Visual Studio).

What each of those versions refers to, see here:
http://support.microsoft.com/kb/321185
http://www.sqlteam.com/article/sql-server-versions
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-11-18 : 12:40:51
9.00.1399 is the RTM version of SQL Server 2005. You need to install service pack 4 and then consider one of the latest hotfixes for it. We run build 9.00.5294 on our SQL Server 2005 instances.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -