Install MSDE 2000 on WinXP home failed

Dear all,
During install MSDE 2000 on WINXP HOME edition, not complete and then
rollback, could anyone can help?
Thanks.
Below attached error.log content.
2004-12-23 16:47:36.38 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
2004-12-23 16:47:36.38 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-12-23 16:47:36.38 server All rights reserved.
2004-12-23 16:47:36.38 server Server Process ID is 3808.
2004-12-23 16:47:36.38 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$TL_MSDE\LOG\ERRORLOG'.
2004-12-23 16:47:36.42 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-12-23 16:47:36.44 server SQL Server configured for thread mode
processing.
2004-12-23 16:47:36.44 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2004-12-23 16:47:36.45 spid3 Warning ******************
2004-12-23 16:47:36.45 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2004-12-23 16:47:36.46 spid3 Starting up database 'master'.
2004-12-23 16:47:36.61 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-12-23 16:47:36.64 spid5 Starting up database 'model'.
2004-12-23 16:47:36.91 spid3 Server name is 'DLINK\TL_MSDE'.
2004-12-23 16:47:36.91 spid3 Skipping startup of clean database id 5
2004-12-23 16:47:36.91 spid3 Skipping startup of clean database id 6
2004-12-23 16:47:36.91 spid3 Starting up database 'msdb'.
2004-12-23 16:47:36.92 server SQL server listening on 169.254.159.200:
1104.
2004-12-23 16:47:36.92 server SQL server listening on 219.76.249.145: 1104.
2004-12-23 16:47:36.92 server SQL server listening on 127.0.0.1: 1104.
2004-12-23 16:47:36.92 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-12-23 16:47:36.92 server SQL Server is ready for client connections
2004-12-23 16:47:37.11 spid5 Clearing tempdb database.
2004-12-23 16:47:38.16 spid5 Starting up database 'tempdb'.
2004-12-23 16:47:38.23 spid3 Warning ******************
2004-12-23 16:47:38.23 spid3 Attempting to change default collation to
Chinese_Taiwan_Stroke_CI_AS.
2004-12-23 16:47:41.78 spid3 Clustered index restored for
master.sysdatabases.
2004-12-23 16:47:41.93 spid3 Non-clustered index restored for
master.sysobjects.
2004-12-23 16:47:42.09 spid3 Non-clustered index restored for
master.sysobjects.
2004-12-23 16:47:42.13 spid3 index restored for master.syscolumns.
2004-12-23 16:47:42.23 spid3 index restored for master.systypes.
2004-12-23 16:47:42.25 spid3 index restored for master.sysusers.
2004-12-23 16:47:43.50 spid3 index restored for master.sysproperties.
2004-12-23 16:47:43.57 spid3 index restored for
master.sysfulltextcatalogs.
2004-12-23 16:47:43.76 spid3 index restored for master.sysxlogins.
2004-12-23 16:47:43.79 spid3 index restored for master.sysdevices.
2004-12-23 16:47:44.19 spid3 index restored for master.sysservers.
2004-12-23 16:47:45.66 spid3 index restored for master.syslanguages.
2004-12-23 16:47:45.71 spid3 index restored for master.syscharsets.
2004-12-23 16:47:45.75 spid3 index restored for master.sysfilegroups.
2004-12-23 16:47:46.05 spid3 index restored for master.spt_values.
2004-12-23 16:47:46.06 spid3 index restored for
master.MSreplication_options.
2004-12-23 16:47:46.08 spid3 index restored for
master.spt_datatype_info_ext.
2004-12-23 16:47:46.09 spid3 index restored for master.spt_datatype_info.
2004-12-23 16:47:46.15 spid3 Non-clustered index restored for
tempdb.sysobjects.
2004-12-23 16:47:46.15 spid3 Non-clustered index restored for
tempdb.sysobjects.
2004-12-23 16:47:46.15 spid3 index restored for tempdb.syscolumns.
2004-12-23 16:47:46.15 spid3 index restored for tempdb.systypes.
2004-12-23 16:47:46.16 spid3 index restored for tempdb.sysusers.
2004-12-23 16:47:46.16 spid3 index restored for tempdb.sysproperties.
2004-12-23 16:47:46.16 spid3 index restored for
tempdb.sysfulltextcatalogs.
2004-12-23 16:47:46.18 spid3 index restored for tempdb.sysfilegroups.
2004-12-23 16:47:46.35 spid3 Non-clustered index restored for
model.sysobjects.
2004-12-23 16:47:46.35 spid3 Non-clustered index restored for
model.sysobjects.
2004-12-23 16:47:46.45 spid3 index restored for model.syscolumns.
2004-12-23 16:47:46.46 spid3 index restored for model.systypes.
2004-12-23 16:47:46.52 spid3 index restored for model.sysusers.
2004-12-23 16:47:46.52 spid3 index restored for model.sysproperties.
2004-12-23 16:47:46.52 spid3 index restored for
model.sysfulltextcatalogs.
2004-12-23 16:47:46.54 spid3 index restored for model.sysfilegroups.
2004-12-23 16:47:46.76 spid3 Non-clustered index restored for
msdb.sysobjects.
2004-12-23 16:47:46.77 spid3 Non-clustered index restored for
msdb.sysobjects.
2004-12-23 16:47:46.79 spid3 index restored for msdb.syscolumns.
2004-12-23 16:47:46.79 spid3 index restored for msdb.systypes.
2004-12-23 16:47:46.80 spid3 index restored for msdb.sysusers.
2004-12-23 16:47:46.80 spid3 index restored for msdb.sysproperties.
2004-12-23 16:47:46.80 spid3 index restored for msdb.sysfulltextcatalogs.
2004-12-23 16:47:46.80 spid3 index restored for msdb.sysfilegroups.
2004-12-23 16:47:46.83 spid3 index restored for msdb.sysjobschedules.
2004-12-23 16:47:46.84 spid3 index restored for msdb.syscategories.
2004-12-23 16:47:46.84 spid3 index restored for msdb.systargetservers.
2004-12-23 16:47:46.84 spid3 index restored for
msdb.systargetservergroups.
2004-12-23 16:47:47.96 spid3 index restored for msdb.sysalerts.
2004-12-23 16:47:47.96 spid3 index restored for msdb.sysoperators.
2004-12-23 16:47:47.97 spid3 index restored for
msdb.syscachedcredentials.
2004-12-23 16:47:47.97 spid3 index restored for msdb.logmarkhistory.
2004-12-23 16:47:48.00 spid3 index restored for msdb.sysdtscategories.
2004-12-23 16:47:48.00 spid3 index restored for
msdb.sysdbmaintplan_databases.
2004-12-23 16:47:48.01 spid3 index restored for msdb.mswebtasks.
2004-12-23 16:47:48.01 spid3 index restored for msdb.sysdownloadlist.
2004-12-23 16:47:48.01 spid3 index restored for msdb.sysjobs.
2004-12-23 16:47:48.02 spid3 index restored for msdb.sysjobsteps.
2004-12-23 16:47:48.57 spid3 Default collation successfully changed.
2004-12-23 16:47:49.07 spid3 Recovery complete.
2004-12-23 16:47:49.07 spid3 SQL global counter collection task is
created.
2004-12-23 16:47:49.10 spid3 Warning: override, autoexec procedures
skipped.
2004-12-23 16:47:56.63 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
Hi
Excuse my English
I've got this problème.
Carefull if several install/uninstall...
Carefull if several servers connected with two instances with same name...
See http://support.microsoft.com/default...en-us;320873#3
for a clean uninstallation.
JCH
kpler a écrit :
> Dear all,
> During install MSDE 2000 on WINXP HOME edition, not complete and then
> rollback, could anyone can help?
> Thanks.
> Below attached error.log content.
>
> 2004-12-23 16:47:36.38 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2004-12-23 16:47:36.38 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2004-12-23 16:47:36.38 server All rights reserved.
> 2004-12-23 16:47:36.38 server Server Process ID is 3808.
> 2004-12-23 16:47:36.38 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$TL_MSDE\LOG\ERRORLOG'.
> 2004-12-23 16:47:36.42 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2004-12-23 16:47:36.44 server SQL Server configured for thread mode
> processing.
> 2004-12-23 16:47:36.44 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2004-12-23 16:47:36.45 spid3 Warning ******************
> 2004-12-23 16:47:36.45 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2004-12-23 16:47:36.46 spid3 Starting up database 'master'.
> 2004-12-23 16:47:36.61 server Using 'SSNETLIB.DLL' version '8.0.766'.
> 2004-12-23 16:47:36.64 spid5 Starting up database 'model'.
> 2004-12-23 16:47:36.91 spid3 Server name is 'DLINK\TL_MSDE'.
> 2004-12-23 16:47:36.91 spid3 Skipping startup of clean database id 5
> 2004-12-23 16:47:36.91 spid3 Skipping startup of clean database id 6
> 2004-12-23 16:47:36.91 spid3 Starting up database 'msdb'.
> 2004-12-23 16:47:36.92 server SQL server listening on 169.254.159.200:
> 1104.
> 2004-12-23 16:47:36.92 server SQL server listening on 219.76.249.145: 1104.
> 2004-12-23 16:47:36.92 server SQL server listening on 127.0.0.1: 1104.
> 2004-12-23 16:47:36.92 server SQL server listening on TCP, Shared Memory,
> Named Pipes.
> 2004-12-23 16:47:36.92 server SQL Server is ready for client connections
> 2004-12-23 16:47:37.11 spid5 Clearing tempdb database.
> 2004-12-23 16:47:38.16 spid5 Starting up database 'tempdb'.
> 2004-12-23 16:47:38.23 spid3 Warning ******************
> 2004-12-23 16:47:38.23 spid3 Attempting to change default collation to
> Chinese_Taiwan_Stroke_CI_AS.
> 2004-12-23 16:47:41.78 spid3 Clustered index restored for
> master.sysdatabases.
> 2004-12-23 16:47:41.93 spid3 Non-clustered index restored for
> master.sysobjects.
> 2004-12-23 16:47:42.09 spid3 Non-clustered index restored for
> master.sysobjects.
> 2004-12-23 16:47:42.13 spid3 index restored for master.syscolumns.
> 2004-12-23 16:47:42.23 spid3 index restored for master.systypes.
> 2004-12-23 16:47:42.25 spid3 index restored for master.sysusers.
> 2004-12-23 16:47:43.50 spid3 index restored for master.sysproperties.
> 2004-12-23 16:47:43.57 spid3 index restored for
> master.sysfulltextcatalogs.
> 2004-12-23 16:47:43.76 spid3 index restored for master.sysxlogins.
> 2004-12-23 16:47:43.79 spid3 index restored for master.sysdevices.
> 2004-12-23 16:47:44.19 spid3 index restored for master.sysservers.
> 2004-12-23 16:47:45.66 spid3 index restored for master.syslanguages.
> 2004-12-23 16:47:45.71 spid3 index restored for master.syscharsets.
> 2004-12-23 16:47:45.75 spid3 index restored for master.sysfilegroups.
> 2004-12-23 16:47:46.05 spid3 index restored for master.spt_values.
> 2004-12-23 16:47:46.06 spid3 index restored for
> master.MSreplication_options.
> 2004-12-23 16:47:46.08 spid3 index restored for
> master.spt_datatype_info_ext.
> 2004-12-23 16:47:46.09 spid3 index restored for master.spt_datatype_info.
> 2004-12-23 16:47:46.15 spid3 Non-clustered index restored for
> tempdb.sysobjects.
> 2004-12-23 16:47:46.15 spid3 Non-clustered index restored for
> tempdb.sysobjects.
> 2004-12-23 16:47:46.15 spid3 index restored for tempdb.syscolumns.
> 2004-12-23 16:47:46.15 spid3 index restored for tempdb.systypes.
> 2004-12-23 16:47:46.16 spid3 index restored for tempdb.sysusers.
> 2004-12-23 16:47:46.16 spid3 index restored for tempdb.sysproperties.
> 2004-12-23 16:47:46.16 spid3 index restored for
> tempdb.sysfulltextcatalogs.
> 2004-12-23 16:47:46.18 spid3 index restored for tempdb.sysfilegroups.
> 2004-12-23 16:47:46.35 spid3 Non-clustered index restored for
> model.sysobjects.
> 2004-12-23 16:47:46.35 spid3 Non-clustered index restored for
> model.sysobjects.
> 2004-12-23 16:47:46.45 spid3 index restored for model.syscolumns.
> 2004-12-23 16:47:46.46 spid3 index restored for model.systypes.
> 2004-12-23 16:47:46.52 spid3 index restored for model.sysusers.
> 2004-12-23 16:47:46.52 spid3 index restored for model.sysproperties.
> 2004-12-23 16:47:46.52 spid3 index restored for
> model.sysfulltextcatalogs.
> 2004-12-23 16:47:46.54 spid3 index restored for model.sysfilegroups.
> 2004-12-23 16:47:46.76 spid3 Non-clustered index restored for
> msdb.sysobjects.
> 2004-12-23 16:47:46.77 spid3 Non-clustered index restored for
> msdb.sysobjects.
> 2004-12-23 16:47:46.79 spid3 index restored for msdb.syscolumns.
> 2004-12-23 16:47:46.79 spid3 index restored for msdb.systypes.
> 2004-12-23 16:47:46.80 spid3 index restored for msdb.sysusers.
> 2004-12-23 16:47:46.80 spid3 index restored for msdb.sysproperties.
> 2004-12-23 16:47:46.80 spid3 index restored for msdb.sysfulltextcatalogs.
> 2004-12-23 16:47:46.80 spid3 index restored for msdb.sysfilegroups.
> 2004-12-23 16:47:46.83 spid3 index restored for msdb.sysjobschedules.
> 2004-12-23 16:47:46.84 spid3 index restored for msdb.syscategories.
> 2004-12-23 16:47:46.84 spid3 index restored for msdb.systargetservers.
> 2004-12-23 16:47:46.84 spid3 index restored for
> msdb.systargetservergroups.
> 2004-12-23 16:47:47.96 spid3 index restored for msdb.sysalerts.
> 2004-12-23 16:47:47.96 spid3 index restored for msdb.sysoperators.
> 2004-12-23 16:47:47.97 spid3 index restored for
> msdb.syscachedcredentials.
> 2004-12-23 16:47:47.97 spid3 index restored for msdb.logmarkhistory.
> 2004-12-23 16:47:48.00 spid3 index restored for msdb.sysdtscategories.
> 2004-12-23 16:47:48.00 spid3 index restored for
> msdb.sysdbmaintplan_databases.
> 2004-12-23 16:47:48.01 spid3 index restored for msdb.mswebtasks.
> 2004-12-23 16:47:48.01 spid3 index restored for msdb.sysdownloadlist.
> 2004-12-23 16:47:48.01 spid3 index restored for msdb.sysjobs.
> 2004-12-23 16:47:48.02 spid3 index restored for msdb.sysjobsteps.
> 2004-12-23 16:47:48.57 spid3 Default collation successfully changed.
> 2004-12-23 16:47:49.07 spid3 Recovery complete.
> 2004-12-23 16:47:49.07 spid3 SQL global counter collection task is
> created.
> 2004-12-23 16:47:49.10 spid3 Warning: override, autoexec procedures
> skipped.
> 2004-12-23 16:47:56.63 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.

Inserting via a view

Hello All, I have an strange issue regarding inserts via a view. Below are
the environemnts and the code. Both environments are identical however,
service packs a different.
Environment 1: This environmnet the insert works
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Windows 2k sp4
Environment 2: This envirnoment the insert fails
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Here is the insert statment;
INSERT INTO vMoxyStandardRestriction ( R.RestrictionID,
R.RestrictionType,
R.SecAssocType,
R.RestrictionName,
R.CanOverride,
D.TranCodeBits,
D.MinCompRestPercent,
D.MaxCompRestPercent,
D.IsAggregate,
D.RoundOption,
D.RoundFactor,
D.MinShares,
D.MinValue,
D.CompType)
VALUES (11, 1, 16, 'Unreconciled', 1, 12, 0.000000000000000e+000,
0.000000000000000e+000, 0, 0, 0.000000000000000e+000, 0.000000000000000e+000
,
0.000000000000000e+000, 0)
Here is the code to the view
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
ALTER VIEW vMoxyStandardRestriction AS
SELECT R.RestrictionID, R.RestrictionType, R.SecAssocType,
R.RestrictionName, R.CanOverride,
D.TranCodeBits, D.MinCompRestPercent, D.MaxCompRestPercent, D.IsAggregate,
D.RoundOption, D.RoundFactor, D.MinShares, D.MinValue, D.CompType
FROM MoxyRestriction R, MoxyRestDef D
WHERE R.RestrictionID = D.RestrictionID
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOThis is the error message in the environment which does not work.
Server: Msg 4405, Level 16, State 2, Line 1
View or function 'vMoxyStandardRestriction' is not updatable because the
modification affects multiple base tables.
"FredG" wrote:

> Hello All, I have an strange issue regarding inserts via a view. Below are
> the environemnts and the code. Both environments are identical however,
> service packs a different.
> Environment 1: This environmnet the insert works
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Windows 2k sp4
> Environment 2: This envirnoment the insert fails
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> Here is the insert statment;
> INSERT INTO vMoxyStandardRestriction ( R.RestrictionID,
> R.RestrictionType,
> R.SecAssocType,
> R.RestrictionName,
> R.CanOverride,
> D.TranCodeBits,
> D.MinCompRestPercent,
> D.MaxCompRestPercent,
> D.IsAggregate,
> D.RoundOption,
> D.RoundFactor,
> D.MinShares,
> D.MinValue,
> D.CompType)
> VALUES (11, 1, 16, 'Unreconciled', 1, 12, 0.000000000000000e+000,
> 0.000000000000000e+000, 0, 0, 0.000000000000000e+000, 0.000000000000000e+0
00,
> 0.000000000000000e+000, 0)
> Here is the code to the view
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS OFF
> GO
> ALTER VIEW vMoxyStandardRestriction AS
> SELECT R.RestrictionID, R.RestrictionType, R.SecAssocType,
> R.RestrictionName, R.CanOverride,
> D.TranCodeBits, D.MinCompRestPercent, D.MaxCompRestPercent, D.IsAggreg
ate,
> D.RoundOption, D.RoundFactor, D.MinShares, D.MinValue, D.CompType
> FROM MoxyRestriction R, MoxyRestDef D
> WHERE R.RestrictionID = D.RestrictionID
> GO
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS ON
> GO|||Hi Fred
Your error messages seems pretty explicit. You cannot insert into a view
that is based on a join. If you could, your single insert would have to put
rows into both the underlying tables, and according to BOL:
[If you insert into a view] .. the modifications made by the INSERT
statement cannot affect more than one of the base tables referenced in the
FROM clause of the view. For example, an INSERT into a multitable view must
use a column_list that references only columns from one base table.
If you are not getting the message for one of your servers, that is the
weirdness. Perhaps you have an INSTEAD OF TRIGGER on the view on that
server.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:B1BE7DA5-30D1-41F7-8C63-E213DA147DFA@.microsoft.com...
> Hello All, I have an strange issue regarding inserts via a view. Below are
> the environemnts and the code. Both environments are identical however,
> service packs a different.
> Environment 1: This environmnet the insert works
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Windows 2k sp4
> Environment 2: This envirnoment the insert fails
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> Here is the insert statment;
> INSERT INTO vMoxyStandardRestriction ( R.RestrictionID,
> R.RestrictionType,
> R.SecAssocType,
> R.RestrictionName,
> R.CanOverride,
> D.TranCodeBits,
> D.MinCompRestPercent,
> D.MaxCompRestPercent,
> D.IsAggregate,
> D.RoundOption,
> D.RoundFactor,
> D.MinShares,
> D.MinValue,
> D.CompType)
> VALUES (11, 1, 16, 'Unreconciled', 1, 12, 0.000000000000000e+000,
> 0.000000000000000e+000, 0, 0, 0.000000000000000e+000,
> 0.000000000000000e+000,
> 0.000000000000000e+000, 0)
> Here is the code to the view
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS OFF
> GO
> ALTER VIEW vMoxyStandardRestriction AS
> SELECT R.RestrictionID, R.RestrictionType, R.SecAssocType,
> R.RestrictionName, R.CanOverride,
> D.TranCodeBits, D.MinCompRestPercent, D.MaxCompRestPercent,
> D.IsAggregate,
> D.RoundOption, D.RoundFactor, D.MinShares, D.MinValue, D.CompType
> FROM MoxyRestriction R, MoxyRestDef D
> WHERE R.RestrictionID = D.RestrictionID
> GO
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS ON
> GO
>

Inserting SOAP formatted message data into a SQL table -- OPEN

I have displaying my SOAP message below. Could you show me what T-SQL
statement using OPENXML or otherwise I can use to import the data in this
SOAP message into various columns in a SQL table.
My SQL table has the following columns:
LogEntry varchar(255)
Message varchar(255)
Title varchar(255)
Category varchar(50)
Priority int
EventID int
Severity varchar(255)
MachineName varchar(50)
TimeStampVal datetime
ErrorMessages varchar(255)
ExtendedProperties varchar(255)
AppDomainName varchar(50)
ProcessID int
ProcessName varchar(255)
ThreadName varchar(50)
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<a1:LogEntry id="ref-1"
xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Enter
priseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Vers
ion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
<message id="ref-3">Msg successfully populated</message>
<title id="ref-4">Title1</title>
<category id="ref-5">Cat1</category>
<priority>100</priority>
<eventId>16</eventId>
<severity>Information</severity>
<machineName id="ref-6">MACH1</machineName>
<timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
<errorMessages xsi:null="1"/>
<extendedProperties xsi:null="1"/>
<appDomainName id="ref-7">B1.exe</appDomainName>
<processId id="ref-8">3932</processId>
<processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
<threadName xsi:null="1"/>
<win32ThreadId id="ref-10">244</win32ThreadId>
</a1:LogEntry>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
--
gg
"Graeme Malcolm" wrote:

> There are a couple of approaches. You could pass the entire SOAP XML doc t
o
> a stored procedure and use OPENXML to shred it into tables, or you could
> create an annotated XSD schema that maps the elements/attributes in your
> SOAP message to the tables/column in the database and use the SQLXML Bulk
> Load component.
> Neither of these approaches requires a SQLXML IIS site.
> Cheers,
> Graeme
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
> "gudia" <gudia@.discussions.microsoft.com> wrote in message
> news:B85E4E76-A4FB-49A7-881A-A1795CE80728@.microsoft.com...
> Is configuring IIS to be used in conjunction with SQLXML a requirement for
> the question I am asking?
> My eventual goal is to insert the data present in the SOAP message into a
> SQL table.
> Please let me know how I can achieve this goal.
> Thanks
>
>Here's one way (I wasn't sure what you want in the LogEntry column, since
that's an XML element that contains all the others - so I used the id
attribute). This example uses a temporary table with the columns you
specified and I've hardcoded the SOAP message as a variable - in reality
you'd pass it to a stored procedure as a parameter. I suggest you take some
time to examine the documentation on OPENXML in Books Online to tweak this
to do exactly what you want it to.
USE Tempdb
CREATE TABLE #TestTable
(
LogEntry varchar(255),
Message varchar(255),
Title varchar(255),
Category varchar(50),
Priority int,
EventID int,
Severity varchar(255),
MachineName varchar(50),
TimeStampVal datetime,
ErrorMessages varchar(255),
ExtendedProperties varchar(255),
AppDomainName varchar(50),
ProcessID int,
ProcessName varchar(255),
ThreadName varchar(50)
)
DECLARE @.doc nvarchar(2000)
SET @.doc = '<SOAP-ENV:Envelope
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<a1:LogEntry id="ref-1"
xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Enter
priseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Vers
ion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
<message id="ref-3">Msg successfully populated</message>
<title id="ref-4">Title1</title>
<category id="ref-5">Cat1</category>
<priority>100</priority>
<eventId>16</eventId>
<severity>Information</severity>
<machineName id="ref-6">MACH1</machineName>
<timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
<errorMessages xsi:null="1"/>
<extendedProperties xsi:null="1"/>
<appDomainName id="ref-7">B1.exe</appDomainName>
<processId id="ref-8">3932</processId>
<processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
<threadName xsi:null="1"/>
<win32ThreadId id="ref-10">244</win32ThreadId>
</a1:LogEntry>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
'
DECLARE @.hDoc int
EXEC sp_xml_preparedocument @.hDoc OUTPUT, @.doc, '<ns
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Enter
priseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Vers
ion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull"/>'
INSERT #TestTable
SELECT * FROM OPENXML(@.hDoc, 'SOAP-ENV:Envelope/SOAP-ENV:Body/a1:LogEntry',
2)
WITH
(
LogEntry varchar(255) '@.id',
message varchar(255),
title varchar(255),
category varchar(50),
priority int,
eventId int,
severity varchar(255),
machineName varchar(50),
timeStampVal datetime,
errorMessages varchar(255),
extendedProperties varchar(255),
appDomainName varchar(50),
processId int,
processName varchar(255),
threadName varchar(50)
)
SELECT * FROM #TestTable
DROP TABLE #TestTable
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com
"gudia" <gudia@.discussions.microsoft.com> wrote in message
news:B85C3731-29C4-4503-9A4A-237B7F83A5B7@.microsoft.com...
I have displaying my SOAP message below. Could you show me what T-SQL
statement using OPENXML or otherwise I can use to import the data in this
SOAP message into various columns in a SQL table.
My SQL table has the following columns:
LogEntry varchar(255)
Message varchar(255)
Title varchar(255)
Category varchar(50)
Priority int
EventID int
Severity varchar(255)
MachineName varchar(50)
TimeStampVal datetime
ErrorMessages varchar(255)
ExtendedProperties varchar(255)
AppDomainName varchar(50)
ProcessID int
ProcessName varchar(255)
ThreadName varchar(50)
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<a1:LogEntry id="ref-1"
xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Enter
priseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Vers
ion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
<message id="ref-3">Msg successfully populated</message>
<title id="ref-4">Title1</title>
<category id="ref-5">Cat1</category>
<priority>100</priority>
<eventId>16</eventId>
<severity>Information</severity>
<machineName id="ref-6">MACH1</machineName>
<timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
<errorMessages xsi:null="1"/>
<extendedProperties xsi:null="1"/>
<appDomainName id="ref-7">B1.exe</appDomainName>
<processId id="ref-8">3932</processId>
<processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
<threadName xsi:null="1"/>
<win32ThreadId id="ref-10">244</win32ThreadId>
</a1:LogEntry>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
--
gg
"Graeme Malcolm" wrote:

> There are a couple of approaches. You could pass the entire SOAP XML doc
> to
> a stored procedure and use OPENXML to shred it into tables, or you could
> create an annotated XSD schema that maps the elements/attributes in your
> SOAP message to the tables/column in the database and use the SQLXML Bulk
> Load component.
> Neither of these approaches requires a SQLXML IIS site.
> Cheers,
> Graeme
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
> "gudia" <gudia@.discussions.microsoft.com> wrote in message
> news:B85E4E76-A4FB-49A7-881A-A1795CE80728@.microsoft.com...
> Is configuring IIS to be used in conjunction with SQLXML a requirement for
> the question I am asking?
> My eventual goal is to insert the data present in the SOAP message into a
> SQL table.
> Please let me know how I can achieve this goal.
> Thanks
>
>|||Thanks so much Graeme. That worked.
Appreciate your help.
"Graeme Malcolm" wrote:

> Here's one way (I wasn't sure what you want in the LogEntry column, since
> that's an XML element that contains all the others - so I used the id
> attribute). This example uses a temporary table with the columns you
> specified and I've hardcoded the SOAP message as a variable - in reality
> you'd pass it to a stored procedure as a parameter. I suggest you take so
me
> time to examine the documentation on OPENXML in Books Online to tweak this
> to do exactly what you want it to.
> USE Tempdb
> CREATE TABLE #TestTable
> (
> LogEntry varchar(255),
> Message varchar(255),
> Title varchar(255),
> Category varchar(50),
> Priority int,
> EventID int,
> Severity varchar(255),
> MachineName varchar(50),
> TimeStampVal datetime,
> ErrorMessages varchar(255),
> ExtendedProperties varchar(255),
> AppDomainName varchar(50),
> ProcessID int,
> ProcessName varchar(255),
> ThreadName varchar(50)
> )
> DECLARE @.doc nvarchar(2000)
> SET @.doc = '<SOAP-ENV:Envelope
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
> xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
> SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
> <SOAP-ENV:Body>
> <a1:LogEntry id="ref-1"
> xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Ent
erpriseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Ve
rsion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
> <message id="ref-3">Msg successfully populated</message>
> <title id="ref-4">Title1</title>
> <category id="ref-5">Cat1</category>
> <priority>100</priority>
> <eventId>16</eventId>
> <severity>Information</severity>
> <machineName id="ref-6">MACH1</machineName>
> <timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
> <errorMessages xsi:null="1"/>
> <extendedProperties xsi:null="1"/>
> <appDomainName id="ref-7">B1.exe</appDomainName>
> <processId id="ref-8">3932</processId>
> <processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
> <threadName xsi:null="1"/>
> <win32ThreadId id="ref-10">244</win32ThreadId>
> </a1:LogEntry>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
> '
> DECLARE @.hDoc int
> EXEC sp_xml_preparedocument @.hDoc OUTPUT, @.doc, '<ns
> xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Ent
erpriseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Ve
rsion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull"/>'
> INSERT #TestTable
> SELECT * FROM OPENXML(@.hDoc, 'SOAP-ENV:Envelope/SOAP-ENV:Body/a1:LogEntry'
,
> 2)
> WITH
> (
> LogEntry varchar(255) '@.id',
> message varchar(255),
> title varchar(255),
> category varchar(50),
> priority int,
> eventId int,
> severity varchar(255),
> machineName varchar(50),
> timeStampVal datetime,
> errorMessages varchar(255),
> extendedProperties varchar(255),
> appDomainName varchar(50),
> processId int,
> processName varchar(255),
> threadName varchar(50)
> )
> SELECT * FROM #TestTable
> DROP TABLE #TestTable
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
> "gudia" <gudia@.discussions.microsoft.com> wrote in message
> news:B85C3731-29C4-4503-9A4A-237B7F83A5B7@.microsoft.com...
> I have displaying my SOAP message below. Could you show me what T-SQL
> statement using OPENXML or otherwise I can use to import the data in this
> SOAP message into various columns in a SQL table.
> My SQL table has the following columns:
> LogEntry varchar(255)
> Message varchar(255)
> Title varchar(255)
> Category varchar(50)
> Priority int
> EventID int
> Severity varchar(255)
> MachineName varchar(50)
> TimeStampVal datetime
> ErrorMessages varchar(255)
> ExtendedProperties varchar(255)
> AppDomainName varchar(50)
> ProcessID int
> ProcessName varchar(255)
> ThreadName varchar(50)
> <SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
> xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
> SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
> <SOAP-ENV:Body>
> <a1:LogEntry id="ref-1"
> xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Ent
erpriseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Ve
rsion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
> <message id="ref-3">Msg successfully populated</message>
> <title id="ref-4">Title1</title>
> <category id="ref-5">Cat1</category>
> <priority>100</priority>
> <eventId>16</eventId>
> <severity>Information</severity>
> <machineName id="ref-6">MACH1</machineName>
> <timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
> <errorMessages xsi:null="1"/>
> <extendedProperties xsi:null="1"/>
> <appDomainName id="ref-7">B1.exe</appDomainName>
> <processId id="ref-8">3932</processId>
> <processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
> <threadName xsi:null="1"/>
> <win32ThreadId id="ref-10">244</win32ThreadId>
> </a1:LogEntry>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
> --
> gg
>
> "Graeme Malcolm" wrote:
>
>
>