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

INSRET/UPDATE trigger

Hi,

I user RAISERROR(@.Error, 16, 1) in the INSRET/UPDATE trigger, does this rollback record in the table? It seems it does and I am wondering if there is any workaround.

Thanks,

It depends on the severity of the error. You should do RAISERROR with a lesser severity and then do ROLLBACK explicitly. See Books Online topic on RAISERROR and how to use it in triggers in SQL Server 2005. There are several samples that shows how to use RAISERROR.