What are the product technical differences between SQL 2K and SQL 2005 ? For example, I have recently learned that the product version of the SQL Instance I'm running is MSDE 8.0.760 SP3. I've been told on this forum that this refers to SQL 2000 engine. HOWEVER, I have the following properties existing on my system:
On the physical server, under Add/Remove Programs, there is a program "Microsoft SQL 2005". Then under it, a hyperlink which says "Click here for more information", which when clicked, brings me to a general SQL 2005 information web site: http://support.microsoft.com/ph/2855.
When I open up the SQL 2005 program icon (Either SQL , it identifies it as such (Not as SQL 2000).
When I goto Start | All Programs, there is the expected SQL 2005 Programs icon Folder.
How can ensure I have that I DO NOT HAVE sql 2005 engine? For example, what is the product version for sql 2005 and where can I find this in the application? Also, if I do not have the SQL 2005 engine, then what exactly is the definition of SQL 2005 which is using a SQL 2000 Database engine? In other words, then what is SQL 2005 application I'm using? If its not the engine, then what is the core component of this SQL 2005 app?
This goes back to a post at : http://www.sqlservercentral.com/Forums/Topic490333-131-2.aspx
Where I was under the impression I was using SQL 2005. The responder was most helpful, but I need find "proof" that I have the SQL 2000 engine, and "proof" or some exact description / relationship between the SQL 2005 and the MSDE engine, or some cogent description of their relationship as "engine" and "application" (For example, is there a document which describes how a SQL 2005 application uses a MSDE engine?)
once again, thanks,