Do you find that there is a big difference between the different versions of SQL server (6.5, 7, 2000, 2005) as is between Microsoft programming languages (VB.4, VB5, VB6, .Net and now .Net 2)
Or is the difference in SQL server minimal and very small compared to the programming languages I mentioned.
Thanks a lotThe change from SQL 6.5 to 7 is pretty big and the change from 7/2000 to 2005 is pretty big. However it all depends what you want to do. Think about how hard it was to write web apps in VB5/6 and compare that with VS 2005, thats pretty big but if all you wanted to do was to write hello world that has not changed much.|||thanks
Showing posts with label versions. Show all posts
Showing posts with label versions. Show all posts
Thursday, March 29, 2012
Difference between SQL2k Enterprise & Developer editions?
What are the Differences between those two SQL versions
i mean except that with in the developer edition only 1 user can login
on what version is it better to develop ?
does the developer ver. include something that the entprise does not ? (or vice versa)
(say in theory i can choose on which version to work ;-))
thanx, max.Directly from Microsoft's site:
Developer edition is designed to allow developers to build any type of application on top of SQL Server. It includes all the functionality of Enterprise Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment. It is the ideal choice for Independent Software Vendors (ISVs), consultants, system integrators, solution providers, and corporate developers developing and testing applications because it is cost effective, runs on a variety of platforms, and can be upgraded for production use to SQL Server 2000 Enterprise Edition.
It is the only edition of SQL Server 2000 that gives the licensee the right to download and install SQL Server 2000 Windows CE Edition (SQL Server CE). The Developer Edition licensee also has the right to redistribute SQL Server CE-based applications to an unlimited number of devices at no additional cost beyond the purchase price of SQL Server 2000 Developer Edition.|||SQL Server 2000 has the following editions:
Personal Edition
Standard Edition
Enterprise Edition
Developer Edition
Desktop Engine
SQL Server CE
Evaluation Edition
Personal Edition can work on the Windows 98, Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Workstation 4.0 with Service Pack 5 or later and on the all editions of Windows 2000. This edition is related to SQL Server 7.0 Desktop Edition.
This edition has some restrictions:
maximum 2 CPU
no Distributed Partitioned Views
no Log Shipping
no Parallel DBCC
no Parallel index creation
no Failover clustering
no publishing for transaction replication
maximum 2Gb RAM
Standard Edition can work on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter.
This edition has the following restrictions:
maximum 4 CPU (up to 8 CPU on the Windows NT Enterprise Edition)
no Distributed Partitioned Views
no Log Shipping
no Parallel index creation
no Failover clustering
maximum 2Gb RAM
Enterprise Edition can work on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter.
This edition can use:
up to 32 CPU on the Windows 2000 DataCenter up to 8 CPU on the Windows 2000 Advanced Server and on the Windows NT Server 4.0 Enterprise Edition up to 4 CPU on the Windows NT Server 4.0 and on the Windows 2000 Server
up to 64Gb RAM on the Windows 2000 DataCenter up to 8 Gb RAM on the Windows 2000 Advanced Server up to 4 Gb RAM on the Windows 2000 Server up to 3 Gb RAM on the Windows NT Server 4.0 Enterprise Edition up to 2 Gb RAM on the Windows NT Server 4.0
Distributed Partitioned Views
Log Shipping
Parallel index creation
Failover clustering
The Developer Edition can be used by developers to create and debug stored procedures and triggers. This edition comes with its own compact disc and can be upgraded to SQL Server 2000 Enterprise Edition.
The Desktop Engine has no graphical user interface and is related to the MSDE, not to the SQL Server 7.0 Desktop Edition. The size of Desktop Engine databases cannot exceed 2 GB. The Desktop Engine can use maximum 2 CPU.
The SQL Server CE edition can work only on the Microsoft Windows CE, so it has all restrictions of this operation system (can use only 1 CPU, no Parallel index creation, no Full-Text Search and so on).
The Evaluation Edition can be used only for the test purposes to learn more about the new features and enhancements and should be uninstalled after a 120-day evaluation period.
i mean except that with in the developer edition only 1 user can login
on what version is it better to develop ?
does the developer ver. include something that the entprise does not ? (or vice versa)
(say in theory i can choose on which version to work ;-))
thanx, max.Directly from Microsoft's site:
Developer edition is designed to allow developers to build any type of application on top of SQL Server. It includes all the functionality of Enterprise Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment. It is the ideal choice for Independent Software Vendors (ISVs), consultants, system integrators, solution providers, and corporate developers developing and testing applications because it is cost effective, runs on a variety of platforms, and can be upgraded for production use to SQL Server 2000 Enterprise Edition.
It is the only edition of SQL Server 2000 that gives the licensee the right to download and install SQL Server 2000 Windows CE Edition (SQL Server CE). The Developer Edition licensee also has the right to redistribute SQL Server CE-based applications to an unlimited number of devices at no additional cost beyond the purchase price of SQL Server 2000 Developer Edition.|||SQL Server 2000 has the following editions:
Personal Edition
Standard Edition
Enterprise Edition
Developer Edition
Desktop Engine
SQL Server CE
Evaluation Edition
Personal Edition can work on the Windows 98, Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Workstation 4.0 with Service Pack 5 or later and on the all editions of Windows 2000. This edition is related to SQL Server 7.0 Desktop Edition.
This edition has some restrictions:
maximum 2 CPU
no Distributed Partitioned Views
no Log Shipping
no Parallel DBCC
no Parallel index creation
no Failover clustering
no publishing for transaction replication
maximum 2Gb RAM
Standard Edition can work on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter.
This edition has the following restrictions:
maximum 4 CPU (up to 8 CPU on the Windows NT Enterprise Edition)
no Distributed Partitioned Views
no Log Shipping
no Parallel index creation
no Failover clustering
maximum 2Gb RAM
Enterprise Edition can work on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter.
This edition can use:
up to 32 CPU on the Windows 2000 DataCenter up to 8 CPU on the Windows 2000 Advanced Server and on the Windows NT Server 4.0 Enterprise Edition up to 4 CPU on the Windows NT Server 4.0 and on the Windows 2000 Server
up to 64Gb RAM on the Windows 2000 DataCenter up to 8 Gb RAM on the Windows 2000 Advanced Server up to 4 Gb RAM on the Windows 2000 Server up to 3 Gb RAM on the Windows NT Server 4.0 Enterprise Edition up to 2 Gb RAM on the Windows NT Server 4.0
Distributed Partitioned Views
Log Shipping
Parallel index creation
Failover clustering
The Developer Edition can be used by developers to create and debug stored procedures and triggers. This edition comes with its own compact disc and can be upgraded to SQL Server 2000 Enterprise Edition.
The Desktop Engine has no graphical user interface and is related to the MSDE, not to the SQL Server 7.0 Desktop Edition. The size of Desktop Engine databases cannot exceed 2 GB. The Desktop Engine can use maximum 2 CPU.
The SQL Server CE edition can work only on the Microsoft Windows CE, so it has all restrictions of this operation system (can use only 1 CPU, no Parallel index creation, no Full-Text Search and so on).
The Evaluation Edition can be used only for the test purposes to learn more about the new features and enhancements and should be uninstalled after a 120-day evaluation period.
Friday, March 9, 2012
Diagram changes
There seem to be a number of annoying little problems with the diagram tool
in sql server 2005 (and previous versions) and Im not sure if these will be
fixed by installing SP1. The annoyances are
1) I arrange tables so that none of them have scroll bars, but when I print,
some of my tables have scroll-bars on the printed output.
2) In page setup, I set page to landscape. I then arrange my tables to fit
on a single landscape page, save and print. The diagram then rearranges
itself and I end up with multiple pages each containing a small part of the
diagram.
3) Page orentation is not 'remembered' resulting in me having to re-arrange
tables when I next open the diagram
These issues do not happen all the time but when they do it is very annoying.
Are there workarounds to these problems?
Will these 'bugs' get fixed by installing sp1?
@.@.Version = Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14
2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Developer
Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
For Item 1, I always had to drag the bottom of the table just a bit lower
than the bottom of the last field.
Can't help on 2 & 3
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Terry Holland" <MSDNNospam248@.nospam.nospam> wrote in message
news:F5B57303-2098-40E2-8C3C-D12018FE94FE@.microsoft.com...
> There seem to be a number of annoying little problems with the diagram
> tool
> in sql server 2005 (and previous versions) and Im not sure if these will
> be
> fixed by installing SP1. The annoyances are
> 1) I arrange tables so that none of them have scroll bars, but when I
> print,
> some of my tables have scroll-bars on the printed output.
> 2) In page setup, I set page to landscape. I then arrange my tables to
> fit
> on a single landscape page, save and print. The diagram then rearranges
> itself and I end up with multiple pages each containing a small part of
> the
> diagram.
> 3) Page orentation is not 'remembered' resulting in me having to
> re-arrange
> tables when I next open the diagram
> These issues do not happen all the time but when they do it is very
> annoying.
> Are there workarounds to these problems?
> Will these 'bugs' get fixed by installing sp1?
>
> @.@.Version = Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14
> 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Developer
> Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
|||Hi,
For your three issues, I reproduced the first one. My SQL Server 2005 was
installed with SP1.
>1) I arrange tables so that none of them have scroll bars, but when I
print,
>some of my tables have scroll-bars on the printed output.
I tried four times to reproduce this issue. It seemed that the scroll bars
occurred when we ajusted the border closely to the last column.
>2) In page setup, I set page to landscape. I then arrange my tables to
fit
>on a single landscape page, save and print. The diagram then rearranges
>itself and I end up with multiple pages each containing a small part of
the
>diagram.
I set the orientation to landscape, save and print the diagram, but the
diagram did not rearrange.
>3) Page orentation is not 'remembered' resulting in me having to
re-arrange
>tables when I next open the diagram
From my test, the page orentation was remembered.
Also, I noticed that the issues rarely happened at your side, so I am not
sure if my test can prove that these issues had already been fixed in SP1.
If it persists, I recommend that you give Microsoft feedback on these
issues. Your suggestions will be routed to SQL team and the issues will be
resolved in the next release.
https://connect.microsoft.com/sql
If you are very concerned with this issue, I recommend that you contact
Microsoft Customer Support Services (CSS) via telephone so that a dedicated
Support Professional can assist you recover the server in a more efficient
manner. Please be advised that contacting phone support will be a charged
call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Please feel free to let me know if you have any other questions or concerns.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hi,
Just check with you to see if this issue persists after your installing SQL
Server 2005 SP1.
Please feel free to let us know if you need further assistance.
Have a great day!
Sincerely yours,
Charles Wang
Microsoft Online Community Support
in sql server 2005 (and previous versions) and Im not sure if these will be
fixed by installing SP1. The annoyances are
1) I arrange tables so that none of them have scroll bars, but when I print,
some of my tables have scroll-bars on the printed output.
2) In page setup, I set page to landscape. I then arrange my tables to fit
on a single landscape page, save and print. The diagram then rearranges
itself and I end up with multiple pages each containing a small part of the
diagram.
3) Page orentation is not 'remembered' resulting in me having to re-arrange
tables when I next open the diagram
These issues do not happen all the time but when they do it is very annoying.
Are there workarounds to these problems?
Will these 'bugs' get fixed by installing sp1?
@.@.Version = Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14
2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Developer
Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
For Item 1, I always had to drag the bottom of the table just a bit lower
than the bottom of the last field.
Can't help on 2 & 3
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Terry Holland" <MSDNNospam248@.nospam.nospam> wrote in message
news:F5B57303-2098-40E2-8C3C-D12018FE94FE@.microsoft.com...
> There seem to be a number of annoying little problems with the diagram
> tool
> in sql server 2005 (and previous versions) and Im not sure if these will
> be
> fixed by installing SP1. The annoyances are
> 1) I arrange tables so that none of them have scroll bars, but when I
> print,
> some of my tables have scroll-bars on the printed output.
> 2) In page setup, I set page to landscape. I then arrange my tables to
> fit
> on a single landscape page, save and print. The diagram then rearranges
> itself and I end up with multiple pages each containing a small part of
> the
> diagram.
> 3) Page orentation is not 'remembered' resulting in me having to
> re-arrange
> tables when I next open the diagram
> These issues do not happen all the time but when they do it is very
> annoying.
> Are there workarounds to these problems?
> Will these 'bugs' get fixed by installing sp1?
>
> @.@.Version = Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14
> 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Developer
> Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
|||Hi,
For your three issues, I reproduced the first one. My SQL Server 2005 was
installed with SP1.
>1) I arrange tables so that none of them have scroll bars, but when I
print,
>some of my tables have scroll-bars on the printed output.
I tried four times to reproduce this issue. It seemed that the scroll bars
occurred when we ajusted the border closely to the last column.
>2) In page setup, I set page to landscape. I then arrange my tables to
fit
>on a single landscape page, save and print. The diagram then rearranges
>itself and I end up with multiple pages each containing a small part of
the
>diagram.
I set the orientation to landscape, save and print the diagram, but the
diagram did not rearrange.
>3) Page orentation is not 'remembered' resulting in me having to
re-arrange
>tables when I next open the diagram
From my test, the page orentation was remembered.
Also, I noticed that the issues rarely happened at your side, so I am not
sure if my test can prove that these issues had already been fixed in SP1.
If it persists, I recommend that you give Microsoft feedback on these
issues. Your suggestions will be routed to SQL team and the issues will be
resolved in the next release.
https://connect.microsoft.com/sql
If you are very concerned with this issue, I recommend that you contact
Microsoft Customer Support Services (CSS) via telephone so that a dedicated
Support Professional can assist you recover the server in a more efficient
manner. Please be advised that contacting phone support will be a charged
call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Please feel free to let me know if you have any other questions or concerns.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hi,
Just check with you to see if this issue persists after your installing SQL
Server 2005 SP1.
Please feel free to let us know if you need further assistance.
Have a great day!
Sincerely yours,
Charles Wang
Microsoft Online Community Support
Friday, February 24, 2012
Developer edition versions
My apologies if this is the wrong newsgroup.
In the UK i have been hunting for a copy of SQL Server 2005 Developer. The
problem i have is that i can only source the 64 bit version and the
specifications on the various suppliers site states it will only work with a
64 bit OS.
Could anyone help me by pointing out if there is a 32 bit version and if
they know where I can find a copy?
I did try the MS shop which appears to offer a 32/64 bit version but they
don't ship to the UK and they customer support email was a waste of time.
Thanks.Hi Matt,
I stumbled upon this site in the UK.
http://www.saversoftware.co.uk/details-918.htm
Check it out
Hope this helps
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1
In the UK i have been hunting for a copy of SQL Server 2005 Developer. The
problem i have is that i can only source the 64 bit version and the
specifications on the various suppliers site states it will only work with a
64 bit OS.
Could anyone help me by pointing out if there is a 32 bit version and if
they know where I can find a copy?
I did try the MS shop which appears to offer a 32/64 bit version but they
don't ship to the UK and they customer support email was a waste of time.
Thanks.Hi Matt,
I stumbled upon this site in the UK.
http://www.saversoftware.co.uk/details-918.htm
Check it out
Hope this helps
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1
Developer edition versions
My apologies if this is the wrong newsgroup.
In the UK i have been hunting for a copy of SQL Server 2005 Developer. The
problem i have is that i can only source the 64 bit version and the
specifications on the various suppliers site states it will only work with a
64 bit OS.
Could anyone help me by pointing out if there is a 32 bit version and if
they know where I can find a copy?
I did try the MS shop which appears to offer a 32/64 bit version but they
don't ship to the UK and they customer support email was a waste of time.
Thanks.
Hi Matt,
I stumbled upon this site in the UK.
http://www.saversoftware.co.uk/details-918.htm
Check it out
Hope this helps
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
In the UK i have been hunting for a copy of SQL Server 2005 Developer. The
problem i have is that i can only source the 64 bit version and the
specifications on the various suppliers site states it will only work with a
64 bit OS.
Could anyone help me by pointing out if there is a 32 bit version and if
they know where I can find a copy?
I did try the MS shop which appears to offer a 32/64 bit version but they
don't ship to the UK and they customer support email was a waste of time.
Thanks.
Hi Matt,
I stumbled upon this site in the UK.
http://www.saversoftware.co.uk/details-918.htm
Check it out
Hope this helps
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
Developer edition versions
My apologies if this is the wrong newsgroup.
In the UK i have been hunting for a copy of SQL Server 2005 Developer. The
problem i have is that i can only source the 64 bit version and the
specifications on the various suppliers site states it will only work with a
64 bit OS.
Could anyone help me by pointing out if there is a 32 bit version and if
they know where I can find a copy?
I did try the MS shop which appears to offer a 32/64 bit version but they
don't ship to the UK and they customer support email was a waste of time.
Thanks.Hi Matt,
I stumbled upon this site in the UK.
http://www.saversoftware.co.uk/details-918.htm
Check it out :)
Hope this helps :)
--
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200609/1
In the UK i have been hunting for a copy of SQL Server 2005 Developer. The
problem i have is that i can only source the 64 bit version and the
specifications on the various suppliers site states it will only work with a
64 bit OS.
Could anyone help me by pointing out if there is a 32 bit version and if
they know where I can find a copy?
I did try the MS shop which appears to offer a 32/64 bit version but they
don't ship to the UK and they customer support email was a waste of time.
Thanks.Hi Matt,
I stumbled upon this site in the UK.
http://www.saversoftware.co.uk/details-918.htm
Check it out :)
Hope this helps :)
--
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200609/1
Subscribe to:
Posts (Atom)