473,396 Members | 2,092 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Visual Studio 2002 Professional & MSDE

I have a copy of MS Visual Studio 2002 Professional ACADEMIC which I
understand is the same as the regular Professional version with the
addition of a student CDROM. The installation program on the first
CDROM only copies the MSDE to the harddrive and the copied setup file
has to then be manually executed to complete the installation.

Are the SQL tools such the SQL Enterprise Manager and MS Query
included in the professional version? If so, how can I install these
tools? The course that I am taking uses these tools to study SQL. If
not, how is the MSDE to be used?
Jul 20 '05 #1
4 2819
The MSDE does not contain Enterprise Manager and Query Analyzer. The MSDE
is basically the SQL Server database engine with some restrictions (like a 2
gig max database size). The MSDE allows you to create SQL applications,
just like having SQL Server Desktop or Entrprise version etc., you just
don't have the GUI tools available to you.

J.R.
Largo SQL Tools
The Finest Collection of SQL Tools Available
http://www.largosqltools.com

"Paul S" <hw***@hotmail.com> wrote in message
news:ae**************************@posting.google.c om...
I have a copy of MS Visual Studio 2002 Professional ACADEMIC which I
understand is the same as the regular Professional version with the
addition of a student CDROM. The installation program on the first
CDROM only copies the MSDE to the harddrive and the copied setup file
has to then be manually executed to complete the installation.

Are the SQL tools such the SQL Enterprise Manager and MS Query
included in the professional version? If so, how can I install these
tools? The course that I am taking uses these tools to study SQL. If
not, how is the MSDE to be used?

Jul 20 '05 #2
On 23 Oct 2003 23:23:59 -0700, hw***@hotmail.com (Paul S) wrote:
I have a copy of MS Visual Studio 2002 Professional ACADEMIC which I
understand is the same as the regular Professional version with the
addition of a student CDROM. The installation program on the first
CDROM only copies the MSDE to the harddrive and the copied setup file
has to then be manually executed to complete the installation.

Are the SQL tools such the SQL Enterprise Manager and MS Query
included in the professional version? If so, how can I install these
tools? The course that I am taking uses these tools to study SQL. If
not, how is the MSDE to be used?


Don't know about your problem, however there is a 120 day free trial
of the full ms sql server that can be downloaded from Microsoft's
site. This does include the query analyzer / enterprise manager. You
could also buy the developers version of ms sql server that costs
under $100, and I believe that has the tools that you want.

Charlie

Jul 20 '05 #3
The professional version of Visual Studio does not contain Enterprise
manager.

There is a freeware program called MSDEQuery that you can use instead of MS
Query, look for it on the internet.

I use a version of SQL Server called the Personal Edition (I think that's
waht it's called), which came with Office XP Developer and it has Enterprise
Manager included, so I would think the developer edition would as well.

If you have MS Access, you might try that as I understand you can develop a
database "Project", which is a front end into a SQL Server database. I
don't know for sure, but I think you can build the SQL Server tables that
way. I havn't tried this, so I culd be wrong, but if you have Access it's
worth looking into.

Good luck.
"charliek" <ch*************@hotmail.com> wrote in message
news:cq********************************@4ax.com...
On 23 Oct 2003 23:23:59 -0700, hw***@hotmail.com (Paul S) wrote:
I have a copy of MS Visual Studio 2002 Professional ACADEMIC which I
understand is the same as the regular Professional version with the
addition of a student CDROM. The installation program on the first
CDROM only copies the MSDE to the harddrive and the copied setup file
has to then be manually executed to complete the installation.

Are the SQL tools such the SQL Enterprise Manager and MS Query
included in the professional version? If so, how can I install these
tools? The course that I am taking uses these tools to study SQL. If
not, how is the MSDE to be used?


Don't know about your problem, however there is a 120 day free trial
of the full ms sql server that can be downloaded from Microsoft's
site. This does include the query analyzer / enterprise manager. You
could also buy the developers version of ms sql server that costs
under $100, and I believe that has the tools that you want.

Charlie

Jul 20 '05 #4
hi Paul,
"charliek" <ch*************@hotmail.com> wrote in message
news:cq********************************@4ax.com...
On 23 Oct 2003 23:23:59 -0700, hw***@hotmail.com (Paul S) wrote:
I have a copy of MS Visual Studio 2002 Professional ACADEMIC which I
understand is the same as the regular Professional version with the
addition of a student CDROM. The installation program on the first
CDROM only copies the MSDE to the harddrive and the copied setup file
has to then be manually executed to complete the installation.

Are the SQL tools such the SQL Enterprise Manager and MS Query
included in the professional version? If so, how can I install these
tools? The course that I am taking uses these tools to study SQL. If
not, how is the MSDE to be used?


have a look at a free prj of mine, you can find at the link following my
sign., which implements a user interface similar to Enterprise Manager..
Andrea Montanari (Microsoft MVP - SQL Server)
an********@virgilio.it
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.4.0 - DbaMgr ver 0.50.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
Jul 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: cppaddict | last post by:
Hi, I'm trying to figure out which version of Visual Studio .NET to buy. Ebay has some listings for the academic version, and it's MUCH cheaper than the regular version. What are the drawbacks?...
33
by: John Timbers | last post by:
I'd like to purchase Visual C# .Net for learning purposes only since it's a lot cheaper than Visual Studio (note that I'm a very experienced C++ developer). Can someone simply clarify the basic...
1
by: Craig Skrabacz | last post by:
I originally had VB.Net standard installed on my computer. I have subsequently installed Visual Studio .Net 2002 on my computer. I have not uninstalled VB.Net. When I look in my Add/Remove...
0
by: bob .net | last post by:
Server exploI have recently installed Visual Studio .Net 2002 on my workstation running XP Professional. I can connect to local Access and MSDE databases successfully using ADO .Net. I can also...
1
by: Daniel A. Thomas | last post by:
License required Maybe you don't have this but have one of the products that qualifies for the upgrade such as ... Visual Studio .NET 2003 Professional Visual Studio .NET 2003 Professional...
1
by: Scott Chang | last post by:
Hi all, 1)I used Microsoft Visual C++.NET (2002) on my Windows Me and Windows XP Home Edition for the last one and half years. 4-5 weeks ago, I upgraded my PC from Windows XP Home Edition to...
2
by: Herfried K. Wagner [MVP] | last post by:
Hello, There are often questions in this newsgroup posted by VS.NET 2002 users. VS.NET 2002 is "out of date", its successor is VS.NET 2003. There is a special ("cheap") upgrade offer available...
5
by: Microsoft | last post by:
Hi, I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;...
4
by: Ben Kim | last post by:
Hello all, I have VS 2005 and SQL 2005 installed on my machine. However the "Getting Started" area of the Start Page shows SQL information instead of Visual Studio information when I start up...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
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...
0
agi2029
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,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.