Difference between these two SQL Express

Anyone can tell me the difference between

Microsoft SQL Server 2005 Express Edition with Advanced Services

and

Microsoft SQL Server 2005 Express Edition Toolkit

I am wondering which one should i install

If you want to use all posisble features of express you should install both.

Difference between Standard and Enterprise Edition

Where can I find about differences between two edition. I need to advise thi
s
for a customer who would be quering over the WANHi
http://www.microsoft.com/sql/editio...rd/default.mspx
"Tariq" <Tariq@.discussions.microsoft.com> wrote in message
news:FF73CE26-9939-4621-83B9-67222E648CE9@.microsoft.com...
> Where can I find about differences between two edition. I need to advise
> this
> for a customer who would be quering over the WAN

Difference between Standard and Enterprise Edition

Where can I find about differences between two edition. I need to advise this
for a customer who would be quering over the WANHi
http://www.microsoft.com/sql/editions/standard/default.mspx
"Tariq" <Tariq@.discussions.microsoft.com> wrote in message
news:FF73CE26-9939-4621-83B9-67222E648CE9@.microsoft.com...
> Where can I find about differences between two edition. I need to advise
> this
> for a customer who would be quering over the WANsql

Difference between Standard and Enterprise Edition

Where can I find about differences between two edition. I need to advise this
for a customer who would be quering over the WAN
Hi
http://www.microsoft.com/sql/edition...d/default.mspx
"Tariq" <Tariq@.discussions.microsoft.com> wrote in message
news:FF73CE26-9939-4621-83B9-67222E648CE9@.microsoft.com...
> Where can I find about differences between two edition. I need to advise
> this
> for a customer who would be quering over the WAN

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.

difference between SQL standard Edition and Enterprise Edition

Hi, there,

We are running SQL 2000 & SP4 with our ASP.NET application, now we plan to upgrade to Enterprise Edition due to the huge diffirence in price. Can any one of u give an brief introduction of the difference between these two, and what is the advantages of enterprise edition?

Any suggestion will greately appreciated.

Shermaine

There's a good comparison of the various versions of SQL Server here:-

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||

shermaine wrote:

now we plan to upgrade to Enterprise Edition due to the huge diffirence in price.

That seems logical.

difference between sql 2000 standard Edition and Enterprise Editio

Hi, there,
I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
to upgrade to 2005 Eterprise Edition immediately due to other reason), can
any one of u tell me the difference between standard Edition and Enterprise
Edition due to there is a huge difference in price.
Thanks in advanced
Rgds
ShermaineHi
A list of features is at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp
The higher spec hardware support is at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
John
"xiaomei" wrote:
> Hi, there,
> I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
> with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
> to upgrade to 2005 Eterprise Edition immediately due to other reason), can
> any one of u tell me the difference between standard Edition and Enterprise
> Edition due to there is a huge difference in price.
> Thanks in advanced
> Rgds
> Shermaine|||Also know that if you are running Windows XP you cannot install enterprise
edition
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1|||Dear John,
Thanks so much.
Have a nice day!
Shermaine
"John Bell" wrote:
> Hi
> A list of features is at:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp
> The higher spec hardware support is at:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
> John
>
> "xiaomei" wrote:
> > Hi, there,
> > I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
> > with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
> > to upgrade to 2005 Eterprise Edition immediately due to other reason), can
> > any one of u tell me the difference between standard Edition and Enterprise
> > Edition due to there is a huge difference in price.
> >
> > Thanks in advanced
> >
> > Rgds
> > Shermaine|||Hi, thanks a lot.
Yes, we will run on windows 2000 server.
BTW, Does Microsoft still provide evaluation copy download for Windows SQL
2000 Enterprise Edition?
Thanks
Shermaine
"Prospero via SQLMonster.com" wrote:
> Also know that if you are running Windows XP you cannot install enterprise
> edition
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1
>|||Hi
An evaluation copy would only be needed if you are going to use the
additional features. I would not load this into a live environment. An
alternative might be to use the developer edition in your test environment,
if this is for stress testing then you should use similar hardware to the
live environment.
John
"xiaomei" wrote:
> Hi, thanks a lot.
> Yes, we will run on windows 2000 server.
> BTW, Does Microsoft still provide evaluation copy download for Windows SQL
> 2000 Enterprise Edition?
> Thanks
> Shermaine
> "Prospero via SQLMonster.com" wrote:
> > Also know that if you are running Windows XP you cannot install enterprise
> > edition
> >
> > --
> > Message posted via SQLMonster.com
> > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1
> >

difference between sql 2000 standard Edition and Enterprise Editio

Hi, there,
I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't wan
t
to upgrade to 2005 Eterprise Edition immediately due to other reason), can
any one of u tell me the difference between standard Edition and Enterprise
Edition due to there is a huge difference in price.
Thanks in advanced
Rgds
ShermaineHi
A list of features is at:
http://msdn.microsoft.com/library/d...br />
1cdv.asp
The higher spec hardware support is at:
http://msdn.microsoft.com/library/d...br />
8dbn.asp
John
"xiaomei" wrote:

> Hi, there,
> I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
> with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't w
ant
> to upgrade to 2005 Eterprise Edition immediately due to other reason), can
> any one of u tell me the difference between standard Edition and Enterpris
e
> Edition due to there is a huge difference in price.
> Thanks in advanced
> Rgds
> Shermaine|||Also know that if you are running Windows XP you cannot install enterprise
edition
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200601/1

difference between sql 2000 standard Edition and Enterprise Editio

Hi, there,
I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
to upgrade to 2005 Eterprise Edition immediately due to other reason), can
any one of u tell me the difference between standard Edition and Enterprise
Edition due to there is a huge difference in price.
Thanks in advanced
Rgds
Shermaine
Hi
A list of features is at:
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
The higher spec hardware support is at:
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
John
"xiaomei" wrote:

> Hi, there,
> I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
> with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
> to upgrade to 2005 Eterprise Edition immediately due to other reason), can
> any one of u tell me the difference between standard Edition and Enterprise
> Edition due to there is a huge difference in price.
> Thanks in advanced
> Rgds
> Shermaine
|||Also know that if you are running Windows XP you cannot install enterprise
edition
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200601/1

Difference between Personal Edition and Standard Edition

We had a vendor install SQL Server Personal Edition
instead of the Standard Edition on one of our servers.
When we asked them "what is the difference" they did not
know. Can someone tell me what it is? We paid for the
Standard (FULL) install..Refer to this url
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_ts_1cdv.asp
--
-Vishal
"Ed" <fsankey@.hotmail.com> wrote in message
news:00a501c3634f$9fba9fc0$a401280a@.phx.gbl...
> We had a vendor install SQL Server Personal Edition
> instead of the Standard Edition on one of our servers.
> When we asked them "what is the difference" they did not
> know. Can someone tell me what it is? We paid for the
> Standard (FULL) install..

Diff between SQL server and SQL server Personal edition

Hi All,
I would like to install SQL server 2000 personal edition
on a workstation as a backup to my server. (disaster
recovery scenario) I run a backup to this machine already
every 30 minutes, all I would have to do is turn on SQL
services, restore the latest backup and I am back up and
running within a few minutes. The workstaion has a 2 GIG
processor and 256 Ram which I am planning on upgrading to
512.
Are there any downsides to running 6 clients hitting this
personal edition server? Is the PE the same as the server
edition? Does the personal edition have limitations that
the server edition does not?
Thanks,
GP
Hi
Just remember that a worstation edition of Windows (XP or 2000 Pro) both
have a limit of 10 concurrent client connections.
Regards
Mike
"GeorgeP" wrote:

> Hi All,
> I would like to install SQL server 2000 personal edition
> on a workstation as a backup to my server. (disaster
> recovery scenario) I run a backup to this machine already
> every 30 minutes, all I would have to do is turn on SQL
> services, restore the latest backup and I am back up and
> running within a few minutes. The workstaion has a 2 GIG
> processor and 256 Ram which I am planning on upgrading to
> 512.
> Are there any downsides to running 6 clients hitting this
> personal edition server? Is the PE the same as the server
> edition? Does the personal edition have limitations that
> the server edition does not?
> Thanks,
> GP
>
|||Thanks,
Yes I know Windows prof. has a conection limitation, but
are there any SQL limitations running on a workstation?
Thanks again for your input.
GP
|||The technical differences between editions are listed in Books Online (see the architecture
section). I suggest you call MS to make sure you aren't violating the licensing agreement:
To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"georgeP" <anonymous@.discussions.microsoft.com> wrote in message
news:493c01c49f24$18fc1830$a601280a@.phx.gbl...
> Thanks,
> Yes I know Windows prof. has a conection limitation, but
> are there any SQL limitations running on a workstation?
> Thanks again for your input.
> GP

Diff between SQL server and SQL server Personal edition

Hi All,
I would like to install SQL server 2000 personal edition
on a workstation as a backup to my server. (disaster
recovery scenario) I run a backup to this machine already
every 30 minutes, all I would have to do is turn on SQL
services, restore the latest backup and I am back up and
running within a few minutes. The workstaion has a 2 GIG
processor and 256 Ram which I am planning on upgrading to
512.
Are there any downsides to running 6 clients hitting this
personal edition server? Is the PE the same as the server
edition? Does the personal edition have limitations that
the server edition does not?
Thanks,
GPThanks,
Yes I know Windows prof. has a conection limitation, but
are there any SQL limitations running on a workstation?
Thanks again for your input.
GP|||The technical differences between editions are listed in Books Online (see the architecture
section). I suggest you call MS to make sure you aren't violating the licensing agreement:
To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"georgeP" <anonymous@.discussions.microsoft.com> wrote in message
news:493c01c49f24$18fc1830$a601280a@.phx.gbl...
> Thanks,
> Yes I know Windows prof. has a conection limitation, but
> are there any SQL limitations running on a workstation?
> Thanks again for your input.
> GP|||Hi
Just remember that a worstation edition of Windows (XP or 2000 Pro) both
have a limit of 10 concurrent client connections.
Regards
Mike
"GeorgeP" wrote:
> Hi All,
> I would like to install SQL server 2000 personal edition
> on a workstation as a backup to my server. (disaster
> recovery scenario) I run a backup to this machine already
> every 30 minutes, all I would have to do is turn on SQL
> services, restore the latest backup and I am back up and
> running within a few minutes. The workstaion has a 2 GIG
> processor and 256 Ram which I am planning on upgrading to
> 512.
> Are there any downsides to running 6 clients hitting this
> personal edition server? Is the PE the same as the server
> edition? Does the personal edition have limitations that
> the server edition does not?
> Thanks,
> GP
>sql

diferent between sql 2005 x86 and x64 ?

I have AMD X2 64 bit processor, and try to install sql server 2005 developer edition. Which one should I choose x86 or x64 ?

Is there a problems if I migrating file database from x86 platform to x64 and from x64 to x86 ?

thanx

There is a great explanation for these architectures (processor types) on wikipedia:

X86:http://en.wikipedia.org/wiki/X86

X64:http://en.wikipedia.org/wiki/X64

Thanks

|||

I'm not asking about processor but about MSSQL 2005 x86 and MSSQL x64 is it different in database architecture or platform only ?

|||

Check if this helps:http://search.techrepublic.com.com/search/64-bit+and+Microsoft+SQL+Server+and+benefit.html

sql

Diap-up Connection Problem

Hi,
I want to replicate data between two SQL Servers but I have connection
problem:
Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
Server A dials to server B. Server A can ping server B (using IP) and I
registered the SQL Server of B on A (in E.M). But server B cannot ping
Server A. I have disabled any kind of anti-virus or ISA service. All of
ports are open, no active firewall. What are the other things that I must
check?
Any help would be greatly appreciated.
LeilaRun tracert to determine exactly where it is failing. It could also be a
name resolution problem. ping -a should help you with this.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:e1YmastyGHA.5048@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I want to replicate data between two SQL Servers but I have connection
> problem:
> Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
> Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
> Server A dials to server B. Server A can ping server B (using IP) and I
> registered the SQL Server of B on A (in E.M). But server B cannot ping
> Server A. I have disabled any kind of anti-virus or ISA service. All of
> ports are open, no active firewall. What are the other things that I must
> check?
> Any help would be greatly appreciated.
> Leila
>

Diap-up Connection Problem

Hi,
I want to replicate data between two SQL Servers but I have connection
problem:
Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
Server A dials to server B. Server A can ping server B (using IP) and I
registered the SQL Server of B on A (in E.M). But server B cannot ping
Server A. I have disabled any kind of anti-virus or ISA service. All of
ports are open, no active firewall. What are the other things that I must
check?
Any help would be greatly appreciated.
LeilaRun tracert to determine exactly where it is failing. It could also be a
name resolution problem. ping -a should help you with this.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:e1YmastyGHA.5048@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I want to replicate data between two SQL Servers but I have connection
> problem:
> Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
> Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
> Server A dials to server B. Server A can ping server B (using IP) and I
> registered the SQL Server of B on A (in E.M). But server B cannot ping
> Server A. I have disabled any kind of anti-virus or ISA service. All of
> ports are open, no active firewall. What are the other things that I must
> check?
> Any help would be greatly appreciated.
> Leila
>

Diagram bug in 2005 Developer edition

I have a few databases which were created using sql server 2000 developer
edition. I copied them to the directory where the sql server 2005 databases
are located. I used "Attach" by right clicking on databases and attached the
databases. When I went to view the diagrams, I got a message that database
diagram support can not be installed because the database does not have a
valid user. Strange I thought since I'm using a laptop and everything else
was installed under the same Windows XP login. So I changed the owner to 'sa
'
and I got the same error message. I fixed the problem by changing the
compatability from 8.0 to 9.0. I did not change the owner on the other
databases that I attached. I got a message for sql server to install object
support, I had it install it and then I could view the diagrams just fine.I don't know if it's considered a bug but it is documented
in the read me file - ReadMeSQL2005.htm which should be off
the root of your installation media. I believe the next
update to BOL will have this documented as well. In the read
me file, check section 4.8.1 titled
Considerations for Installing Database Diagram Support
-Sue
On Thu, 13 Apr 2006 10:22:01 -0700, Doctor Who
<DoctorWho@.discussions.microsoft.com> wrote:

>I have a few databases which were created using sql server 2000 developer
>edition. I copied them to the directory where the sql server 2005 databases
>are located. I used "Attach" by right clicking on databases and attached th
e
>databases. When I went to view the diagrams, I got a message that database
>diagram support can not be installed because the database does not have a
>valid user. Strange I thought since I'm using a laptop and everything else
>was installed under the same Windows XP login. So I changed the owner to 's
a'
>and I got the same error message. I fixed the problem by changing the
>compatability from 8.0 to 9.0. I did not change the owner on the other
>databases that I attached. I got a message for sql server to install object
>support, I had it install it and then I could view the diagrams just fine.

Diagram bug in 2005 Developer edition

I have a few databases which were created using sql server 2000 developer
edition. I copied them to the directory where the sql server 2005 databases
are located. I used "Attach" by right clicking on databases and attached the
databases. When I went to view the diagrams, I got a message that database
diagram support can not be installed because the database does not have a
valid user. Strange I thought since I'm using a laptop and everything else
was installed under the same windows xp login. So I changed the owner to 'sa'
and I got the same error message. I fixed the problem by changing the
compatability from 8.0 to 9.0. I did not change the owner on the other
databases that I attached. I got a message for sql server to install object
support, I had it install it and then I could view the diagrams just fine.I don't know if it's considered a bug but it is documented
in the read me file - ReadMeSQL2005.htm which should be off
the root of your installation media. I believe the next
update to BOL will have this documented as well. In the read
me file, check section 4.8.1 titled
Considerations for Installing Database Diagram Support
-Sue
On Thu, 13 Apr 2006 10:22:01 -0700, Doctor Who
<DoctorWho@.discussions.microsoft.com> wrote:
>I have a few databases which were created using sql server 2000 developer
>edition. I copied them to the directory where the sql server 2005 databases
>are located. I used "Attach" by right clicking on databases and attached the
>databases. When I went to view the diagrams, I got a message that database
>diagram support can not be installed because the database does not have a
>valid user. Strange I thought since I'm using a laptop and everything else
>was installed under the same windows xp login. So I changed the owner to 'sa'
>and I got the same error message. I fixed the problem by changing the
>compatability from 8.0 to 9.0. I did not change the owner on the other
>databases that I attached. I got a message for sql server to install object
>support, I had it install it and then I could view the diagrams just fine.

Devloper Edition on Vista

Hello all,
Quick question. I know that SQL Developer Edition works on XP sp2. Anyone
know if SQL Developer Edition will work on Vista Business. I'm ordering a
new notebook and don't want to have to remove the OS if I don't have to.
Thanks
JohnI'm running Dev Ed on Vista (Ultimate), no real problems. SQL Books Online lists what OS are
supported for each SQL Edition, and Vista with Business should be fine. Just install SQL 2005 sp2
after initial install, so you are supported (etc).
You are in for some work if you want to install RS. Basically, you need to make Vista "present " IIS
6. It was a while since I did this, but with some help from Google etc it wasn't that tough.
I should add that I disabled UAC. I ran it for a couple of days, but it annoyed me too much. I don't
think it caused any particular SQL Server problems, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:DED2615C-7B03-489F-A288-A5350FA2F6F4@.microsoft.com...
> Hello all,
> Quick question. I know that SQL Developer Edition works on XP sp2. Anyone know if SQL Developer
> Edition will work on Vista Business. I'm ordering a new notebook and don't want to have to remove
> the OS if I don't have to.
> Thanks
> John|||I agree with Tibor. I've been using SQL Server 2005 DE since Vista Business
released and no problem at all.
Regarding to IIS, IIS is not being fully installed by default so you need to
add some components to its installation so that you'll be able to use it for
your RS or anything else.
You may want to check out the following link to learn about exactly what
components of IIS should be installed to make RS checkbox enabled when in
SQL Server Setup.
http://support.microsoft.com/default.aspx/kb/934164
--
Ekrem Önsoy
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:DED2615C-7B03-489F-A288-A5350FA2F6F4@.microsoft.com...
> Hello all,
> Quick question. I know that SQL Developer Edition works on XP sp2.
> Anyone know if SQL Developer Edition will work on Vista Business. I'm
> ordering a new notebook and don't want to have to remove the OS if I don't
> have to.
> Thanks
> John|||Thanks for your input guys. I really appreciate it. Vista it is.:-)
John
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:DED2615C-7B03-489F-A288-A5350FA2F6F4@.microsoft.com...
> Hello all,
> Quick question. I know that SQL Developer Edition works on XP sp2.
> Anyone know if SQL Developer Edition will work on Vista Business. I'm
> ordering a new notebook and don't want to have to remove the OS if I don't
> have to.
> Thanks
> John|||"John Holt" wrote:
> Thanks for your input guys. I really appreciate it. Vista it is.:-)
> John
> "John Holt" <johnh@.regionv.k12.mn.us> wrote in message
> news:DED2615C-7B03-489F-A288-A5350FA2F6F4@.microsoft.com...
> > Hello all,
> > Quick question. I know that SQL Developer Edition works on XP sp2.
> > Anyone know if SQL Developer Edition will work on Vista Business. I'm
> > ordering a new notebook and don't want to have to remove the OS if I don't
> > have to.
> >
> > Thanks
> > John
>
I'm having problem installing SQL Reporting Server on Vista Business without
success. Microsoft Vista said 1% incompatiability problem. It is a real
nightmare!

development edition.

Is there ANY difference in development vs. enterprise editions?
I know development editions are not allowed to be used for production.Not technically. They are the same. One tiny thing is that you won't get a
license question during setup for Dev Ed.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"mannie" <anonymous@.discussions.microsoft.com> wrote in message
news:C940311F-21CC-49C1-A28E-97CD5C11F083@.microsoft.com...
> Is there ANY difference in development vs. enterprise editions?
> I know development editions are not allowed to be used for production.

Developing with Enterprise tools, deploying without them

I have designed my database using Sql 2000 Developer Edition, but I need to apply that design to MSDE. I can run the script on a database using MSDE through Enterprise manager on my machine and, using Enterprise manager again, back the database up. How do I restore that backup to a MSDE database on another machine without Enterprise tools?

In other words, I need to install MSDE on another machine and restore a backed up database design to it, without Enterprise tools on the host machine.

Also: If I want to use exactly the same database I have developed using Enterprise tools packaged with Sql 2000 Developer Edition, how may I back 'that' database up so that it may be restored to a MSDE database or replicate the database in question to an MSDE client?

Thank you,
John SpurlinYou can execute a script or query using OSQL from the command line. See the follwoing MSDN article for more details:

osql Utility

Hope this helps

Regards

Wayne Phipps