468,771 Members | 1,920 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,771 developers. It's quick & easy.

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 2640
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by cppaddict | last post: by
1 post views Thread by Craig Skrabacz | last post: by
1 post views Thread by Daniel A. Thomas | last post: by
2 posts views Thread by Herfried K. Wagner [MVP] | last post: by
4 posts views Thread by Ben Kim | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.