sql server msde: Hi

A Client has an MSDE install - checked by running @@version (clearly
says developer edition in the result text).

However the size of the data file is over 3GB, even allowing for empty
spaces the amount of data far exceeds 2GB. Pls explain?

The database was filled by regular insert statements.

Helmut

Mine says "Developer Edition on Windows NT 5.1"

I THOUGHT thats what MSDE stood for? I'm confused now..

Here is @@VERSION from one of my many MSDE2000 instances in he office:

"Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT
5.1 (Build 2600: Service Pack 2)"

Clearly, it says "... Desktop Engine...". Never heard MSDE has "Developer
Edition", while SQL Server has Developer Edition, which does not have 2GB
size limit.


[quoted text, click to view]

Am 31 Oct 2005 04:14:49 -0800 schrieb yitzak:

[quoted text, click to view]

MSDE always shows "Desktop Engine" and not "Developer Edition"!

bye,

Developer Edition is a different version of SQL Server 2000 than MSDE. The
"full" name of MSDE 2000 is Microsoft SQL Server 2000 Desktop Engine (MSDE
2000), and you would have seen "Desktop Engine on Windows NT 5.1" in
@@VERSION.

--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team

SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/

This posting is provided "AS IS" with no warranties, and confers no rights.