473,383 Members | 1,853 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,383 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 2817
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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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...

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.