Install MSDE2000 failed and auto rollback

Dear all,
I use a windows xp with sp1 installed
Then, i install SQL server client tools, this ok!
Then, i install msde2000 , but it auto rollback during installing process
and it does show any error or message...
Even , i try to use sql2ksp3 to install, it also like this, what is the
problem?
Is it the winxp sp1 make this occurs? or other problems?
hi Joe,
Joe wrote:
> Dear all,
> I use a windows xp with sp1 installed
> Then, i install SQL server client tools, this ok!
> Then, i install msde2000 , but it auto rollback during installing
> process and it does show any error or message...
> Even , i try to use sql2ksp3 to install, it also like this, what is
> the problem?
> Is it the winxp sp1 make this occurs? or other problems?
please add the
/L*v "C:\MsdeLog.Txt"
parameter to your command line call to the setup.exe boostrap installer...
this will enable verbose logging of the installation process (about 2mb text
file) you can inspect for
RETURN VALUE 3
entries... about 10/20 lines after or before each entry, some (sometime
cryptic) description of the problem will be listed...
just before running, please verify that File and Printer sharing is enabled
and the Server service is running..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Insertion data via Stored Procedure [URGENT]!

Hi all;

Question:
=======
Q1) How can I insert a record into a table "Parent Table" and get its ID (its PK) (which is an Identity "Auto count" column) via one Stored Procedure??

Q2) How can I insert a record into a table "Child Table" whose (FK) is the (PK) of the "Parent Table"!! via another one Stored Procedure??

Example:
----
I have two tables "Customer" and "CustomerDetails"..

SP1: should insert all "Customer" data and return the value of an Identity column (I will use it later in SP2).

SP2: should insert all "CustomerDetials" data in the record whose ID (the returned value from SP1) is same as ID of the "Customer" table.

FYI:
--
MS SQL Server 2000
VS.NET EA 2003
Win XP SP1a
VB.NET/ASP.NET :)

Thanks in advanced!There are a couple of ways to get the last inserted IDENT, but I prefer to use IDENT_CURRENT('table_name') to get the ID from the last inserted record of thespecified table.

INSERT INTO Customer (val1,val2,etc) VALUES (@.Val1,@.val2,etc)
INSERT INTO CustomerDetails (ID,Val1,Val2, etc) VALUES ((IDENT_CURRENT('Customer'),@.val1,@.val2,etc)

|||Ok, what about if I want to do these process in two SPs??

I want to take the IDDENTITY value from the fitrst "INSERT INTO" statment, because I need this value in my source code as well as other Stored Procedure(s).

Thanks in advanced!|||Insert Blah...;
Return SCOPE_IDENTITY()|||Thanks gays.

I think my problem is how to get the returned value (IDDENTITY value) from the VB.NET code (in other words, how to extract it from VB.NET/ADO.NET code)?

Note:
--
VB.NET/ADO.NET
or
C#.NET/ADO.NET

Are are ok, if you would like to demonstrate your replay. ( I want the answer!).

Thanks again.|||YES!!

The problem was from my ADO.NET part.

Thanks for your help gays.