What is SQL2005 final build number?

7 Feb 2006 1:33 AM

Clayton Sutton

Can someone please tell me what the fnal build number is for MSSQL 2005? I
just took over a network where the old admin did a lot of playing around on
the network and installed a lot of "Test" software. This includes MSSQL
2005. There has also been a change in some of managment and no one knows
what the old admin has done on the network. He installed MSSQL 2005 but no
one know if it's a bata copy or if they bought lic(s) for the final product.
I have our acct. dept. looking for a PO but in the mean time I just want to
know if we are running a bata copy or not.

Thanks for your help,

Clayton

7 Feb 2006 2:03 AM

Mike Hodgson

SQL Server 2005 RTM is build number 9.0.1399.06.

You can see this with

select serverproperty('ProductVersion')

This should also be helpful (if it's a pre-RTM copy this will tell you):

select serverproperty('ProductLevel')

--
*mike hodgson*
http://sqlnerd.blogspot.com

Clayton Sutton wrote:

Show quote

>Can someone please tell me what the fnal build number is for MSSQL 2005? I
>just took over a network where the old admin did a lot of playing around on
>the network and installed a lot of "Test" software. This includes MSSQL
>2005. There has also been a change in some of managment and no one knows
>what the old admin has done on the network. He installed MSSQL 2005 but no
>one know if it's a bata copy or if they bought lic(s) for the final product.
>I have our acct. dept. looking for a PO but in the mean time I just want to
>know if we are running a bata copy or not.
>
>
>Thanks for your help,
>
>
>Clayton
>
>
>
>

7 Feb 2006 5:54 AM

Michael Hotek

Build number
140981639769874631398561986431289756398213763498712634987125987342987.23465.123123.11223.12334.12.233.

Just kidding, it only seems like it. :)

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

Show quote

"Mike Hodgson" <e1mins***@gmail.com> wrote in message
news:O8rmqq4KGHA.3460@TK2MSFTNGP15.phx.gbl...
> SQL Server 2005 RTM is build number 9.0.1399.06.
>
> You can see this with
>
> select serverproperty('ProductVersion')
>
> This should also be helpful (if it's a pre-RTM copy this will tell you):
>
> select serverproperty('ProductLevel')
>
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
>
>
> Clayton Sutton wrote:
>
>>Can someone please tell me what the fnal build number is for MSSQL 2005?
>>I
>>just took over a network where the old admin did a lot of playing around
>>on
>>the network and installed a lot of "Test" software. This includes MSSQL
>>2005. There has also been a change in some of managment and no one knows
>>what the old admin has done on the network. He installed MSSQL 2005 but
>>no
>>one know if it's a bata copy or if they bought lic(s) for the final
>>product.
>>I have our acct. dept. looking for a PO but in the mean time I just want
>>to
>>know if we are running a bata copy or not.
>>
>>
>>Thanks for your help,
>>
>>
>>Clayton
>>
>>
>>
>>
>

7 Feb 2006 11:16 AM

smeg9

Microsoft SQL Server Management Studio                        9.00.1399.00
Microsoft Analysis Services Client Tools                        2005.090.1399.00
Microsoft Data Access Components (MDAC)                        2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML                        2.6 3.0 5.0 6.0
Microsoft Internet Explorer                        7.0.5296.0
Microsoft .NET Framework                        2.0.50727.42

These are my Version numbers.

7 Feb 2006 4:47 PM

Chris Wood

Clayton,

This link gets updated when new builds come along.
http://www.aspfaq.com/sql2005/show.asp?id=20

Chris

Show quote

"Clayton Sutton" <n***@none.com> wrote in message
news:ucr8Ta4KGHA.2696@TK2MSFTNGP14.phx.gbl...
> Can someone please tell me what the fnal build number is for MSSQL 2005?
> I just took over a network where the old admin did a lot of playing around
> on the network and installed a lot of "Test" software. This includes
> MSSQL 2005. There has also been a change in some of managment and no one
> knows what the old admin has done on the network. He installed MSSQL 2005
> but no one know if it's a bata copy or if they bought lic(s) for the final
> product. I have our acct. dept. looking for a PO but in the mean time I
> just want to know if we are running a bata copy or not.
>
>
> Thanks for your help,
>
>
> Clayton
>

7 Feb 2006 7:31 PM

Clayton Sutton

Thanks everyone,

It looks like we are running the real thing. Now I just need to find out if
we paid for it.

Lamar

Show quote

"Clayton Sutton" <n***@none.com> wrote in message
news:ucr8Ta4KGHA.2696@TK2MSFTNGP14.phx.gbl...
> Can someone please tell me what the fnal build number is for MSSQL 2005?
> I just took over a network where the old admin did a lot of playing around
> on the network and installed a lot of "Test" software. This includes
> MSSQL 2005. There has also been a change in some of managment and no one
> knows what the old admin has done on the network. He installed MSSQL 2005
> but no one know if it's a bata copy or if they bought lic(s) for the final
> product. I have our acct. dept. looking for a PO but in the mean time I
> just want to know if we are running a bata copy or not.
>
>
> Thanks for your help,
>
>
> Clayton
>