I have downloaded and installed MSDE.
I try to configure by entering osql -S(local)\VSdotNET -E  at a command
prompt.
I expect a 1> prompt.

I cannot seem to create a server instance when installing the MSDE.
step 1. I launch my cmd. It pops up with (C:\Documents and Settings\Billy
I type setup instancename="netsdk" sapwd="sa"
I immediately get a status message saying go to the control planel and

I have MSDE (SQL server) running various workstations within my home
network.  I have no problem connecting to the SQL server instance on
each local machine but when I try to connect to a SQL server on one of
the other workstations I get errors indicating that the Server cannot

Lets say Select * from Table returns 100 rows.
How can I get only get the
First 10 records , 2nd 10 records, etc ...
I now select Top n selects the top n rows from a query, but is there a

Can I simply backup a database currently on desktop edition an
restore it to a different server running Standard Edition (sam
service pack)?  Or do I need to use DTS to move the database?  Ar
there any gotchas that I need to watch out for

I installed MSDE 2000 using the sql2k32desksp4 downloaded from microsoft.
But, I have problem when I created a table from Query Analyzer, it will be
read-only and I can not add data into my table in the database.
I try to use stored procedure to create, same thing happen.

I have following questions regarding C#  Assembly and Threading.
Let me know the precise answer or lead me to the proper materials.
1.  Is memory leakeage possible in .Net Manager Code ?
2. Is memory leakage possible in .Net Unmanaged Code ?

Strong SA Password to install MSDE?
How can I tell if MSDE is on my machine already?
If not how to do I assigne a Strong Sys Admin Password to install
MSDE?

I have a server with MSDE7 installed, for use with Veritas BackupExec 9.
On the same server I want to install WSUS which needs MDSE2000.
Can I install both MSDE7 and MSDE2000 on the same server?

One of my clients is running SQL 2000 SP4 and the Data Maintenance Plan
logs shows a log with...
----
Database master: Check Data and Index Linkage...

On a Windows 2000 server I'm going to install MSDE.
What other software do I need have installed?
MDAC?
.NET?

Here's something that will make you scratch your head!
I have a table that has a UniqueIdentifier as its primary key, but also have
an autoincrement column (InvoiceNumber) that is not part of the primary key.
This table contains about 3000 records.  But for an unknown reason

Why would the localhost not install but rather our named instance will
install?  We have an inconsistent problem with installations.  Our app
depends on a named instance and a secondary app depends on local host
so we need both.  However, systems that have previous installed,

I try to connect to a SQLserver by SQLDMO, "Timeout error" occured in the
following line of code:
MySqlServer.Connect ServerName:=sSRVNameDMO, Login:=sSRVUserDMO,
PASSWORD:=sSRVPassDMO

Hello, I admit I am completely ignorant of MSDE and SQL in general.  Ive
developed many things with php / mysql and a few with access but MS SQL is a
completly new beast for me.  Ive been told i need to develop it locally with
MSDE then upload the finished project to the SQL ...