SQL version details let you know the difference with sql2000

SQL2005 Express has no "Enterprise Manager" or "query analyzer 」

SQL2005 is divided into five versions, as listed below:
1. Enterprise (Enterprise Edition)
2. Development (Development Edition)
3. Workgroup, (Work Group version)
4. Standard, (Standard Edition)
5. Express. (well, just call it a simple version)

Which of the following versions should we use? This is the most frequently asked question for many beginners of SQL2005.

In simple comparison, Enterprise, Development, Express, and other three versions: in terms of functionality, Enterprise and Development have the same functions. The differences between the two are:

Enterprise Edition database reference libraries can only be installed on Win2003Server (or other servers ).

If you want to install Windows XP Pro, you should install SQL2005 Development (Development edition ).

Note: Someone asked what is "Database Engine 」. Well, the database engine is the core of SQL2005 and the main functional module of database management. Without it, it is not a database management system.

Many people download SQL2005 Express because it is free and can be downloaded directly from the Microsoft website. However, apart from supporting a relatively small amount of memory, the most important thing is that it lacks the equivalent of "Enterprise Manager" and "query analyzer" in SQL2000 」.

Note: "Enterprise Manager" and "query analyzer" under SQL2000 have been combined into one in SQL2005 and are called Management Studio.

Therefore, if you are a beginner and want to learn at home, if your environment is Windows XP Pro, you should choose SQL2005 Development (Development edition ), instead of SQL2005 Enterprise Edition or SQL2005 Express (simple edition ).