Knowledge

MSDE

Source đź“ť

1493: 33: 193:
application instead of requiring direct access to the file system which the Jet database resided on. Microsoft Access, the company's most popular database tool at the time, was expanded for its Office 2000 release to incorporate using Microsoft Desktop Engine as its back-end data store. This design
375: 194:
was promoted by Microsoft as a solution for small workgroups that may eventually grow to require the full SQL Server product. This initial release of MSDE also included the Data Transformation Services Wizard, which provided the ability to use
177:
MSDE was initially designed by (then) Microsoft Program Manager Jeff Alger and later implemented by Peter Byrne (core), Ronald Martinsen (core/setup), and Mike Maringas (setup). Alger and Martinsen are the co-inventors who hold the patent.
247:
MSDE could be distributed with commercial products by registering with Microsoft — in most cases this distribution is also free of charge. SQL Server's server licence includes right to distribute MSDE.
156:
7.0 or 2000 which is free for non-commercial use as well as certain limited commercial use. It was introduced at Microsoft TechEd in May 1999, and was included as part of
518: 629: 496: 576: 279: 181:
The initial release of MSDE is called the "Microsoft Desktop Engine", which is based on SQL Server 7.0 and was positioned as an alternative to using the
597: 507: 319: 1515: 541: 530: 485: 622: 1525: 1282: 254:
MSDE 2000 is also found in various products, such as Microsoft Office XP (Professional, Developer), Visual Studio .NET 2002-2003.
1029: 202:
data sources to transfer data between SQL Server 7.0 and MSDE. Supported operating systems at the time of its release included
21: 463: 1024: 145: 1520: 1496: 676: 615: 754: 270:
workloads are running. Microsoft has also stated that MSDE is not supported in Windows NT 6.0 operating systems such as
116: 1318: 1173: 925: 97: 1313: 1188: 666: 580: 69: 930: 910: 681: 54: 1308: 878: 866: 764: 262:
Compared with the full server editions of SQL Server 7.0 and 2000, MSDE has some restrictions: a limit of 2
76: 1277: 1221: 898: 283: 251:
MSDE 2000 includes following resource kits: MSDE 2000 Deployment Resource Kit, MSDE 2000 Web Resource Kit.
1369: 1303: 1193: 1178: 945: 1226: 1081: 370: 83: 1407: 1349: 1216: 1183: 935: 722: 1233: 994: 702: 414: 275: 1475: 653: 552: 65: 43: 1458: 1344: 989: 883: 856: 811: 300: 1374: 1402: 1059: 1019: 843: 796: 776: 602: 519:
END-USER LICENSE AGREEMENT SERVER LICENSE FOR MICROSOFT SQL SERVER PRODUCTS (SQL Server 2000)
474: 357: 50: 373:, Ronald R. Martinsen, Jeffrey Alger, "Dynamic SKU management", issued 2002-8-27 1259: 1238: 1129: 1086: 267: 153: 225:
Microsoft Data Engine can be found in Microsoft Access 2000 and other Microsoft products.
8: 781: 769: 182: 563: 389: 1272: 1267: 1211: 999: 791: 717: 661: 344: 295: 161: 440:"PRB: MSDE unattended installation needs full path name of the .iss file (MSKB238232)" 1463: 1168: 1144: 1091: 861: 759: 190: 1339: 1156: 732: 186: 157: 266:
databases, and has a workload governor which reduces its speed when eight or more
90: 1480: 1074: 848: 786: 697: 1443: 1009: 955: 211: 607: 244:
It is based on SQL Server 2000. System requirement was changed to Windows 98.
164:
was released in November 2005. Vendor support of MSDE ended on April 8, 2008.
1509: 1334: 1203: 1139: 1064: 940: 671: 320:"Microsoft Announces Availability of MSDE For Developers Using Visual Studio" 271: 1433: 1124: 1119: 950: 801: 439: 1134: 1054: 903: 228:
MSDE toolkit for Visual Studio 6.0 can be found in October 2000 MSDN DVD
1004: 979: 967: 962: 737: 207: 203: 1438: 1417: 1163: 893: 236:(English Pack, European Pack I, Japanese Pack, Latin American pack). 219: 149: 32: 1392: 984: 888: 871: 712: 263: 17: 464:
Product Information -> Pricing & Licensing (SQL Server 7.0)
1397: 1151: 1114: 1069: 1014: 972: 821: 816: 727: 1412: 749: 742: 278:
management tools were released for MSDE, but SQL Server 2000's
195: 1453: 1448: 1096: 920: 806: 707: 1106: 915: 199: 1468: 215: 230:
Office Test Platform and Development Tools, English Pack
232:
as MSDE for Visual Studio., or in October 2000 MSDN CD
508:
Microsoft SQL Server 2000 Enterprise Edition datasheet
419:
Microsoft Office 2000/Visual Basic Programmer's Guide
394:
Microsoft Office 2000/Visual Basic Programmer's Guide
239: 57:. Unsourced material may be challenged and removed. 1507: 475:Table of Contents for October 2000 Monthly (DVD) 637: 486:Table of Contents for August 2000 Monthly (CD) 623: 189:with a focus on its ability to operate as a 214:Service Pack 4, and was available for both 172: 630: 616: 234:Office Test Platform and Development Tools 542:Microsoft Products that include MSDE 2000 117:Learn how and when to remove this message 1283:Business Intelligence Development Studio 1516:Proprietary database management systems 160:2000 Developer Edition. Its successor, 1508: 351: 22:Maryland State Department of Education 20:'s state department of education, see 611: 557: 553:The SQL Server 2000 Workload Governor 146:relational database management system 55:adding citations to reliable sources 26: 497:SQL Server 2000 System Requirements 282:(as well as later versions such as 13: 14: 1537: 590: 521:1.c. Use of Redistributable Code. 301:SQL Server Express § LocalDB 152:. It is a scaled-down version of 1492: 1491: 286:) can be used to connect to it. 240:Microsoft SQL Server Data Engine 130:Microsoft SQL Server Data Engine 31: 1526:Discontinued Microsoft software 1375:Team Foundation Version Control 569: 546: 535: 524: 512: 501: 490: 479: 42:needs additional citations for 468: 457: 432: 407: 382: 363: 337: 312: 1: 390:"Using Microsoft Data Engine" 345:"MS SQL Server 2005 Released" 306: 284:SQL Server Management Studio 7: 1521:Microsoft server technology 638:Microsoft development tools 531:Resource Kits for MSDE 2000 289: 257: 167: 10: 1542: 603:SQL Server Express Edition 15: 1489: 1426: 1383: 1362: 1350:Extensible Storage Engine 1327: 1296: 1258: 1251: 1202: 1105: 1047: 1038: 836: 755:Robotics Developer Studio 690: 652: 643: 369: 1174:Communication Foundation 276:graphical user interface 173:Microsoft Desktop Engine 142:Microsoft Desktop Engine 1476:Windows Package Manager 1189:Presentation Foundation 577:"SQL Server & MSDE" 1459:Web Platform Installer 1345:Access Database Engine 812:Native Image Generator 677:Tools for Applications 564:MS SQL Server on Vista 371:US patent 6442559 138:Microsoft Data Engine 1087:Xbox Development Kit 672:Team System Profiler 154:Microsoft SQL Server 51:improve this article 1194:Workflow Foundation 1179:Identity Foundation 765:SharePoint Designer 183:Jet Database Engine 792:Windows App Studio 415:"When to Use MSDE" 347:. databasedir.com. 324:news.microsoft.com 296:SQL Server Compact 280:Enterprise Manager 162:SQL Server Express 1503: 1502: 1464:Windows Installer 1370:Visual SourceSafe 1358: 1357: 1278:Management Studio 1247: 1246: 1092:Windows Installer 832: 831: 127: 126: 119: 101: 1533: 1495: 1494: 1340:Microsoft Access 1256: 1255: 1157:Entity Framework 1045: 1044: 682:Tools for Office 650: 649: 632: 625: 618: 609: 608: 596:Microsoft page: 585: 584: 579:. Archived from 573: 567: 561: 555: 550: 544: 539: 533: 528: 522: 516: 510: 505: 499: 494: 488: 483: 477: 472: 466: 461: 455: 454: 452: 451: 436: 430: 429: 427: 426: 411: 405: 404: 402: 401: 386: 380: 379: 378: 374: 367: 361: 355: 349: 348: 341: 335: 334: 332: 331: 316: 187:Microsoft Access 158:Microsoft Office 122: 115: 111: 108: 102: 100: 59: 35: 27: 1541: 1540: 1536: 1535: 1534: 1532: 1531: 1530: 1506: 1505: 1504: 1499: 1485: 1481:Microsoft Store 1422: 1408:Script Debugger 1385: 1379: 1354: 1323: 1292: 1243: 1198: 1101: 1075:Managed DirectX 1040: 1034: 828: 787:Windows App SDK 723:Macro Assembler 686: 645: 639: 636: 593: 588: 575: 574: 570: 562: 558: 551: 547: 540: 536: 529: 525: 517: 513: 506: 502: 495: 491: 484: 480: 473: 469: 462: 458: 449: 447: 438: 437: 433: 424: 422: 413: 412: 408: 399: 397: 388: 387: 383: 376: 368: 364: 356: 352: 343: 342: 338: 329: 327: 318: 317: 313: 309: 292: 260: 242: 222:architectures. 175: 170: 123: 112: 106: 103: 60: 58: 48: 36: 25: 12: 11: 5: 1539: 1529: 1528: 1523: 1518: 1501: 1500: 1490: 1487: 1486: 1484: 1483: 1478: 1473: 1472: 1471: 1461: 1456: 1451: 1446: 1441: 1436: 1430: 1428: 1424: 1423: 1421: 1420: 1415: 1410: 1405: 1400: 1395: 1389: 1387: 1381: 1380: 1378: 1377: 1372: 1366: 1364: 1363:Source control 1360: 1359: 1356: 1355: 1353: 1352: 1347: 1342: 1337: 1331: 1329: 1325: 1324: 1322: 1321: 1316: 1311: 1306: 1300: 1298: 1294: 1293: 1291: 1290: 1285: 1280: 1275: 1270: 1264: 1262: 1253: 1249: 1248: 1245: 1244: 1242: 1241: 1236: 1231: 1230: 1229: 1224: 1214: 1208: 1206: 1204:Device drivers 1200: 1199: 1197: 1196: 1191: 1186: 1181: 1176: 1171: 1166: 1161: 1160: 1159: 1149: 1148: 1147: 1142: 1137: 1132: 1127: 1122: 1111: 1109: 1103: 1102: 1100: 1099: 1094: 1089: 1084: 1079: 1078: 1077: 1067: 1062: 1057: 1051: 1049: 1042: 1036: 1035: 1033: 1032: 1027: 1022: 1017: 1012: 1010:Project Verona 1007: 1002: 997: 992: 987: 982: 977: 976: 975: 970: 960: 959: 958: 953: 943: 938: 933: 928: 923: 918: 913: 908: 907: 906: 901: 896: 891: 881: 876: 875: 874: 869: 864: 859: 851: 846: 840: 838: 834: 833: 830: 829: 827: 826: 825: 824: 819: 814: 809: 804: 794: 789: 784: 779: 774: 773: 772: 762: 757: 752: 747: 746: 745: 735: 730: 725: 720: 715: 710: 705: 703:Expression Web 700: 694: 692: 688: 687: 685: 684: 679: 674: 669: 664: 658: 656: 647: 641: 640: 635: 634: 627: 620: 612: 606: 605: 600: 592: 591:External links 589: 587: 586: 583:on 2010-07-24. 568: 556: 545: 534: 523: 511: 500: 489: 478: 467: 456: 444:Knowledge Base 431: 406: 381: 362: 350: 336: 310: 308: 305: 304: 303: 298: 291: 288: 259: 256: 241: 238: 212:Windows NT 4.0 174: 171: 169: 166: 125: 124: 39: 37: 30: 9: 6: 4: 3: 2: 1538: 1527: 1524: 1522: 1519: 1517: 1514: 1513: 1511: 1498: 1488: 1482: 1479: 1477: 1474: 1470: 1467: 1466: 1465: 1462: 1460: 1457: 1455: 1452: 1450: 1447: 1445: 1442: 1440: 1437: 1435: 1432: 1431: 1429: 1425: 1419: 1416: 1414: 1411: 1409: 1406: 1404: 1401: 1399: 1396: 1394: 1391: 1390: 1388: 1382: 1376: 1373: 1371: 1368: 1367: 1365: 1361: 1351: 1348: 1346: 1343: 1341: 1338: 1336: 1335:Visual FoxPro 1333: 1332: 1330: 1326: 1320: 1317: 1315: 1312: 1310: 1307: 1305: 1302: 1301: 1299: 1295: 1289: 1286: 1284: 1281: 1279: 1276: 1274: 1271: 1269: 1266: 1265: 1263: 1261: 1257: 1254: 1250: 1240: 1237: 1235: 1232: 1228: 1225: 1223: 1220: 1219: 1218: 1215: 1213: 1210: 1209: 1207: 1205: 1201: 1195: 1192: 1190: 1187: 1185: 1182: 1180: 1177: 1175: 1172: 1170: 1167: 1165: 1162: 1158: 1155: 1154: 1153: 1150: 1146: 1143: 1141: 1138: 1136: 1133: 1131: 1128: 1126: 1123: 1121: 1118: 1117: 1116: 1113: 1112: 1110: 1108: 1104: 1098: 1095: 1093: 1090: 1088: 1085: 1083: 1080: 1076: 1073: 1072: 1071: 1068: 1066: 1063: 1061: 1058: 1056: 1053: 1052: 1050: 1046: 1043: 1037: 1031: 1028: 1026: 1023: 1021: 1018: 1016: 1013: 1011: 1008: 1006: 1003: 1001: 998: 996: 993: 991: 988: 986: 983: 981: 978: 974: 971: 969: 966: 965: 964: 961: 957: 954: 952: 949: 948: 947: 944: 942: 941:Visual FoxPro 939: 937: 934: 932: 929: 927: 924: 922: 919: 917: 914: 912: 909: 905: 902: 900: 897: 895: 892: 890: 887: 886: 885: 882: 880: 877: 873: 870: 868: 865: 863: 860: 858: 855: 854: 853:Visual Basic 852: 850: 847: 845: 842: 841: 839: 835: 823: 820: 818: 815: 813: 810: 808: 805: 803: 800: 799: 798: 795: 793: 790: 788: 785: 783: 780: 778: 775: 771: 768: 767: 766: 763: 761: 758: 756: 753: 751: 748: 744: 741: 740: 739: 736: 734: 731: 729: 726: 724: 721: 719: 716: 714: 711: 709: 706: 704: 701: 699: 696: 695: 693: 689: 683: 680: 678: 675: 673: 670: 668: 665: 663: 660: 659: 657: 655: 654:Visual Studio 651: 648: 642: 633: 628: 626: 621: 619: 614: 613: 610: 604: 601: 599: 595: 594: 582: 578: 572: 565: 560: 554: 549: 543: 538: 532: 527: 520: 515: 509: 504: 498: 493: 487: 482: 476: 471: 465: 460: 445: 441: 435: 420: 416: 410: 395: 391: 385: 372: 366: 359: 354: 346: 340: 326:. 24 May 1999 325: 321: 315: 311: 302: 299: 297: 294: 293: 287: 285: 281: 277: 273: 272:Windows Vista 269: 265: 255: 252: 249: 245: 237: 235: 231: 226: 223: 221: 217: 213: 209: 205: 201: 197: 192: 191:client–server 188: 184: 179: 165: 163: 159: 155: 151: 148:developed by 147: 143: 139: 135: 131: 121: 118: 110: 99: 96: 92: 89: 85: 82: 78: 75: 71: 68: â€“  67: 63: 62:Find sources: 56: 52: 46: 45: 40:This article 38: 34: 29: 28: 23: 19: 1434:Active Setup 1319:Notification 1297:SQL services 1287: 1130:Dynamic Data 802:CLR Profiler 646:environments 581:the original 571: 559: 548: 537: 526: 514: 503: 492: 481: 470: 459: 448:. Retrieved 443: 434: 423:. Retrieved 418: 409: 398:. Retrieved 393: 384: 365: 358:MSDE Upgrade 353: 339: 328:. Retrieved 323: 314: 261: 253: 250: 246: 243: 233: 229: 227: 224: 180: 176: 141: 137: 133: 129: 128: 113: 104: 94: 87: 80: 73: 61: 49:Please help 44:verification 41: 1384:Testing and 1314:Integration 1234:Windows HLK 1060:Silverlight 1055:Windows API 1020:Small Basic 899:Managed C++ 844:Dynamics AX 797:Windows SDK 777:Small Basic 644:Development 446:. Microsoft 421:. Microsoft 396:. Microsoft 1510:Categories 1403:Playwright 1260:SQL Server 1041:frameworks 1005:PowerShell 980:IronPython 968:TypeScript 963:JavaScript 884:Visual C++ 738:QuickBASIC 450:2008-11-19 425:2008-11-29 400:2008-11-29 330:2022-04-16 307:References 268:concurrent 208:Windows 98 204:Windows 95 107:March 2009 77:newspapers 1439:ClickOnce 1418:xUnit.net 1386:debugging 1309:Reporting 1169:CardSpace 1145:Web Forms 926:Dexterity 904:C++/WinRT 837:Languages 782:WebMatrix 770:FrontPage 598:MSDE 2000 150:Microsoft 1497:Category 1427:Delivery 1393:CodeView 1304:Analysis 1252:Database 1039:APIs and 1000:Power Fx 985:IronRuby 872:VBScript 718:MACRO-80 713:GW-BASIC 290:See also 258:Features 185:used by 168:Overview 18:Maryland 1398:OneFuzz 1273:Compact 1268:Express 1152:ADO.NET 1115:ASP.NET 1070:DirectX 973:JScript 894:C++/CLI 822:XAMLPad 817:WinDiff 728:MSBuild 667:Express 144:) is a 136:, also 91:scholar 1413:WinDbg 1048:Native 889:C++/CX 879:Bosque 862:VB.NET 857:legacy 760:Roslyn 750:QuickC 743:QBasic 733:Pascal 691:Others 377:  210:, and 196:OLE DB 93:  86:  79:  72:  66:"MSDE" 64:  1454:vcpkg 1449:NuGet 1328:Other 1140:Razor 1097:WinUI 921:Dafny 849:BASIC 807:ILAsm 708:FxCop 698:Blend 274:. No 220:Alpha 98:JSTOR 84:books 1288:MSDE 1227:UMDF 1222:KMDF 1184:LINQ 1164:MAUI 1125:AJAX 1120:Core 1107:.NET 1030:XAML 990:Lean 946:Java 916:C/AL 662:Code 218:and 200:ODBC 198:and 134:MSDE 70:news 16:For 1469:WiX 1444:npm 1239:WDM 1217:WDF 1212:WDK 1135:MVC 1082:UWP 1065:XNA 1025:VPL 951:J++ 867:VBA 216:x86 140:or 53:by 1512:: 1015:Q# 956:J# 936:F* 931:F# 911:C# 442:. 417:. 392:. 322:. 264:GB 206:, 995:P 631:e 624:t 617:v 566:. 453:. 428:. 403:. 360:. 333:. 132:( 120:) 114:( 109:) 105:( 95:· 88:· 81:· 74:· 47:. 24:.

Index

Maryland
Maryland State Department of Education

verification
improve this article
adding citations to reliable sources
"MSDE"
news
newspapers
books
scholar
JSTOR
Learn how and when to remove this message
relational database management system
Microsoft
Microsoft SQL Server
Microsoft Office
SQL Server Express
Jet Database Engine
Microsoft Access
client–server
OLE DB
ODBC
Windows 95
Windows 98
Windows NT 4.0
x86
Alpha
GB
concurrent

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

↑