sql server free versions

Question

sql server free versions

sqlfriend

SSC Guru

Points: 52794
More actions
June 6, 2011 at 1:57 pm

#238718

I would pull the servers version of our sql servers from central management servers. But would like to find out those are in free version, like sql express and msde.
If I use query:
SELECT
SERVERPROPERTY('Edition') as Edition
SERVERPROPERTY('ProductLevel') as ProductLevel
What the result will show for SQL express, and for MSDE version.
Thanks

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Jim Murphy SSCertifiable Points: 6263 More actions · Answer 1

I have not tried this on Express edition, but I think it will probably work just fine.

This statement does work on SQL2000, therefore, there should be no problem with it running on MSDE, so long as the version of MSDE is 2000.

Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph

Orlando Colamatteo SSC Guru Points: 182293 More actions · Answer 2

Possible values for Edition property:

http://msdn.microsoft.com/en-us/library/ms174396.aspx

Express Editions:

> 'Express Edition'

> 'Express Edition with Advanced Services'

MSDE:

> 'Desktop Engine' (Not available for SQL Server 2005 and later versions.)

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

For SQL Server 2005 Expess Edition

Edition ProductLevel

Express Edition with Advanced ServicesSP4

For SQL Server 2000

Personal Edition SP3

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Orlando Colamatteo SSC Guru Points: 182293 More actions · Answer 4

IIRC Personal Edition was not free.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Jim Murphy SSCertifiable Points: 6263 More actions · Answer 5

For that matter, MSDE also wasn't 'free' was it? It came with VB6 and earlier, and other MSDN-like products and whatnot. But I don't think it was a free download, as much as Visual Studio is not a 'free' download just because it is on the MSDN downloads list.

Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph

Orlando Colamatteo SSC Guru Points: 182293 More actions · Answer 6

Good one Jim! Is this headed for one of those "It depends on what your definition of 'is' is." conversations? I should know better on a site full of DB folks 😉

I was thinking free to deploy, as in no SQL Server licensing required once set out into the wild, but thanks for reminding me that the whole world does not have "free" access to all the nice things offered by an MSDN subscription. I tend to forget that sometimes because I have been blessed with employers that have seen the value in them so have had access to a license the majority of the last 10 years 😀

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Jim Murphy SSCertifiable Points: 6263 More actions · Answer 7

Oh man. I didn't mean to get overly technical. I hate when folks do that to me.

The old MSDE was free to redistribute [by software developers/IT folks], but they must have 'bought' it somehow. SQLExpress is free to both redistribute and acquire by anyone. And, of course, current non-express versions are neither free to redistribute nor free to acquire.

OK. I think we beat this dead horse.

Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph