Difference between MSDE and SQL Server 2000

Hello everyone,i want to know abt the "Difference between MSDE and SQL Server 2000". For example the features they support, capacity and requirements etc...

Reply me asap.

Thanx in Advance.

Here are a few links that should help:

http://download.microsoft.com/download/8/1/7/817bb6e6-9d97-4a5d-be8d-508256ae4045/ChoosEd.doc

http://msdn2.microsoft.com/en-us/library/aa175266(SQL.80).aspx

http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx

HTH!

Difference between MSDE 7 and SQL 7

Is there a registry key that will tell me if am running MSDE 7 or MS
SQL 7?
Thanks
I guess MSDE 7 is just a typo of yours, but there does not have to be
only the one OR the other, there can also be the two of them installed
on the server, so it would be evenbetter for you to enumerate the
instances on the machine using DMO or SMO.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||This is the situation, I have a wise installation that needs to check
if the target pc is running either MSDE or full SQL. In our case the
target pc will only be running one or the other. Thats why I was
wondering if there is a registry key that will tell me which one is
running.
|||Mapping MSDE versions to their corresponding versions of SQL Server:
MSDE 1.0 used SQL Server 7.0 technology.
MSDE 2000 (also known as SQL Server 2000 Desktop Engine) used SQL Server
2000 technology.
SQL Server 2005 Express Edition is the MSDE replacement for SQL Server 2005.
You could only run one instance of either MSDE 1.0 or SQL Server 7.0 on a
computer, support for multiple instances of the Database Engine on one
computer was not introduced until SQL Server 2000.
I don't know of a registry key, but if you issue a SELECT @.@.VERSION
statement it will report the version of SQL Server 7.0 (MSDE or an edition
such as Standard or Enterprise).
Alan Brewer [MSFT]
SQL Server Documentation Team
Download the latest Books Online update:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Alan is right, but there are also .NET Framework factory classes that can
report all instances (2000 or 2005) on a network and on any specific
instance, the version etc. There is an example of this on my book's DVD.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Alan Brewer [MSFT]" <alanbr@.microsoft.com> wrote in message
news:OCdydtkRHHA.4060@.TK2MSFTNGP03.phx.gbl...
> Mapping MSDE versions to their corresponding versions of SQL Server:
> MSDE 1.0 used SQL Server 7.0 technology.
> MSDE 2000 (also known as SQL Server 2000 Desktop Engine) used SQL Server
> 2000 technology.
> SQL Server 2005 Express Edition is the MSDE replacement for SQL Server
> 2005.
> You could only run one instance of either MSDE 1.0 or SQL Server 7.0 on a
> computer, support for multiple instances of the Database Engine on one
> computer was not introduced until SQL Server 2000.
> I don't know of a registry key, but if you issue a SELECT @.@.VERSION
> statement it will report the version of SQL Server 7.0 (MSDE or an edition
> such as Standard or Enterprise).
> --
> Alan Brewer [MSFT]
> SQL Server Documentation Team
> Download the latest Books Online update:
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

Device activation error

Hello,
I'm attempting to upgrade from MSDE 1.0 to MSDE 2000. However, before
removing MSDE 1.0, a database apparently was not properly detached after
attempting to attach (using sp_attach_db not attach w/ single file) this very
database to MSDE 2000.
The following error is rec'd:
"Can not create file C:\Program Files...\MyData.LDF because it already
exists.
Could not open new database "MyData". CREATE DATABASE is aborted.
Device activation error. The physical file name "C:\MSSQL7\Data\MyData.LDF
may be incorrect."
Should I attempt to place the log file back to its old location, restore the
database and then detach or should I try to shrink the file and truncate the
log?
Just want to know before I further screw things up.
any help is appreciated.
Hello,
If you have the latest backup then RESTORE the DATABASe using RESTORE
DATABASE WITH MOVE options..Try restoring using a new name and make sure
that
dataBase backup is good.
Thanks
Hari
"jim" <jim@.discussions.microsoft.com> wrote in message
news:F3BE2646-3666-40C7-AF83-763ED47957B2@.microsoft.com...
> Hello,
> I'm attempting to upgrade from MSDE 1.0 to MSDE 2000. However, before
> removing MSDE 1.0, a database apparently was not properly detached after
> attempting to attach (using sp_attach_db not attach w/ single file) this
> very
> database to MSDE 2000.
> The following error is rec'd:
> "Can not create file C:\Program Files...\MyData.LDF because it already
> exists.
> Could not open new database "MyData". CREATE DATABASE is aborted.
> Device activation error. The physical file name "C:\MSSQL7\Data\MyData.LDF
> may be incorrect."
> Should I attempt to place the log file back to its old location, restore
> the
> database and then detach or should I try to shrink the file and truncate
> the
> log?
> Just want to know before I further screw things up.
> any help is appreciated.
>
|||Hi Hari,
Thanks for the response. I just have one more question. With the new
database name, does this mean that the existing database name can no longer
be used on this computer? Or, once the database is restored, I can detach the
database w/ the new database name and then attach the database w/ the old
name in the new location? Hopefully, this question isn't too silly.
your help is appreciated.
"Hari Prasad" wrote:

> Hello,
> If you have the latest backup then RESTORE the DATABASe using RESTORE
> DATABASE WITH MOVE options..Try restoring using a new name and make sure
> that
> dataBase backup is good.
> Thanks
> Hari
> "jim" <jim@.discussions.microsoft.com> wrote in message
> news:F3BE2646-3666-40C7-AF83-763ED47957B2@.microsoft.com...
>
>

Device activation error

Hi All,

Currently I have a PC that has MSDE installed on it and is attached to database (MyData.MDF and a log file MYLog.LDF) located on its hard drive at c:\data\.When I detach from the database, place a copy of the two files noted above on my networkdrive @. u:\data and try to attach I get the following error’s:

SQL[1] exec error = -1: Changed database context to 'master'.

“Device activation error. The physical file name u:\data\MyData.MDF may be incorrect.”

I have done some testing a have found that I can attach to a copy of my database if I move it anywhere on the c: drive, and or even to a 1Gb USB key attached to the system(e:\).So far it seems to only be an issue if I move it to a mapped network drive.If anyone could please provide me with any info it would be greatly appreciated.

Thanks.

James D.

First, your data must be stored on an approved network server/storage you want to be supported. Second, you will have to use a special trace flag to force sqlserver to mount a networked db file. See the following article:
http://support.microsoft.com/kb/304261|||

It's because your U: drive isn't a local drive. By default, it's not support to place data files on mapped shares or UNC paths. You can find more information in the following article:

Description of support for network database files in SQL Server

http://support.microsoft.com/?id=304261

-Sue

|||

Excellent, thank you for the response.

After I use the trace flag mentioned and get my MS SQL Server Desktop Engine to mount to the networked db files, will it be possible to have a second PC with MS SQL Server Desktop Engine also installed on it to connect to the same networked DB files at the same time as the first unit, or will it be limited to just one PC at a time due to file locks? We require that at least two units(possibly up to 3 more in the future) can all share, write, and read to same networked db files at the same time. If you could please let me know when you have a moment it would be great.

Thanks.

James D.

|||

Sqlserver is a shared nothing technology. I.e. only one instance can access the data at any time. So, no, you cannot have another server hits that network database file(s). As it stands, unless your hardware is part of the qualified HCL, you're running in an unsupported platform.

Btw, sqlserver has a feature called Scalable Shared Database (SSD) which allows multiple instances to share the same database file. However, this requires a SAN.

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

Developer Edition Install

Hi, folks.
I've just reached the end of my frustration with trying to learn MSDE with no interface (in addition to ASP.NET), so I'm going to install 2K Developer Edition. However, I'd like to know if it's safe install it on top of MSDE. I'm currently running XP Pr
o, VS.NET, IIS 5.x, so I'm afraid that if I have uninstall MSDE that I'll break a bunch things that I've painstakingly configured. ;-)
Advice?
TIA,
Bob
What have you painstakingly configured? You might be able to easily =
configure these within SQL Server Developer Edition. =20
The other option: install the Developer Edition of SQL Server as a named =
instance. That will allow you to keep MSDE installed as well as give =
you the ability to use SQL Server (Developer Edition) on your computer.
--=20
Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =
news:1BD19D74-8A5A-4F9C-8FD6-D013309B7A45@.microsoft.com...
> Hi, folks.
>=20
> I've just reached the end of my frustration with trying to learn MSDE =
with no interface (in addition to ASP.NET), so I'm going to install 2K =
Developer Edition. However, I'd like to know if it's safe install it on =
top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm =
afraid that if I have uninstall MSDE that I'll break a bunch things that =
I've painstakingly configured. ;-)
>=20
> Advice?
>=20
> TIA,
>=20
> Bob
|||Keith,
The configuration statement actually refers to the installation and configuration of IIS and VS.NET. I feared that when I installed MSDE, it dug its hooks into those applications (inherent in many MS apps) and that uninstalling MSDE would "break" things.
I would prefer to have only one DB application on my machine. With that said, since it appears from your comments, because SQL2k DevEd does not install "on top" of MSDE, I will attempt to uninstall it and then install SQL2k DevEd.
I have developed any databases yet, but either VS.NET, MSDE, or the .NET SDK installed various sample databases. I was hoping to use those to learn from. If those happen to get deleted resulting from the uninstall, at least I've found a place where I ca
n get updated ones.
Any parting words of wisdom before I do the uninstall of MSDE and install of SQL2k DevEd?
Thanks,
Bob
|||The many "sample" databases should still exist -- in mdf and ldf form. =
Hopefully you will be able to use sp_attach_db to attach those databases =
to SQL Server Developer Edition.
Words of wisdom: Just do it.
Good luck. Post back if you have any questions along the way. There =
are many helpful people in the newsgroups that should be able to provide =
assistance should you need it.
--=20
Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =
news:4A5D898D-9A17-4C87-8554-AF6EFBF0F4DB@.microsoft.com...
> Keith,
>=20
> The configuration statement actually refers to the installation and =
configuration of IIS and VS.NET. I feared that when I installed MSDE, =
it dug its hooks into those applications (inherent in many MS apps) and =
that uninstalling MSDE would "break" things.
>=20
> I would prefer to have only one DB application on my machine. With =
that said, since it appears from your comments, because SQL2k DevEd does =
not install "on top" of MSDE, I will attempt to uninstall it and then =
install SQL2k DevEd.
>=20
> I have developed any databases yet, but either VS.NET, MSDE, or the =
..NET SDK installed various sample databases. I was hoping to use those =
to learn from. If those happen to get deleted resulting from the =
uninstall, at least I've found a place where I can get updated ones.
>=20
> Any parting words of wisdom before I do the uninstall of MSDE and =
install of SQL2k DevEd?
>=20
> Thanks,
>=20
> Bob
|||Or you could run the pubsinst.sql scripts from another sql server standard
install.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Developer Edition Install

Hi, folks
I've just reached the end of my frustration with trying to learn MSDE with no interface (in addition to ASP.NET), so I'm going to install 2K Developer Edition. However, I'd like to know if it's safe install it on top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm afraid that if I have uninstall MSDE that I'll break a bunch things that I've painstakingly configured. ;-
Advice
TIA
BobWhat have you painstakingly configured? You might be able to easily =configure these within SQL Server Developer Edition.
The other option: install the Developer Edition of SQL Server as a named =instance. That will allow you to keep MSDE installed as well as give =you the ability to use SQL Server (Developer Edition) on your computer.
-- Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =news:1BD19D74-8A5A-4F9C-8FD6-D013309B7A45@.microsoft.com...
> Hi, folks.
> > I've just reached the end of my frustration with trying to learn MSDE =with no interface (in addition to ASP.NET), so I'm going to install 2K =Developer Edition. However, I'd like to know if it's safe install it on =top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm =afraid that if I have uninstall MSDE that I'll break a bunch things that =I've painstakingly configured. ;-)
> > Advice?
> > TIA,
> > Bob|||Keith
The configuration statement actually refers to the installation and configuration of IIS and VS.NET. I feared that when I installed MSDE, it dug its hooks into those applications (inherent in many MS apps) and that uninstalling MSDE would "break" things
I would prefer to have only one DB application on my machine. With that said, since it appears from your comments, because SQL2k DevEd does not install "on top" of MSDE, I will attempt to uninstall it and then install SQL2k DevEd
I have developed any databases yet, but either VS.NET, MSDE, or the .NET SDK installed various sample databases. I was hoping to use those to learn from. If those happen to get deleted resulting from the uninstall, at least I've found a place where I can get updated ones
Any parting words of wisdom before I do the uninstall of MSDE and install of SQL2k DevEd
Thanks
Bob|||The many "sample" databases should still exist -- in mdf and ldf form. =Hopefully you will be able to use sp_attach_db to attach those databases =to SQL Server Developer Edition.
Words of wisdom: Just do it.
Good luck. Post back if you have any questions along the way. There =are many helpful people in the newsgroups that should be able to provide =assistance should you need it.
-- Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =news:4A5D898D-9A17-4C87-8554-AF6EFBF0F4DB@.microsoft.com...
> Keith,
> > The configuration statement actually refers to the installation and =configuration of IIS and VS.NET. I feared that when I installed MSDE, =it dug its hooks into those applications (inherent in many MS apps) and =that uninstalling MSDE would "break" things.
> > I would prefer to have only one DB application on my machine. With =that said, since it appears from your comments, because SQL2k DevEd does =not install "on top" of MSDE, I will attempt to uninstall it and then =install SQL2k DevEd.
> > I have developed any databases yet, but either VS.NET, MSDE, or the =.NET SDK installed various sample databases. I was hoping to use those =to learn from. If those happen to get deleted resulting from the =uninstall, at least I've found a place where I can get updated ones.
> > Any parting words of wisdom before I do the uninstall of MSDE and =install of SQL2k DevEd?
> > Thanks,
> > Bob|||Or you could run the pubsinst.sql scripts from another sql server standard
install.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Developer Edition Install

Hi, folks.
I've just reached the end of my frustration with trying to learn MSDE with n
o interface (in addition to ASP.NET), so I'm going to install 2K Developer E
dition. However, I'd like to know if it's safe install it on top of MSDE.
I'm currently running XP Pr
o, VS.NET, IIS 5.x, so I'm afraid that if I have uninstall MSDE that I'll br
eak a bunch things that I've painstakingly configured. ;-)
Advice?
TIA,
BobWhat have you painstakingly configured? You might be able to easily =
configure these within SQL Server Developer Edition. =20
The other option: install the Developer Edition of SQL Server as a named =
instance. That will allow you to keep MSDE installed as well as give =
you the ability to use SQL Server (Developer Edition) on your computer.
--=20
Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =
news:1BD19D74-8A5A-4F9C-8FD6-D013309B7A45@.microsoft.com...
> Hi, folks.
>=20
> I've just reached the end of my frustration with trying to learn MSDE =
with no interface (in addition to ASP.NET), so I'm going to install 2K =
Developer Edition. However, I'd like to know if it's safe install it on =
top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm =
afraid that if I have uninstall MSDE that I'll break a bunch things that =
I've painstakingly configured. ;-)
>=20
> Advice?
>=20
> TIA,
>=20
> Bob|||Keith,
The configuration statement actually refers to the installation and configur
ation of IIS and VS.NET. I feared that when I installed MSDE, it dug its ho
oks into those applications (inherent in many MS apps) and that uninstalling
MSDE would "break" things.
I would prefer to have only one DB application on my machine. With that sai
d, since it appears from your comments, because SQL2k DevEd does not install
"on top" of MSDE, I will attempt to uninstall it and then install SQL2k Dev
Ed.
I have developed any databases yet, but either VS.NET, MSDE, or the .NET SDK
installed various sample databases. I was hoping to use those to learn fro
m. If those happen to get deleted resulting from the uninstall, at least I'
ve found a place where I ca
n get updated ones.
Any parting words of wisdom before I do the uninstall of MSDE and install of
SQL2k DevEd?
Thanks,
Bob|||The many "sample" databases should still exist -- in mdf and ldf form. =
Hopefully you will be able to use sp_attach_db to attach those databases =
to SQL Server Developer Edition.
Words of wisdom: Just do it.
Good luck. Post back if you have any questions along the way. There =
are many helpful people in the newsgroups that should be able to provide =
assistance should you need it.
--=20
Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =
news:4A5D898D-9A17-4C87-8554-AF6EFBF0F4DB@.microsoft.com...
> Keith,
>=20
> The configuration statement actually refers to the installation and =
configuration of IIS and VS.NET. I feared that when I installed MSDE, =
it dug its hooks into those applications (inherent in many MS apps) and =
that uninstalling MSDE would "break" things.
>=20
> I would prefer to have only one DB application on my machine. With =
that said, since it appears from your comments, because SQL2k DevEd does =
not install "on top" of MSDE, I will attempt to uninstall it and then =
install SQL2k DevEd.
>=20
> I have developed any databases yet, but either VS.NET, MSDE, or the =
.NET SDK installed various sample databases. I was hoping to use those =
to learn from. If those happen to get deleted resulting from the =
uninstall, at least I've found a place where I can get updated ones.
>=20
> Any parting words of wisdom before I do the uninstall of MSDE and =
install of SQL2k DevEd?
>=20
> Thanks,
>=20
> Bob|||Or you could run the pubsinst.sql scripts from another sql server standard
install.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Develop Database on Local machine? MSDE

Hi all
I am experiencing a problem comming to grip[s with MSDE and what it does.
I need to develop an SQL Server Database but i only have a Windos XP OS
and not a server type system.
From what i understand i should be able to use msde as the engine and
utilsie the tools that i can install with SQL SERVER eg enterprise manager.
To my way odf thinking that would enable me to develop a database with
out the need for a server OS.
If this is correct i am having trouble installing MSDE 2000 and using it
with enterprise manager. can some please put me on the right path.
I have used the MSDE with SQL Server but the service seems to stop and i
cant get it restarted, so i am beliveing i just dont have it setup
properly.
Please any docs or sites and advice sent my way will be greatly appreciated.
What is the best environment to develop with one PC?
Thanks in advance
Greg
hi Greg,
"oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
news:OQClCBnVEHA.2408@.tk2msftngp13.phx.gbl...
> Hi all
> I am experiencing a problem comming to grip[s with MSDE and what it does.
> I need to develop an SQL Server Database but i only have a Windos XP OS
> and not a server type system.
> From what i understand i should be able to use msde as the engine and
> utilsie the tools that i can install with SQL SERVER eg enterprise
manager.
> To my way odf thinking that would enable me to develop a database with
> out the need for a server OS.
> If this is correct i am having trouble installing MSDE 2000 and using it
> with enterprise manager. can some please put me on the right path.
> I have used the MSDE with SQL Server but the service seems to stop and i
> cant get it restarted, so i am beliveing i just dont have it setup
> properly.
> Please any docs or sites and advice sent my way will be greatly
appreciated.
> What is the best environment to develop with one PC?
WinXP is fine, and you cna install on it bot MSDE and/or SQL Server Desktop
Edition or SQL Server Developer edition, now priced at $49.00 =;-D.
the latest solution, the Dev edition, shoul'd be the best one to go, both
for pricing and for tools... you have all the tools you (usually) need to
develop, test and tune your application(s), and then you cna bundle MSDE
with tem, as MSDE was really not intended for develping phase, even if it
can...
as regard your MSDE instance, it's not clear to me your inconvenient... does
it starts and then stops? or does it not start at all?
please check, in the services control panel applet, the account running SQL
Server and SQL Server Agent services...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi andrea
Thanks for your advice, the MSDE instance does start, but for a reason i
cannot find it stops and i cant seem to get it to restart, My only way
to get going again was to uninstall msde and reinstall. I have my
database saved
I have tried the 2000a version of MSDE but get very confused as a
service manager does not appear. so i have no idea on how to get things
going. The doco is more towards deploying than stting up on a local machine.
Can i ask if the developer version is in the Visual studio .net package?
as i might get this (still a student).
Or maybe your view on an ideal developer environment for SQL Server
(Oracle is so much easier) i intend doing the front end with VB
your help is greatly appreciated
regards
greg
Andrea Montanari wrote:
> hi Greg,
> "oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
> news:OQClCBnVEHA.2408@.tk2msftngp13.phx.gbl...
>
> manager.
>
> appreciated.
>
> WinXP is fine, and you cna install on it bot MSDE and/or SQL Server Desktop
> Edition or SQL Server Developer edition, now priced at $49.00 =;-D.
> the latest solution, the Dev edition, shoul'd be the best one to go, both
> for pricing and for tools... you have all the tools you (usually) need to
> develop, test and tune your application(s), and then you cna bundle MSDE
> with tem, as MSDE was really not intended for develping phase, even if it
> can...
> as regard your MSDE instance, it's not clear to me your inconvenient... does
> it starts and then stops? or does it not start at all?
> please check, in the services control panel applet, the account running SQL
> Server and SQL Server Agent services...
|||hi Greg,
"oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
news:%23OdPlByVEHA.1164@.tk2msftngp13.phx.gbl...
> I have tried the 2000a version of MSDE but get very confused as a
> service manager does not appear. so i have no idea on how to get things
> going. The doco is more towards deploying than stting up on a local
machine.
if you set up MSDE without enabling network protocols, the installed
instance can not be shown in service manager combobox as reported in
http://support.microsoft.com/default...b;EN-US;814132

> Can i ask if the developer version is in the Visual studio .net package?
> as i might get this (still a student).
the Dev edition of SQL Server comes only in VS.Net enterprise package... the
other VS.Net editions only provides MSDE...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea Montanari wrote:
> hi Greg,
> "oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
> news:%23OdPlByVEHA.1164@.tk2msftngp13.phx.gbl...
>
> machine.
> if you set up MSDE without enabling network protocols, the installed
> instance can not be shown in service manager combobox as reported in
> http://support.microsoft.com/default...b;EN-US;814132
>
>
> the Dev edition of SQL Server comes only in VS.Net enterprise package... the
> other VS.Net editions only provides MSDE...
Hi andrea
Thanks for your reply, after a long night last night i worked it all
out, i had to actually go to the services window and physically start
service manager, somehow it was set to manual.
Now i have another issue, when i create a database i get a suspect next
to the DB and and an error 5105 "database already exists".
i have searched long and hard on this issue and it seems to be one of
those things that a number of problems could be causing it. do you have
any sugestions.
regards
Greg
|||hi Greg,
"oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
news:eszInS$VEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Now i have another issue, when i create a database i get a suspect next
> to the DB and and an error 5105 "database already exists".
> i have searched long and hard on this issue and it seems to be one of
> those things that a number of problems could be causing it. do you have
> any sugestions.
please have a look at Hugo answer in http://tinyurl.com/3ecnj ... it might
help
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply