Knowledge (XXG)

SQL Server Express

Source đź“ť

383: 2505: 211:
1 GB of RAM (runs on a system with higher RAM amount, but uses only at most 1 GB per instance of SQL Server Database Engine. "Recommended: Express Editions: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.").
189:
SQL Server Express provides many of the features of the paid, full versions of Microsoft SQL Server database management system. However it has technical restrictions that make it unsuitable for some large-scale deployments. Differences in the Express product include:
180:
is a version of Microsoft SQL Server Express, on-demand managed instance of the SQL Server engine. It is targeted to developers, and has the following restrictions: up to 10 GB database size and only local connections (network connections are not supported).
194:
Maximum database size of 10 GB per database in SQL Server 2019, SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, and 2008 R2 Express (4 GB for SQL Server 2008 Express and earlier; compared to 2 GB in the former
330:
In the Free 2005 Express version, for example, a standard approach to installation options was provided, as follows. Generally, the SQL 2005 Express installers are packaged with the following consistent naming convention:
532:
Windows Vista Service Pack 2, Windows 7, Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2
605:
Windows 10 TH1 1507 or greater, Windows Server 2016 or greater, Red Hat Enterprise Linux 7.3 or greater, SUSE Enterprise Linux Server v12 SP2, Ubuntu 16.04LTS, Docker Engine 1.8+ (on Windows, Mac, or Linux)
212:
Express with Advanced Services has a limit of 4 GB per instance of Reporting Services (not available on other Express variants). Analysis Services is not available for any Express variant.
222:, the Express product does not include a concurrent workload-governor to "limit performance if the database engine receives more work than is typical of a small number of users." 1641: 669: 2527: 664: 550:
Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows 10, Windows Server 2008 SP2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2
515:
Windows XP, Windows Vista, Windows 7, Windows 8, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2
1589: 481:
Windows 2000 Service Pack 4, Windows XP Service Pack 2, Windows Server 2003 Service Pack, Windows 7 Service Pack 1 (only SQL Server 2005 Express Edition SP4)
199:). The limit applies per database (log files excluded); but in some scenarios users can access more data through the use of multiple interconnected databases. 1001: 498:
Windows XP Service Pack 2, Windows XP Service Pack 3, Windows Vista, Windows Vista Service Pack 1, Windows Server 2003 Service Pack 2, Windows Server 2008
1634: 2294: 246: 2041: 2036: 1553: 163: 122: 374:
These optional variants have gone through several service packs (SP), and each SP installer can be used without using the older ones first:
2537: 2532: 2508: 1688: 1627: 767: 291:
This version supports silent installation, requires no management and it is compatible with other editions of SQL Server at the API level.
813: 792: 1766: 1028: 297:
LocalDB limits to local system only and supports no remote connections. To connect this version it is needs special connection string.
144: 2330: 2185: 1937: 2325: 2200: 1678: 322:
edition (first introduced relatively late in Q2 2006 compared to the original release) with a reduced-functionality version of
268: 1942: 1922: 1693: 174:
product, which was shipped with SQL Server 2000. The "Express" branding has been used since the release of SQL Server 2005.
2320: 1890: 1878: 1776: 323: 1910: 2289: 2233: 734: 300:
It is possible create several instances of the LocalDB for different applications. Default instance names 'SqlLocalDB'.
229: 2381: 2315: 2205: 2190: 1957: 263: 41: 2238: 2093: 2419: 2361: 2228: 2195: 1947: 1734: 1522: 1005: 2245: 2006: 1714: 70: 2487: 1665: 259:
Features available in SQL Server "Standard" and better editions but absent from SQL Server Express include:
1895: 981:"Download Microsoft® SQL Server® 2012 Service Pack 1 (SP1) Express from Official Microsoft Download Center" 2470: 2356: 2001: 1868: 1823: 2414: 2071: 2031: 1855: 1808: 1788: 1609: 1327: 710: 689: 1599: 1572: 914:"Hardware and Software Requirements for Installing SQL Server 2014 - SQL Server | Microsoft Docs" 846: 690:"Hardware and Software Requirements for Installing SQL Server 2014 - SQL Server | Microsoft Docs" 584:
Windows 8, Windows 8.1, Windows 10, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016*,
2271: 2250: 2141: 2098: 654: 567:
Windows 8, Windows 8.1, Windows 10, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016
160: 134: 1614: 1417: 1251: 913: 2386: 1793: 1781: 826: 117: 889:"How SQL Server 2005 Express Edition determines the CPU count and uses the CPUs during processing" 112:
English, Chinese, French, German, Italian, Japanese, Korean, Portuguese (Brazil), Russian, Spanish
2284: 2223: 2011: 1803: 1729: 1673: 1499: 1462: 1438: 1348: 1104: 980: 955: 934: 639: 283: 102: 97: 1276: 1179: 1053: 166:
that is free to download, distribute and use. It comprises a database specifically targeted for
1200: 1128: 2475: 2180: 2156: 2103: 1873: 1771: 659: 86: 2351: 2168: 1744: 1054:"Download Microsoft SQL Server 2005 Express Edition from Official Microsoft Download Center" 586:
Red Hat Enterprise Linux 7.3 or 7.4, SUSE Enterprise Linux Server v12 SP2, Ubuntu 16.04LTS,
129: 81: 1372: 2492: 2086: 1860: 1798: 1709: 167: 1201:"Download Microsoft SQL Server 2008 R2 - Express from Official Microsoft Download Center" 866: 396:
Please help update this article to reflect recent events or newly available information.
2455: 2021: 1967: 935:"Editions and supported features of SQL Server 2016 - SQL Server | Microsoft Docs" 1277:"Download Microsoft® SQL Server® 2012 Express from Official Microsoft Download Center" 1180:"Download Microsoft® SQL Server® 2008 Express from Official Microsoft Download Center" 225:
SQL Server Express includes several GUI tools for database management. These include:
2521: 2346: 2215: 2151: 2076: 1952: 1683: 1129:"Download Microsoft SQL Server 2008 Express from Official Microsoft Download Center" 2445: 2136: 2131: 1962: 1813: 1594: 1306: 1230: 1158: 1485: 1396: 1083: 1915: 1536: 2146: 2066: 2016: 1991: 1979: 1974: 1749: 1619: 364:
SQL Server Management Studio Express (SSMSE) + Reporting and Full Text Queries
25: 294:
LocalDB runs as non-admin user, requires no configuration or administration.
2450: 2429: 2175: 1905: 1504: 1467: 1281: 1205: 1133: 1058: 851: 370:
Has the basics and SSMSE and Business Intelligence Development Studio (BIDS)
338:
Has installers for BOTH 32-bit and 64-bit processors, but is a basic install
156: 30: 1900: 2404: 1996: 1883: 1724: 888: 2409: 2163: 2126: 2081: 2026: 1984: 1833: 1828: 1739: 711:"About the SQL Server License Terms - SQL Server | Microsoft Docs" 1252:"Hardware and Software Requirements for Installing SQL Server 2008 R2" 437:
CLI Microsoft® SQL Server Express LocalDB (LocalDB manipulation tool).
344:
Has ONLY the installer for 32-bit processors (still the basic install)
2424: 1761: 1754: 649: 1604: 423:
Service Pack 4 (SP4) versions all carry the version number 9.00.5000
420:
Service Pack 3 (SP3) versions all carry the version number 9.00.4035
414:
Originals of the above files all carry the version number 9.0.1399.6
170:
and smaller-scale applications. The product traces its roots to the
1418:"Hardware and Software Requirements for Installing SQL Server 2014" 1328:"Hardware and Software Requirements for Installing SQL Server 2012" 417:
Service Pack 2 (SP2) versions all carry the version number 9.0.3042
232:– since 2012 SP1; before that, only a stripped-down version called 74: 2465: 2460: 2108: 1932: 1818: 1719: 90: 1615:
Hardware and Software Requirements for Installing SQL Server 2014
1610:
Hardware and Software Requirements for Installing SQL Server 2012
2299: 2118: 1927: 959: 892: 644: 253: 219: 196: 171: 1623: 2480: 376: 1023: 1021: 1019: 1017: 1015: 827:"Features Supported by the Editions of SQL Server 2008 R2" 629:
Does not include Windows Server 2016 "Essentials" Edition
354:
SQL Server Management Studio Express (SSMSE) (2008 R2)
762: 760: 758: 756: 754: 350:
Has installers for BOTH 32-bit and 64-bit processors
867:"SQL Server Express with Advanced Services Features" 729: 727: 670:
Comparison of relational database management systems
308:
Microsoft makes SQL Server Express N1 available as:
2438: 2395: 2374: 2339: 2308: 2270: 2263: 2214: 2117: 2059: 2050: 1848: 1702: 1664: 1655: 140: 128: 116: 108: 96: 80: 66: 40: 24: 1231:"Microsoft Support Lifecycle (SQL Server 2008 R2)" 47:SQL Server 2022 Express / November 4, 2019 1600:SQL Server 2012 Comparison of features by edition 1567: 1565: 1563: 208:Single physical CPU, but multiple cores allowable 768:"Announcing SQL Server 2012 Express LocalDB RC0" 431:Microsoft® SQL Server Express LocalDB Installer. 1573:"Microsoft Support Lifecycle (SQL Server 2022)" 1554:"Microsoft Support Lifecycle (SQL Server 2019)" 1523:"Microsoft Support Lifecycle (SQL Server 2017)" 1486:"Microsoft Support Lifecycle (SQL Server 2016)" 1397:"Microsoft Support Lifecycle (SQL Server 2014)" 1307:"Microsoft Support Lifecycle (SQL Server 2012)" 1159:"Microsoft Support Lifecycle (SQL Server 2008)" 1084:"Microsoft Support Lifecycle (SQL Server 2005)" 588:Docker Engine 1.8+ (on Windows, Mac, or Linux) 1225: 1223: 1029:"Introducing LocalDB, an improved SQL Express" 793:"Introducing LocalDB, an improved SQL Express" 665:List of relational database management systems 288:SQL Server Express LocalDB announced at 2011. 1635: 447:Microsoft SQL Server Express version history 256:generally lacked basic GUI management tools, 8: 1537:"Download Microsoft SQL Server 2019 Express" 1500:"Download Microsoft SQL Server 2017 Express" 1463:"Download Microsoft SQL Server 2016 Express" 1373:"Download Microsoft SQL Server 2014 Express" 19: 1548: 1546: 1517: 1515: 1480: 1478: 1391: 1389: 1301: 1299: 1153: 1151: 1105:"Microsoft SQL Server 2005 Express Edition" 1078: 1076: 312:An integrated edition with management tools 2267: 2056: 1661: 1642: 1628: 1620: 1595:Microsoft SQL Server Express documentation 242:SQL Server Surface Area Configuration tool 18: 1349:"Microsoft® SQL Server® 2012 SP2 Express" 320:SQL Server Express with Advanced Services 2295:Business Intelligence Development Studio 445: 247:Business Intelligence Development Studio 2528:Proprietary database management systems 956:"The SQL Server 2000 Workload Governor" 681: 1590:Microsoft SQL Server Express downloads 326:and with full-text search capabilities 1439:"Microsoft® SQL Server® 2014 Express" 814:Disable SQL Server VSS Writer service 164:relational database management system 123:Relational database management system 16:Relational database management system 7: 234:SQL Server Management Studio Express 178:Microsoft SQL Server Express LocalDB 205:Restricted hardware usage limits: 14: 2504: 2503: 937:. Msdn.microsoft.com. 2017-05-24 713:. Msdn.microsoft.com. 2017-05-24 381: 239:SQL Server Configuration Manager 218:Unlike the predecessor product, 172:Microsoft Database Engine (MSDE) 2387:Team Foundation Version Control 469:SQL Server 2005 Express Edition 1: 324:SQL Server Reporting Services 1002:"How do I Manage SQL Server" 464:Supported operating systems 458:Mainstream support end date 230:SQL Server Management Studio 153:Microsoft SQL Server Express 20:Microsoft SQL Server Express 2538:Microsoft database software 2533:Microsoft server technology 1650:Microsoft development tools 1182:. Microsoft.com. 2009-02-08 983:. Microsoft.com. 2012-11-09 202:No SQL Server Agent service 2554: 847:"Compare Edition Features" 795:. Microsoft. July 12, 2011 503:SQL Server 2008 R2 Express 461:Extended support end date 281: 2501: 2362:Extensible Storage Engine 1767:Robotics Developer Studio 1605:SQL Server Express WebLog 1443:Microsoft Download Center 1353:Microsoft Download Center 1109:Microsoft Download Center 390:This article needs to be 315:Core database-engine only 62: 36: 2186:Communication Foundation 611:SQL Server 2022 Express 593:SQL Server 2019 Express 252:The predecessor product 2488:Windows Package Manager 2201:Presentation Foundation 1035:. Microsoft. 2011-07-12 774:. Microsoft. 2011-11-28 572:SQL Server 2017 Express 555:SQL Server 2016 Express 538:SQL Server 2014 Express 520:SQL Server 2012 Express 486:SQL Server 2008 Express 2471:Web Platform Installer 2357:Access Database Engine 1824:Native Image Generator 1689:Tools for Applications 273:Notification Services 49:; 4 years ago 2099:Xbox Development Kit 1684:Team System Profiler 916:. Msdn.microsoft.com 692:. Msdn.microsoft.com 655:Microsoft SQL Server 269:Integration Services 135:Proprietary software 2206:Workflow Foundation 2191:Identity Foundation 1777:SharePoint Designer 448: 367:SQLEXPR_TOOLKIT.EXE 21: 1804:Windows App Studio 1256:msdn.microsoft.com 640:SQL Server Compact 446: 284:SQL Server Compact 103:.NET Framework 4.0 2515: 2514: 2476:Windows Installer 2382:Visual SourceSafe 2370: 2369: 2290:Management Studio 2259: 2258: 2104:Windows Installer 1844: 1843: 735:"What is LocalDB" 660:Microsoft Servers 626: 625: 411: 410: 264:Analysis Services 150: 149: 145:www.microsoft.com 87:Microsoft Windows 2545: 2507: 2506: 2352:Microsoft Access 2268: 2169:Entity Framework 2057: 1694:Tools for Office 1662: 1644: 1637: 1630: 1621: 1577: 1576: 1569: 1558: 1557: 1550: 1541: 1540: 1533: 1527: 1526: 1519: 1510: 1509: 1496: 1490: 1489: 1482: 1473: 1472: 1459: 1453: 1452: 1450: 1449: 1435: 1429: 1428: 1426: 1424: 1414: 1408: 1407: 1405: 1403: 1393: 1384: 1383: 1381: 1379: 1369: 1363: 1362: 1360: 1359: 1345: 1339: 1338: 1336: 1334: 1324: 1318: 1317: 1315: 1313: 1303: 1294: 1293: 1291: 1289: 1273: 1267: 1266: 1264: 1263: 1248: 1242: 1241: 1239: 1237: 1227: 1218: 1217: 1215: 1213: 1197: 1191: 1190: 1188: 1187: 1176: 1170: 1169: 1167: 1165: 1155: 1146: 1145: 1143: 1141: 1125: 1119: 1118: 1116: 1115: 1101: 1095: 1094: 1092: 1090: 1080: 1071: 1070: 1068: 1066: 1050: 1044: 1043: 1041: 1040: 1025: 1010: 1009: 1004:. Archived from 998: 992: 991: 989: 988: 977: 971: 970: 968: 967: 952: 946: 945: 943: 942: 931: 925: 924: 922: 921: 910: 904: 903: 901: 900: 885: 879: 878: 876: 874: 863: 857: 856: 843: 837: 836: 834: 833: 823: 817: 811: 805: 804: 802: 800: 789: 783: 782: 780: 779: 764: 749: 748: 746: 745: 731: 722: 721: 719: 718: 707: 701: 700: 698: 697: 686: 449: 406: 403: 397: 385: 384: 377: 155:is a version of 82:Operating system 57: 55: 50: 22: 2553: 2552: 2548: 2547: 2546: 2544: 2543: 2542: 2518: 2517: 2516: 2511: 2497: 2493:Microsoft Store 2434: 2420:Script Debugger 2397: 2391: 2366: 2335: 2304: 2255: 2210: 2113: 2087:Managed DirectX 2052: 2046: 1840: 1799:Windows App SDK 1735:Macro Assembler 1698: 1657: 1651: 1648: 1586: 1581: 1580: 1571: 1570: 1561: 1552: 1551: 1544: 1535: 1534: 1530: 1521: 1520: 1513: 1498: 1497: 1493: 1484: 1483: 1476: 1461: 1460: 1456: 1447: 1445: 1437: 1436: 1432: 1422: 1420: 1416: 1415: 1411: 1401: 1399: 1395: 1394: 1387: 1377: 1375: 1371: 1370: 1366: 1357: 1355: 1347: 1346: 1342: 1332: 1330: 1326: 1325: 1321: 1311: 1309: 1305: 1304: 1297: 1287: 1285: 1275: 1274: 1270: 1261: 1259: 1250: 1249: 1245: 1235: 1233: 1229: 1228: 1221: 1211: 1209: 1199: 1198: 1194: 1185: 1183: 1178: 1177: 1173: 1163: 1161: 1157: 1156: 1149: 1139: 1137: 1127: 1126: 1122: 1113: 1111: 1103: 1102: 1098: 1088: 1086: 1082: 1081: 1074: 1064: 1062: 1052: 1051: 1047: 1038: 1036: 1027: 1026: 1013: 1000: 999: 995: 986: 984: 979: 978: 974: 965: 963: 954: 953: 949: 940: 938: 933: 932: 928: 919: 917: 912: 911: 907: 898: 896: 895:. November 2008 887: 886: 882: 872: 870: 865: 864: 860: 845: 844: 840: 831: 829: 825: 824: 820: 812: 808: 798: 796: 791: 790: 786: 777: 775: 766: 765: 752: 743: 741: 733: 732: 725: 716: 714: 709: 708: 704: 695: 693: 688: 687: 683: 678: 636: 587: 585: 444: 442:Version history 407: 401: 398: 395: 386: 382: 360:Has the basics 357:SQLEXPR_ADV.EXE 306: 286: 280: 187: 58: 53: 51: 48: 17: 12: 11: 5: 2551: 2549: 2541: 2540: 2535: 2530: 2520: 2519: 2513: 2512: 2502: 2499: 2498: 2496: 2495: 2490: 2485: 2484: 2483: 2473: 2468: 2463: 2458: 2453: 2448: 2442: 2440: 2436: 2435: 2433: 2432: 2427: 2422: 2417: 2412: 2407: 2401: 2399: 2393: 2392: 2390: 2389: 2384: 2378: 2376: 2375:Source control 2372: 2371: 2368: 2367: 2365: 2364: 2359: 2354: 2349: 2343: 2341: 2337: 2336: 2334: 2333: 2328: 2323: 2318: 2312: 2310: 2306: 2305: 2303: 2302: 2297: 2292: 2287: 2282: 2276: 2274: 2265: 2261: 2260: 2257: 2256: 2254: 2253: 2248: 2243: 2242: 2241: 2236: 2226: 2220: 2218: 2216:Device drivers 2212: 2211: 2209: 2208: 2203: 2198: 2193: 2188: 2183: 2178: 2173: 2172: 2171: 2161: 2160: 2159: 2154: 2149: 2144: 2139: 2134: 2123: 2121: 2115: 2114: 2112: 2111: 2106: 2101: 2096: 2091: 2090: 2089: 2079: 2074: 2069: 2063: 2061: 2054: 2048: 2047: 2045: 2044: 2039: 2034: 2029: 2024: 2022:Project Verona 2019: 2014: 2009: 2004: 1999: 1994: 1989: 1988: 1987: 1982: 1972: 1971: 1970: 1965: 1955: 1950: 1945: 1940: 1935: 1930: 1925: 1920: 1919: 1918: 1913: 1908: 1903: 1893: 1888: 1887: 1886: 1881: 1876: 1871: 1863: 1858: 1852: 1850: 1846: 1845: 1842: 1841: 1839: 1838: 1837: 1836: 1831: 1826: 1821: 1816: 1806: 1801: 1796: 1791: 1786: 1785: 1784: 1774: 1769: 1764: 1759: 1758: 1757: 1747: 1742: 1737: 1732: 1727: 1722: 1717: 1715:Expression Web 1712: 1706: 1704: 1700: 1699: 1697: 1696: 1691: 1686: 1681: 1676: 1670: 1668: 1659: 1653: 1652: 1649: 1647: 1646: 1639: 1632: 1624: 1618: 1617: 1612: 1607: 1602: 1597: 1592: 1585: 1584:External links 1582: 1579: 1578: 1559: 1542: 1528: 1511: 1491: 1474: 1454: 1430: 1409: 1385: 1364: 1340: 1319: 1295: 1268: 1258:. 20 July 2015 1243: 1219: 1192: 1171: 1147: 1120: 1096: 1072: 1045: 1033:Microsoft Docs 1011: 1008:on 2010-07-24. 993: 972: 962:. January 2004 947: 926: 905: 880: 858: 838: 818: 806: 784: 772:Microsoft Docs 750: 723: 702: 680: 679: 677: 674: 673: 672: 667: 662: 657: 652: 647: 642: 635: 632: 631: 630: 624: 623: 621: 618: 615: 612: 608: 607: 603: 600: 597: 594: 590: 589: 582: 579: 576: 573: 569: 568: 565: 562: 559: 556: 552: 551: 548: 545: 542: 539: 535: 534: 530: 527: 524: 521: 517: 516: 513: 510: 507: 504: 500: 499: 496: 493: 490: 487: 483: 482: 479: 476: 473: 470: 466: 465: 462: 459: 456: 453: 443: 440: 439: 438: 435: 434:SQLLocalDB.exe 432: 429: 428:SqlLocalDB.msi 425: 424: 421: 418: 415: 409: 408: 389: 387: 380: 372: 371: 368: 365: 358: 355: 348: 345: 342: 339: 336: 328: 327: 316: 313: 305: 302: 279: 276: 275: 274: 271: 266: 250: 249: 243: 240: 237: 216: 215: 214: 213: 209: 203: 200: 186: 183: 148: 147: 142: 138: 137: 132: 126: 125: 120: 114: 113: 110: 106: 105: 100: 94: 93: 84: 78: 77: 68: 64: 63: 60: 59: 46: 44: 42:Stable release 38: 37: 34: 33: 28: 15: 13: 10: 9: 6: 4: 3: 2: 2550: 2539: 2536: 2534: 2531: 2529: 2526: 2525: 2523: 2510: 2500: 2494: 2491: 2489: 2486: 2482: 2479: 2478: 2477: 2474: 2472: 2469: 2467: 2464: 2462: 2459: 2457: 2454: 2452: 2449: 2447: 2444: 2443: 2441: 2437: 2431: 2428: 2426: 2423: 2421: 2418: 2416: 2413: 2411: 2408: 2406: 2403: 2402: 2400: 2394: 2388: 2385: 2383: 2380: 2379: 2377: 2373: 2363: 2360: 2358: 2355: 2353: 2350: 2348: 2347:Visual FoxPro 2345: 2344: 2342: 2338: 2332: 2329: 2327: 2324: 2322: 2319: 2317: 2314: 2313: 2311: 2307: 2301: 2298: 2296: 2293: 2291: 2288: 2286: 2283: 2281: 2278: 2277: 2275: 2273: 2269: 2266: 2262: 2252: 2249: 2247: 2244: 2240: 2237: 2235: 2232: 2231: 2230: 2227: 2225: 2222: 2221: 2219: 2217: 2213: 2207: 2204: 2202: 2199: 2197: 2194: 2192: 2189: 2187: 2184: 2182: 2179: 2177: 2174: 2170: 2167: 2166: 2165: 2162: 2158: 2155: 2153: 2150: 2148: 2145: 2143: 2140: 2138: 2135: 2133: 2130: 2129: 2128: 2125: 2124: 2122: 2120: 2116: 2110: 2107: 2105: 2102: 2100: 2097: 2095: 2092: 2088: 2085: 2084: 2083: 2080: 2078: 2075: 2073: 2070: 2068: 2065: 2064: 2062: 2058: 2055: 2049: 2043: 2040: 2038: 2035: 2033: 2030: 2028: 2025: 2023: 2020: 2018: 2015: 2013: 2010: 2008: 2005: 2003: 2000: 1998: 1995: 1993: 1990: 1986: 1983: 1981: 1978: 1977: 1976: 1973: 1969: 1966: 1964: 1961: 1960: 1959: 1956: 1954: 1953:Visual FoxPro 1951: 1949: 1946: 1944: 1941: 1939: 1936: 1934: 1931: 1929: 1926: 1924: 1921: 1917: 1914: 1912: 1909: 1907: 1904: 1902: 1899: 1898: 1897: 1894: 1892: 1889: 1885: 1882: 1880: 1877: 1875: 1872: 1870: 1867: 1866: 1865:Visual Basic 1864: 1862: 1859: 1857: 1854: 1853: 1851: 1847: 1835: 1832: 1830: 1827: 1825: 1822: 1820: 1817: 1815: 1812: 1811: 1810: 1807: 1805: 1802: 1800: 1797: 1795: 1792: 1790: 1787: 1783: 1780: 1779: 1778: 1775: 1773: 1770: 1768: 1765: 1763: 1760: 1756: 1753: 1752: 1751: 1748: 1746: 1743: 1741: 1738: 1736: 1733: 1731: 1728: 1726: 1723: 1721: 1718: 1716: 1713: 1711: 1708: 1707: 1705: 1701: 1695: 1692: 1690: 1687: 1685: 1682: 1680: 1677: 1675: 1672: 1671: 1669: 1667: 1666:Visual Studio 1663: 1660: 1654: 1645: 1640: 1638: 1633: 1631: 1626: 1625: 1622: 1616: 1613: 1611: 1608: 1606: 1603: 1601: 1598: 1596: 1593: 1591: 1588: 1587: 1583: 1574: 1568: 1566: 1564: 1560: 1555: 1549: 1547: 1543: 1538: 1532: 1529: 1524: 1518: 1516: 1512: 1507: 1506: 1501: 1495: 1492: 1487: 1481: 1479: 1475: 1470: 1469: 1464: 1458: 1455: 1444: 1440: 1434: 1431: 1419: 1413: 1410: 1398: 1392: 1390: 1386: 1374: 1368: 1365: 1354: 1350: 1344: 1341: 1329: 1323: 1320: 1308: 1302: 1300: 1296: 1284: 1283: 1278: 1272: 1269: 1257: 1253: 1247: 1244: 1232: 1226: 1224: 1220: 1208: 1207: 1202: 1196: 1193: 1181: 1175: 1172: 1160: 1154: 1152: 1148: 1136: 1135: 1130: 1124: 1121: 1110: 1106: 1100: 1097: 1085: 1079: 1077: 1073: 1061: 1060: 1055: 1049: 1046: 1034: 1030: 1024: 1022: 1020: 1018: 1016: 1012: 1007: 1003: 997: 994: 982: 976: 973: 961: 957: 951: 948: 936: 930: 927: 915: 909: 906: 894: 890: 884: 881: 868: 862: 859: 854: 853: 848: 842: 839: 828: 822: 819: 815: 810: 807: 794: 788: 785: 773: 769: 763: 761: 759: 757: 755: 751: 740: 736: 730: 728: 724: 712: 706: 703: 691: 685: 682: 675: 671: 668: 666: 663: 661: 658: 656: 653: 651: 648: 646: 643: 641: 638: 637: 633: 628: 627: 622: 619: 616: 613: 610: 609: 604: 601: 598: 595: 592: 591: 583: 580: 577: 574: 571: 570: 566: 563: 560: 557: 554: 553: 549: 546: 543: 540: 537: 536: 531: 528: 525: 522: 519: 518: 514: 511: 508: 505: 502: 501: 497: 494: 491: 488: 485: 484: 480: 477: 474: 471: 468: 467: 463: 460: 457: 455:Release date 454: 451: 450: 441: 436: 433: 430: 427: 426: 422: 419: 416: 413: 412: 405: 393: 388: 379: 378: 375: 369: 366: 363: 359: 356: 353: 349: 347:SQLEXPRWT.EXE 346: 343: 341:SQLEXPR32.EXE 340: 337: 334: 333: 332: 325: 321: 317: 314: 311: 310: 309: 303: 301: 298: 295: 292: 289: 285: 277: 272: 270: 267: 265: 262: 261: 260: 257: 255: 248: 244: 241: 238: 235: 231: 228: 227: 226: 223: 221: 210: 207: 206: 204: 201: 198: 193: 192: 191: 184: 182: 179: 175: 173: 169: 165: 162: 158: 154: 146: 143: 139: 136: 133: 131: 127: 124: 121: 119: 115: 111: 107: 104: 101: 99: 95: 92: 88: 85: 83: 79: 76: 72: 69: 65: 61: 45: 43: 39: 35: 32: 29: 27: 23: 2446:Active Setup 2331:Notification 2309:SQL services 2279: 2142:Dynamic Data 1814:CLR Profiler 1658:environments 1531: 1503: 1494: 1466: 1457: 1446:. Retrieved 1442: 1433: 1421:. Retrieved 1412: 1400:. Retrieved 1376:. Retrieved 1367: 1356:. Retrieved 1352: 1343: 1331:. Retrieved 1322: 1310:. Retrieved 1286:. Retrieved 1280: 1271: 1260:. Retrieved 1255: 1246: 1234:. Retrieved 1210:. Retrieved 1204: 1195: 1184:. Retrieved 1174: 1162:. Retrieved 1138:. Retrieved 1132: 1123: 1112:. Retrieved 1108: 1099: 1087:. Retrieved 1063:. Retrieved 1057: 1048: 1037:. Retrieved 1032: 1006:the original 996: 985:. Retrieved 975: 964:. Retrieved 950: 939:. Retrieved 929: 918:. Retrieved 908: 897:. Retrieved 883: 871:. Retrieved 861: 850: 841: 830:. Retrieved 821: 809: 797:. Retrieved 787: 776:. Retrieved 771: 742:. Retrieved 738: 715:. Retrieved 705: 694:. Retrieved 684: 399: 391: 373: 361: 351: 329: 319: 307: 299: 296: 293: 290: 287: 258: 251: 233: 224: 217: 188: 185:Capabilities 177: 176: 152: 151: 109:Available in 26:Developer(s) 2396:Testing and 2326:Integration 2246:Windows HLK 2072:Silverlight 2067:Windows API 2032:Small Basic 1911:Managed C++ 1856:Dynamics AX 1809:Windows SDK 1789:Small Basic 1656:Development 1312:26 December 1288:26 December 1236:26 December 1212:26 December 1164:26 December 1140:26 December 1089:26 December 1065:26 December 869:. Microsoft 620:2033-01-11 617:2028-01-11 614:2022-11-16 602:2030-01-08 599:2025-01-07 596:2019-11-04 335:SQLEXPR.EXE 245:SQL Server 236:is provided 2522:Categories 2415:Playwright 2272:SQL Server 2053:frameworks 2017:PowerShell 1992:IronPython 1980:TypeScript 1975:JavaScript 1896:Visual C++ 1750:QuickBASIC 1448:2017-04-08 1358:2017-04-07 1262:2017-10-16 1186:2019-04-03 1114:2017-04-07 1039:2022-04-17 987:2019-04-03 966:2007-01-15 941:2019-04-03 920:2019-04-03 899:2008-11-25 832:2010-06-22 778:2021-11-01 744:2021-11-01 739:Express DB 717:2019-04-03 696:2019-04-03 676:References 581:2027-10-12 578:2022-10-11 575:2017-09-29 564:2026-07-14 561:2021-07-13 558:2016-06-01 547:2024-07-09 544:2019-07-09 541:2014-04-01 529:2022-07-12 526:2017-07-11 523:2012-05-14 512:2019-07-09 509:2014-07-08 506:2010-04-16 495:2019-07-09 492:2014-07-08 489:2009-02-08 478:2016-04-12 475:2011-04-12 472:2005-11-07 402:April 2012 282:See also: 161:SQL Server 67:Written in 54:2019-11-04 2451:ClickOnce 2430:xUnit.net 2398:debugging 2321:Reporting 2181:CardSpace 2157:Web Forms 1938:Dexterity 1916:C++/WinRT 1849:Languages 1794:WebMatrix 1782:FrontPage 1505:Microsoft 1468:Microsoft 1282:Microsoft 1206:Microsoft 1134:Microsoft 1059:Microsoft 852:Microsoft 157:Microsoft 31:Microsoft 2509:Category 2439:Delivery 2405:CodeView 2316:Analysis 2264:Database 2051:APIs and 2012:Power Fx 1997:IronRuby 1884:VBScript 1730:MACRO-80 1725:GW-BASIC 1402:11 April 1378:11 April 873:28 March 799:July 11, 634:See also 452:Version 304:Variants 168:embedded 98:Platform 2410:OneFuzz 2285:Compact 2280:Express 2164:ADO.NET 2127:ASP.NET 2082:DirectX 1985:JScript 1906:C++/CLI 1834:XAMLPad 1829:WinDiff 1740:MSBuild 1679:Express 1423:30 June 392:updated 278:LocalDB 141:Website 130:License 52: ( 2425:WinDbg 2060:Native 1901:C++/CX 1891:Bosque 1874:VB.NET 1869:legacy 1772:Roslyn 1762:QuickC 1755:QBasic 1745:Pascal 1703:Others 1333:6 June 650:SQLite 2466:vcpkg 2461:NuGet 2340:Other 2152:Razor 2109:WinUI 1933:Dafny 1861:BASIC 1819:ILAsm 1720:FxCop 1710:Blend 91:Linux 2300:MSDE 2239:UMDF 2234:KMDF 2196:LINQ 2176:MAUI 2137:AJAX 2132:Core 2119:.NET 2042:XAML 2002:Lean 1958:Java 1928:C/AL 1674:Code 1425:2017 1404:2014 1380:2014 1335:2017 1314:2012 1290:2012 1238:2012 1214:2012 1166:2012 1142:2012 1091:2012 1067:2012 960:MSDN 893:MSDN 875:2012 801:2023 645:MSDE 254:MSDE 220:MSDE 197:MSDE 118:Type 2481:WiX 2456:npm 2251:WDM 2229:WDF 2224:WDK 2147:MVC 2094:UWP 2077:XNA 2037:VPL 1963:J++ 1879:VBA 362:and 352:and 159:'s 75:C++ 2524:: 2027:Q# 1968:J# 1948:F* 1943:F# 1923:C# 1562:^ 1545:^ 1514:^ 1502:. 1477:^ 1465:. 1441:. 1388:^ 1351:. 1298:^ 1279:. 1254:. 1222:^ 1203:. 1150:^ 1131:. 1107:. 1075:^ 1056:. 1031:. 1014:^ 958:. 891:. 849:. 770:. 753:^ 737:. 726:^ 318:A 89:, 73:, 2007:P 1643:e 1636:t 1629:v 1575:. 1556:. 1539:. 1525:. 1508:. 1488:. 1471:. 1451:. 1427:. 1406:. 1382:. 1361:. 1337:. 1316:. 1292:. 1265:. 1240:. 1216:. 1189:. 1168:. 1144:. 1117:. 1093:. 1069:. 1042:. 990:. 969:. 944:. 923:. 902:. 877:. 855:. 835:. 816:. 803:. 781:. 747:. 720:. 699:. 404:) 400:( 394:. 71:C 56:)

Index

Developer(s)
Microsoft
Stable release
C
C++
Operating system
Microsoft Windows
Linux
Platform
.NET Framework 4.0
Type
Relational database management system
License
Proprietary software
www.microsoft.com
Microsoft
SQL Server
relational database management system
embedded
Microsoft Database Engine (MSDE)
MSDE
MSDE
SQL Server Management Studio
Business Intelligence Development Studio
MSDE
Analysis Services
Integration Services
SQL Server Compact
SQL Server Reporting Services
SQL Server Compact

Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.

↑