What Version of SQL2000 is installed?

Question

Post reply

What Version of SQL2000 is installed?

tcook

Old Hand

Points: 364
More actions
November 20, 2003 at 7:51 am

#65739

Hi,
How do I tell which version (Standard or Enterprise) is installed on my SQL2000 SP3 server?

Viewing 14 posts - 1 through 13 (of 13 total)

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

paul_richardson SSCarpal Tunnel Points: 4594 More actions · Answer 1

paul_richardson

SSCarpal Tunnel

Points: 4594

November 20, 2003 at 7:55 am

#482865

just use select @@version through Query Analyser

Paul

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

Right-click in EM on the server in question and choose properties.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

paul_richardson SSCarpal Tunnel Points: 4594 More actions · Answer 3

paul_richardson

SSCarpal Tunnel

Points: 4594

November 20, 2003 at 8:02 am

#482876

I guess i'm still old-fashioned !

Paul

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

I don't think so, just an alternative way to the same result

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

...and you have to choose output in QA to text to see the version at once.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

tcook Old Hand Points: 364 More actions · Answer 6

Thanks. Now, how do I get from Standard to Enterprise edition? Will the enterprise edition install just give me the missing functionality?

Frank Kalis SSC Guru Points: 111183 More actions · Answer 7

What functionality?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

paul_richardson SSCarpal Tunnel Points: 4594 More actions · Answer 8

i think log shiiping is one thing that is in the enterprise edition but not standard.

Paul

paul_richardson SSCarpal Tunnel Points: 4594 More actions · Answer 9

paul_richardson

SSCarpal Tunnel

Points: 4594

November 20, 2003 at 8:21 am

#482888

sorry , i meant log shipping !

tcook Old Hand Points: 364 More actions · Answer 10

Per MS "Features by Edition" white paper - Enterprise Edition has the following additional features over Std. Edition.

Advanced Analysis Features for OLAP

Comprhensive Analysis Services

Distributed Partitioned Views

High availability

Indexed Views

VI SAN

Web enabled analysis

Frank Kalis SSC Guru Points: 111183 More actions · Answer 11

...and it is much more expensive...

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

georgedo Right there with Babe Points: 771 More actions · Answer 12

Few other things I think could be important:

Each instance in Standard Edition requires separate license while Enterprise allows to run unlimited number of instances
Failover clustering
Parallel CREATE INDEX
OLAP HTTP Internet Support

These are features that were important for the client to decide on edition, complete list can be found in BOL.

And, not to forget, "it is much more expensive..."

--
George

fhanlon SSChampion Points: 13131 More actions · Answer 13

To upgrade from standard to enterprise see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_1d7y.asp

Francis