Hello!
Visual Studio 2005 includes a copy of SQL Express which is a lightweight
desktop engine version of SQL Server 2005.
Now to my question what is MSDE(Desktop Engine) is that the same as SQL
Express ?
//Tony 5 2075
MSDE is obsolete (support ended in April); SQL Server Express is the
replacement. Note that SQL Server 2008 Express is now available.
Marc
On Aug 18, 2:57*pm, "Tony Johansson" <johansson.ande rs...@telia.com >
wrote:
Hello!
Visual Studio 2005 includes a copy of SQL Express which is a lightweight
desktop engine version of SQL Server 2005.
Now to my question what is MSDE(Desktop Engine) is that the same as SQL
Express ?
MSDE was essentially a cut-down version of SQL Server 2000; SQL
Express fills roughly the same role for SQL Server 2005 & 2008 (though
somewhat expanded, since it does allow remote connections, which MSDE
did not).
There's also SQL Server CE, which is yet another thing (but also
something worth a look at if you need a lightweight local database for
a desktop application).
"Pavel Minaev" <in****@gmail.c omwrote in message
news:06******** *************** ***********@2g2 000hsn.googlegr oups.com...
[...] SQL Express fills roughly the same role for SQL Server
2005 & 2008 (though somewhat expanded, since it does allow
remote connections, which MSDE did not).
This is not entirely accurate. MSDE *did* allow remote connections. The
main limitation in MSDE was that it only worked well with a maximum of 5
remote connections; if you opened more connections then it purposely
degraded its performance to discourage people from using it in this way (and
encourage upgrading to a "full" Sql Server). Sql Express does not have this
limitation and can accept an unrestricted number of remote connections.
On Aug 18, 1:06*pm, "Alberto Poblacion" <earthling-
quitaestoparaco ntes...@poblaci on.orgwrote:
[...] SQL Express fills roughly the same role for SQL Server
2005 & 2008 (though somewhat expanded, since it does allow
remote connections, which MSDE did not).
* *This is not entirely accurate. MSDE *did* allow remote connections.. The
main limitation in MSDE was that it only worked well with a maximum of 5
remote connections; if you opened more connections then it purposely
degraded its performance to discourage people from using it in this way (and
encourage upgrading to a "full" Sql Server). Sql Express does not have this
limitation and can accept an unrestricted number of remote connections.
The other major limitation of MSDE was the size of database it would
cope with. While it looks like there's still a restriction, it's
bigger than it was before (4GB instead of 2GB).
Jon
On Aug 18, 7:15*am, Pavel Minaev <int...@gmail.c omwrote:
On Aug 18, 2:57*pm, "Tony Johansson" <johansson.ande rs...@telia.com >
wrote:
Hello!
Visual Studio 2005 includes a copy of SQL Express which is a lightweight
desktop engine version of SQL Server 2005.
Now to my question what is MSDE(Desktop Engine) is that the same as SQL
Express ?
MSDE was essentially a cut-down version of SQL Server 2000; SQL
Express fills roughly the same role for SQL Server 2005 & 2008 (though
somewhat expanded, since it does allow remote connections, which MSDE
did not).
MSDE does support remote connections. You can manage a remote MSDE
from "Enterprise manager" or "Management Console"
IIRC MSDE did support DTS and the express version does not. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mitchell S. Honnert |
last post by:
In the early days of .NET development, I could react to user's hesitancy to
download the Framework with reassurance that it would eventually be included
in a future service pack. I also pointed out that once the Framework was
installed, later .NET applications could be installed without another hefty
download. I knew that any pushback I'd get would be moot in a few months
when the Framework was integrated into Windows.
I'm wondering if...
|
by: Miro |
last post by:
Ok I have been slowely - and ever so slowely teaching myself VB.net
Currently I have created an MDB file by code, and added fields to the MDB
file by code.
I like this solution because, ( im assuming ) if I create an EXE and I load
an MDB file, I can
see if certain fields are there, and if not add them.
Kinda like an Update that is imbeded into the EXE, so you dont always have
to create an Install shield.
|
by: HC |
last post by:
I posted this in one of the VB forums but I'm starting to think it
might be more appropriate to have it here, since it really seems to be
a SQL server (MSDE/Express 2005) problem:
Hey, all, I have a problem with queries against a SQL server instance
that I just found and is causing me fits. I hope someone can point
me
in the right direction, please. TIA.
Basically, I got a Vista OS machine to test my VB6 app on it as some
|
by: HC |
last post by:
Hello, all, I started out thinking my problems were elsewhere but as I
have worked through this I have isolated my problem, currently, as a
difference between MSDE and SQL Express 2005 (I'll just call it
Express for simplicity).
I have, to try to simplify things, put the exact same DB on two
systems, one running MSDE and one running Express. Both have 2 Ghz
processors (one Intel, one AMD), both have a decent amount of RAM
(Intel system...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |