What is the build number of SQL Server 2005 Express

microsoft.public.sqlserver.programming

6 Apr 2006 7:24 PM

austinajit@gmail.com

Hi,

Can anyone tell me the (build) version number of SQL Server 2005
Express?

Thanks,
Austin.

6 Apr 2006 8:32 PM

Steve Zimmelman

If you have it installed, this should return it.

Select CONVERT( VARCHAR(20), SERVERPROPERTY( N'PRODUCTVERSION'))

-Steve-

<austina***@gmail.com> wrote in message
Show quote

news:1144351463.367270.218190@e56g2000cwe.googlegroups.com...
> Hi,
>
> Can anyone tell me the (build) version number of SQL Server 2005
> Express?
>
> Thanks,
> Austin.
>

6 Apr 2006 8:20 PM

austinajit@gmail.com

I don't have it installed in my machine. Can anyone give me the number
if you have already installed?

Thanks,
Austin.

6 Apr 2006 8:32 PM

Aaron Bertrand [SQL Server MVP]

RTM = 9.00.1399.06

There are several hotfixes that have been released since RTM. See
http://www.aspfaq.com/sql2005/show.asp?id=20

<austina***@gmail.com> wrote in message
Show quote

news:1144354846.894063.167840@u72g2000cwu.googlegroups.com...
>I don't have it installed in my machine. Can anyone give me the number
> if you have already installed?
>
> Thanks,
> Austin.
>