Different SQL server 2005 Editions from the same Installation CD?!

Hi

I have the SQL Server 2005 Enterprise Edition CD and have succesfully installed this on my desktop.

When I install this on my Laptop the version is 2000(print @.@.version) is only Desktop version (2gb db limit!)....

Any ideas on why the full enterprise edition is not installing on the laptop?!!

Version on my Desktop:
MICROSOFT SQL SERVER 2005-9.00.1399.06 (INTEL X86)
OCT 14 2005 00.33.37
1988-2005 microsoft corp
enterprise edition on windows NT 5.2 (build 3790-service pack)

Version on my laptop:
MICROSOFT SQL SERVER 2000-8.00.2039(INTEL X86)
May 14 2005 23:18:38
Copyright (c) 1988-2005 Microsoft Corporation
desktop engine on windows NT 5.1 (build 2600: service pack 2)

The Laptop spec is:
Intel 1.66Ghz, 1 Gb Ram, 50 Gb HDD, Windows XP SP2

The Desktop spec is:
Intel 2.8 Ghz Dual Core, 2 Gb Ram, 320 Gb HDD, Windows XP SP2

Both SQL Server 2005 versions are installed from the same CD so why would there be a difference?

I understand that you cannot have Enterprise edition on XP but it has installed on the desktop, not the laptop?

Thanks in advance!

EE does not support Windows XP as a OS. Could it be that you have developer edition installed ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||When I use the command print @.@.version on my desktop, it states that it is Enterprise Edition.....|||

Based on the information you provided, your laptop has Windows XP SP2. SQL Server enterprise edition requires a server OS and will not install on Windows XP, which is a client OS. Thus, you can not install it on your laptop.

Look closely at your @.@.version information from your desktop. It indicates that your desktop computer has Windows 5.2, which is Windows 2003 Server, NOT Windows XP. Windows 2003 Server will support an installation of SQL Server 2005 enterprise edition. Thus, I would expect you to be able to install SQL Server 2005 enterprise edition on your desktop, but not on your laptop.

I do not understand the statement... "Both SQL Server 2005 versions are installed from the same CD so why would there be a difference?"

Looking at the @.@.version information on your desktop and laptop indicate that SQL 2005 is install on your desktop, but SQL 2000 is install on your laptop. I do not see any indication that SQL 2005 is install on the laptop.

Tom

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

Different results same query between original and copied db

Hi all,

I restored a backup of a database running SQL Server in W2K to my own laptop (Windows XP) for report testing pourposes. The restore worked perfectly, but when I ran the store procedure that returns my "report" set I noticed that several of the fields within the result set are different, the number of rows and customers are a perfect match to the production report. The fields that are different are calculated fields that invoque a user defined function, which again are exactly the same on both databases. I tried dropping the stored procedure and the 4 functions and recreating them again but I get the same results, the number of rows, the customers and all "non" function calculated fields are perfect, only the fields calculated with the functions are wrong.

Has anybody seen this behavior?

Thanks for your help

Luis Torresdo u have Nondeterministic Functions like rand() ..??|||nope, but I solved the problem, I didnt have the service pack 3 installed on my laptop and after installing it everything worked perfect.

Thanks for your help :)

Luis Torres|||would like to know wat SP3 did !!!|||Yeah, I would love to, I like the solution better when I understand the problem