December 12, 2010 at 11:26 pm
Guys,
I have Windows 7 64 bit. Now I would like to purchase MS SQL Server 2005 developer edition. Can you guys tell me is there any difference in the "MS SQL Server 2005 developer edition" for 32 bit and 64 bit OS Or "MS SQL Server 2005 developer edition" is comman for both type of system?
December 13, 2010 at 10:19 am
The main difference between 32-bit and 64-bit for Developer edition is the memory allocation or AWE switch is already enabled and you don't have the limitation like you do with 32-bit
http://www.microsoft.com/sqlserver/2005/en/us/system-requirements.aspx
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
December 14, 2010 at 8:40 am
So, You mean there is only one developer version that can be installed irrespective of 34 or 64 bit system.
December 14, 2010 at 8:48 am
No, there are three different versions of Developer edition. x86, 64-bit and 64-bitIA
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
December 14, 2010 at 10:53 am
Thank you, By the way can you tell me which edition (x86, 64-bit and 64-bitIA ) I should buy ?
my system configuration is
x64 Based PC
Intel Core i5 CPU M 460
4 GB RAM
December 14, 2010 at 10:31 pm
you can run the 32bit on the 64bit machine, you only have 4 gig so it doesn't matter.
December 15, 2010 at 5:54 am
In point of fact you can use either the 32-bit or 64-bit version when you buy a SQL server license (so long as you don't use both at the same time, of course). With only 4Gb of RAM I would agree that there's little point using the 64-bit version, but if you might upgrade the RAM at some future date you might as well install the 64-bit one now rather than have to do an upgrade installation later. (You would need the x64 edition, by the way--IA64 is for Itanium CPUs).
July 19, 2012 at 10:05 am
I am curious to find out if you ever run SSIS package on this machine.
My office work environment uses a Standard edition sql 2005 on Windows 7 professional. The control flow script task can not be open. When I drop a Script Task into a package, navigate to "Design Script" button and click. The dialog dissapears, no editor ever appears - no error message.
Framework 4.0 is installed. I also downloaded Framework 2.0 sdk. SQL 2008 R2 was installed and uninstalled to narrow down the possible conflicts.
October 10, 2012 at 2:24 pm
Mystery solved. Reinstall SQL 2005, apply sql server sp4. Most important - turn on 32 bit asp.net on 64 bit IIS.
My design script window opens and works fine.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply