Posted by Erland Sommarskog on 05/13/07 16:25

M6C (roca.david@gmail.com) writes:
> Thank you, but i don't find any information about an option to fire
> triggers.
> I will continue to looking for more informations about XML bulk load
> options.

I looked in MSDN Library, and according to the topic "SQL Server XML Bulk
Load Object Model", there is indeed a FireTriggers property. This is for
SQLXML 4.0. I don't have much experience of SQLXML, but FireTriggers is not
listed under "What's New in SQL 4.0", so I guess it was there in 3.0 as
well.

> An other question, to circumvent my problem;
> Can i make an operation in the Xsd file ?
> I want to add an constant character to an column.
> Can i modify the Xsd file to look like the following:

That question definitely goes over my head! :-)

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: One trigger, many tables - how to automate?
• Prev in forum: Re: One trigger, many tables - how to automate?
• Thread view: Re: How Import XML file in a table with trigger.

[Reply to this message]