Σε σχέση με το προηγούμενο post :
MSDE 2000
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, redistributable version of SQL Server that’s ideal for client applications that require an embedded database, new developers learning how to build data-driven applications, and Web sites serving up to 25 concurrent users.
1.Q. Η MSDE διανέμεται δωρεάν και έχει κανείς διακαιώματα redistribution εφόσον αποκτήσει passport από τη Microsoft,
ανεξάρτητα από το εάν χρησιμοποιεί ή όχι εργαλεία ανάπτυξης της Microsoft ή όχι;
A. Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a free, redistributable version of SQL Server 2000 that can now be downloaded from the SQL
Server website. The MSDE 2000 download provides users with the right to install and use MSDE with your applications or development projects. You must
register for the right to redistribute MSDE with your applications (URL for Registering: http://www.microsoft.com/sql/msde/howtobuy/redistregister.mspx).
Also, if you obtained MSDE by licensing one of the following products or services, you are licensed to redistribute MSDE as part of your applications (when
you develop applications):
|
• |
ASP.NET Web Matrix (When obtained by downloading ASP.NET Web Matrix, MSDE is provided only for use in conjunction with an application developed by using ASP.NET Web Matrix). |
|
• |
MSDN® Universal, Enterprise, and Professional subscriptions |
|
• |
Microsoft Office XP Developer Edition |
|
• |
SQL Server 2000 Developer, Standard, and Enterprise Editions |
|
• |
Microsoft Visual Studio® .NET Architect, Developer, and Professional Editions2 |
|
• |
Microsoft Visual FoxPro® 7.0 or 8.0 |
Note: a. Multiple vendors cannot share a copy of MSDE; however, a single vendor can utilize a single copy of MSDE for multiple applications, provided the vendor has appropriate MSDE redistribution rights for each application.
Yes, you can redistribute MDSE with applications built using any application development platform not just Microsoft platform.
URL that can find further info: http://www.microsoft.com/sql/msde/howtobuy/default.mspx. and http://www.microsoft.com/sql/msde/howtobuy/msdeuse.mspx
2.Q Πόσα instances μπορώ να χρησιμοποιήσω ανά εγκατάσταση;
A. Multi-Instance Support
MSDE 2000 supports up to 16 database server instances on a single computer. More info on product features you can find at:
http://www.microsoft.com/sql/msde/productinfo/features.mspx
3.Q Πόσες βάσεις μπορώ να χρησιμοποιήσω ανά instance;
A. Each instance can have up to 32,767 databases. This peace of info you can find it at URL: http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true , where you can find in detail how the governor service operates.
4.Q Ποιό είναι το maximum μέγεθος που μπορεί να έχει η κάθε βάση;
A. Maximum Database Size
MSDE 2000 supports up to 2 gigabytes (GB) per database. This limitation is per database, not per server. A single computer can support multiple MSDE 2000
instances, each with databases of up to 2 GB in capacity. (http://www.microsoft.com/sql/msde/productinfo/features.mspx)
5.Q Μπορώ να χρησιμοποιήσω τα Client Tools (Query Analyzer, Enterprize Manager) με την MSDE;
A. Administering SQL Server 2000 Desktop Engine (MSDE 2000)
Topic last updated -- January 2004
The database engine, replication, and Data Transformation Services (DTS) components in SQL Server 2000 Desktop Engine (MSDE 2000) are administered in the same manner as in any other version of SQL Server 2000. The primary difference is that MSDE 2000 does not include the graphical management tools or wizards, so the following mechanisms are typically used to administer instances of MSDE 2000:
- Applications can be coded to fully administer an instance of the Desktop Engine by either:
- Using the SQL Server administration APIs, such as SQL-DMO, and the DTS and replication programming objects.
- Running Transact-SQL statements using the general database APIs (such as ADO.NET, ADO, OLE DB, and ODBC).
- The following command prompt utilities are installed by the MSDE 2000 setup application and are provided without restrictions for use with the copy of MSDE 2000 that is installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The dtsrun.exe utility is also provided, but may not be used during development.
- If you installed MSDE 2000 with another edition of SQL Server, you can administer instances of MSDE 2000 using the SQL Server 2000 graphical tools.
The SQL Server Books Online section called "Administering SQL Server" contains the topics that document the potential administration actions for the databases and instances of any version of SQL Server 2000. Topics in these sections contain procedures that indicate the steps required to perform that administration task. For example, there are procedures detailing how to perform the task using Enterprise Manager or Query Analyzer, how to perform it using SQL-DMO, and how to perform it by running Transact-SQL statements. Note that:
- The procedures documenting using a graphical tool such as Enterprise Manager or Query Analyzer typically do not apply in MSDE 2000 environments.
- Programmers coding applications to administer instances of MSDE 2000 typically use either the items documenting using SQL-DMO or using Transact-SQL as a guide to coding their applications.
- End users who must administer an instance of MSDE typically use the osql utility to run the Transact-SQL statement or statements mentioned in the Transact-SQL item.
6.Q Πόσα concurrent operations μπορούν να «τρέχουν» πριν αναλάβει το governor service να τα κάνει slow down
A. When there are more than eight active operations at the same time in the same instance of the database engine, the governor implements a slight wait before each logical read or write to a data file. For the amount of work typical in databases used by single users or small workgroups, the cumulative effect of the waits is not noticeable. In systems that are reading and writing large amounts of data, the cumulative affect of all the waits slows the performance of the database engine.
Στο URL: http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true you will find further info.
Επίσης βρήκα ένα ενδιαφέρον άρθρο :
http://www.codeproject.com/database/ConfigureMSDE.asp
Πάνος Αβραμίδης