November 20, 2003 at 7:51 am
Hi,
How do I tell which version (Standard or Enterprise) is installed on my SQL2000 SP3 server?
November 20, 2003 at 7:55 am
just use select @@version through Query Analyser
Paul
November 20, 2003 at 8:00 am
Right-click in EM on the server in question and choose properties.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 20, 2003 at 8:02 am
I guess i'm still old-fashioned !
Paul
November 20, 2003 at 8:05 am
I don't think so, just an alternative way to the same result
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 20, 2003 at 8:06 am
...and you have to choose output in QA to text to see the version at once.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 20, 2003 at 8:13 am
Thanks. Now, how do I get from Standard to Enterprise edition? Will the enterprise edition install just give me the missing functionality?
November 20, 2003 at 8:17 am
What functionality?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 20, 2003 at 8:20 am
i think log shiiping is one thing that is in the enterprise edition but not standard.
Paul
November 20, 2003 at 8:21 am
sorry , i meant log shipping !
November 20, 2003 at 8:38 am
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
November 20, 2003 at 8:40 am
...and it is much more expensive...
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 21, 2003 at 3:30 am
Few other things I think could be important:
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
November 21, 2003 at 10:28 am
To upgrade from standard to enterprise see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_1d7y.asp
Francis
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply