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 bo*@s-i-inc.com www.s-i-inc.com 5  3913 
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/
"Robert Schuldenfrei" <bo*@s-i-inc.com> wrote in message
news:T0kCc.164631$Ly.10904@attbi_s01...
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 bo*@s-i-inc.com www.s-i-inc.com
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/techinf...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/de...us/startsql/po
rtal_7ap1.asp?frame=true
HTH.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
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
"Kevin Yu [MSFT]" <v-****@online.microsoft.com> wrote in message
news:uF*************@cpmsftngxa10.phx.gbl... 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/techinf...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/de...us/startsql/po rtal_7ap1.asp?frame=true
HTH.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
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
"Kevin Yu [MSFT]" <v-****@online.microsoft.com> wrote in message
news:uF*************@cpmsftngxa10.phx.gbl... 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/techinf...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/de...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 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/d...displaylang=en
Cheers,
--
Joerg Jooss jo*********@gmx.net This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Igor Solodovnikov |
last post by:
Hi.
I am trying to automatically backup transaction log when error 9002
happened. So i have created appropriate job and alert to catch this error.
I have two instances of sql server under Windows...
|
by: hplloyd |
last post by:
I want to include MSDE 2000 as part of my setup project for a VB.NET app from
withing VS.NET 2003.
I am having trouble finding out how to do this in terms of changing the
settings re...
|
by: Rosy Moss |
last post by:
I am in the process of cleaning up a database that our company uses to
track jobs, time and expense, and customer information.
We are running Windows 2000 Server with approximately 20 terminals...
|
by: Paul Aspinall |
last post by:
Hi
I have a C# Winform app which runs using SQL Server.
I want to package up the app, so that it deploys with MSDE.
Can anyone offer any pointers or references to help??
Thanks
|
by: Paul Aspinall |
last post by:
Hi
I want to package my C# winforms app, to be deployed with MSDE, as easily as
possible for the end user.
I want to create an MSI or Installshield (prefer MSI), to setup my C# app,
together...
|
by: ad |
last post by:
I am using MSDE as the database of my program.
At the begin of my program, it must display a form for user to enter the
password
After the user enters the password, I will check the password,...
|
by: Sumit |
last post by:
Hi
I'm trying to create an installation application that will install
MSDE.
However, I'm having trouble in doing that.
I have consulted the link http://support.microsoft.com/kb/325004/EN-US/...
|
by: NWx |
last post by:
Hi,
I'm an old developer, but didn't used SQL Server or MSDE to much before.
I have NetSDK instance of MSDE installed on my PC by Net Framework SDK.
All quickstart samples access it using...
|
by: Sebastian Santacroce |
last post by:
Is it posible to package MSDE with VB .net so that its
part of the installation?
If so, is there documentation somewhere?
What about packaging the .net framework with the
application as well?
...
|
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$) {
}
...
|
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...
|
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...
|
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
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
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...
|
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,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
