Wiki Home

SQL Server Editions


Namespace: WIN_COM_API
SQL Server is available in several editions, including Desktop, Personal, Standard, Developer and Enterprise.

For a comparison of the various editions, see the topic Features Supported by the Editions of SQL Server 2000 in Books Online, or at this MSDN entry:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp

To determine programmatically what edition of SQL Server you're connected to, look at the T-SQL SERVERPROPERTY command (the Edition and Engine Edition properties).

Contributors: Steve Sawyer

Here's a comparison of various editions of SQL Server 2005 on MSDN:

http://msdn2.microsoft.com/en-us/library/ms143761.aspx

Contributors: Bruce Allen
( Topic last updated: 2006.06.29 12:42:46 PM )