MSDE user's guide

[Robert Schuldenfrei]

Dear NG,

I am using MSDE in my study of C#. It works well, however I would like to know more about MSDE itself. There seems to be no counter part to Query Analyzer of the full blown SQL Server. I have stumbled on to OSQL that can be run from the Command Prompt. By typing OSQL -? I get the list of commands. By using the -i switch I can execute SQL commands from a file. Does anyone know of a manual or user guide for MSDE? TIA.

Cheers,

Bob

Robert Schuldenfrei



S. I. Inc.

32 Ridley Road

Dedham, MA 02026



(781) 329-4828

(e-mail address removed)

www.s-i-inc.com

 

[clintonG]

Yea. Google: "msde"


--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET csgallagher@ REMOVETHISTEXT metromilwaukee.com
URL http://www.metromilwaukee.com/clintongallagher/



Dear NG,

I am using MSDE in my study of C#. It works well, however I would like to know
more about MSDE itself. There seems to be no counter part to Query Analyzer of
the full blown SQL Server. I have stumbled on to OSQL that can be run from the
Command Prompt. By typing OSQL -? I get the list of commands. By using the -i
switch I can execute SQL commands from a file. Does anyone know of a manual or
user guide for MSDE? TIA.

Cheers,

Bob

Robert Schuldenfrei



S. I. Inc.

32 Ridley Road

Dedham, MA 02026



(781) 329-4828

(e-mail address removed)

www.s-i-inc.com

 

[Kevin Yu [MSFT]]

Hi Robert,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to get a users's manual for
MSDE. If there is any misunderstanding, please feel free to let me know.

As far as I know, the MSDE's user's manual is the same as SQL Server's. You
can download SQL Server 2000 Books Online from the following link:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

It is also available online in MSDN. If you don't want to install it
locally, please check it from the following link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/po
rtal_7ap1.asp?frame=true

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

 

[Robert Schuldenfrei]

Hi Kevin,

You are "right on" with your understanding of my problem. Your answer
reminded me to always look in the MSDN library. I am going to download the
SQL Server 2000 book. I need to know more about this product. However,
MSDE is missing a key component of SQL Server, Query Analyzer. This is my
basic tool for database creation and probing existing databases. I have
discovered the command line program OSQL. After a little hunting I did find
some documentation about OSQL. The best way to probe MSDE databases I have
found so far is to create an Access Project and investigate the components
of the sample database.

Thanks for your help,

Bob

 

[Joerg Jooss]

Robert Schuldenfrei wrote:
[...]

The best way to probe MSDE databases I have found so far
is to create an Access Project and investigate the components of the
sample database.

Provided you have ASP.NET up and running on your development PC, you can use
Microsoft SQL Web Data Administrator which is free and available at
http://www.microsoft.com/downloads/...98-c57a-419e-acbc-2a332cb7f959&displaylang=en

Cheers,