Is there any reason why I should use SQL Server Standard over Express for a simple web-based site? As far as I can tell, Express offers tables,.
Active11 months ago
I've come across this page http://www.microsoft.com/en-us/download/details.aspx?id=29062 and I am a bit confused about the different versions here.
So I would like to know what is the difference between
SQLEXPR_x64_ENU.exe
SQLEXPRADV_x64_ENU.exe
SQLEXPRWT_x64_ENU.exe
3,91755 gold badges1616 silver badges3434 bronze badges
RushinoRushino4,6981212 gold badges4545 silver badges8686 bronze badges
3 Answers
Scroll down on that page and you'll see:
Express with Tools (with LocalDB) Includes the database engine and SQL Server Management Studio Express)
This package contains everything needed to install and configure SQL Server as a database server. Choose either LocalDB or Express depending on your needs above.
This package contains everything needed to install and configure SQL Server as a database server. Choose either LocalDB or Express depending on your needs above.
That's the
SQLEXPRWT_x64_ENU.exe
download.... (WT = with tools)Express with Advanced Services (contains the database engine, Express Tools, Reporting Services, and Full Text Search)
This package contains all the components of SQL Express. This is a larger download than “with Tools,” as it also includes both Full Text Search and Reporting Services.
This package contains all the components of SQL Express. This is a larger download than “with Tools,” as it also includes both Full Text Search and Reporting Services.
That's the
SQLEXPRADV_x64_ENU.exe
download ... (ADV = Advanced Services)The
marc_smarc_sSQLEXPR_x64_ENU.exe
file is just the database engine - no tools, no Reporting Services, no fulltext-search - just barebones engine.606k138138 gold badges11601160 silver badges12921292 bronze badges
This link goes to the best comparison chart around, directly from the Microsoft. It compares ALL aspects of all MS SQL server editions. To compare three editions you are asking about, just focus on the last three columns of every table in there.
Summary compiled from the above document:
miroxlavmiroxlav8,79544 gold badges3939 silver badges7676 bronze badges
This link might be better:
Phillip SennPhillip Senn20.8k7878 gold badges220220 silver badges343343 bronze badges
protected by Community♦Dec 14 '15 at 11:16
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Would you like to answer one of these unanswered questions instead?
Not the answer you're looking for? Browse other questions tagged sql-server-2012-expresssql-server-2008-express or ask your own question.
Active8 months ago
I am running SQL Server 2005 but I am unsure which edition this is. How can I decide what edition (Express, Standard, Enterprise etc) is running on the machine?
gyuriscgyurisc6,2811515 gold badges6060 silver badges9090 bronze badges
5 Answers
Sample Output
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 (Build 7600: )
If you just want to get the edition, you can use:
To use in an automated script, you can get the edition ID, which is an integer:
![Sql express 2017 limitations Sql express 2017 limitations](https://msdnshared.blob.core.windows.net/media/2016/11/Columnstore_CPSA-1024x380.jpg)
- -1253826760 = Desktop
- -1592396055 = Express
- -1534726760 = Standard
- 1333529388 = Workgroup
- 1804890536 = Enterprise
- -323382091 = Personal
- -2117995310 = Developer
- 610778273 = Enterprise Evaluation
- 1044790755 = Windows Embedded SQL
- 4161255391 = Express with Advanced Services
359k7676 gold badges794794 silver badges762762 bronze badges
I use this query here to get all relevant info (relevant for me, at least :-)) from SQL Server:
That gives you an output something like this:
marc_smarc_s606k138138 gold badges11601160 silver badges12921292 bronze badges
You can get just the edition name by using the following steps.
- Open 'SQL Server Configuration Manager'
- From the List of SQL Server Services, Right Click on 'SQL Server (Instance_name)' and Select Properties.
- Select 'Advanced' Tab from the Properties window.
- Verify Edition Name from the 'Stock Keeping Unit Name'
- Verify Edition Id from the 'Stock Keeping Unit Id'
- Verify Service Pack from the 'Service Pack Level'
- Verify Version from the 'Version'
Community♦
Prashant VadherPrashant Vadher
You can get just the edition (plus under individual properties) using SERVERPROPERTY
e.g.
Quote (for 'Edition'):
Installed product edition of the instance of SQL Server. Use the value of this property to determine the features and the limits, such as maximum number of CPUs, that are supported by the installed product.
Returns:
'Desktop Engine' (Not available for SQL Server 2005.)
'Developer Edition'
'Enterprise Edition'
'Enterprise Evaluation Edition'
'Personal Edition'(Not available for SQL Server 2005.)
'Standard Edition'
'Express Edition'
'Express Edition with Advanced Services'
'Workgroup Edition'
'Windows Embedded SQL'
Base data type: nvarchar(128)
AdaTheDevAdaTheDevReturns:
'Desktop Engine' (Not available for SQL Server 2005.)
'Developer Edition'
'Enterprise Edition'
'Enterprise Evaluation Edition'
'Personal Edition'(Not available for SQL Server 2005.)
'Standard Edition'
'Express Edition'
'Express Edition with Advanced Services'
'Workgroup Edition'
'Windows Embedded SQL'
Base data type: nvarchar(128)
112k2323 gold badges171171 silver badges179179 bronze badges
Hossein KohzadiHossein Kohzadi
![Sql Express Vs Standard Sql Express Vs Standard](https://cdn.rd.gt/assets/products/sql-toolbelt/images/hero-sql-toolbelt.png)