BulkXMLLoad in a multithreaded server

Hi
Is it possible/safe to use BulkXMLLoad in a multithreaded server? It may
mean that SQLXMLBulkLoad may be called simultaneously from multiple threads.
Am I ok do this or should I use some sort of Critical Section to synchronize
the bulk xml load?
Many thanks
JonnySQLXMLBulkload is apartment threaded so you can use in multi-thread
aplications safely but not the same bulkload object in different threads.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonny Wilkinson" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d1c73u$j9g$1$8302bc10@.news.demon.co.uk...
> Hi
> Is it possible/safe to use BulkXMLLoad in a multithreaded server? It may
> mean that SQLXMLBulkLoad may be called simultaneously from multiple
threads.
> Am I ok do this or should I use some sort of Critical Section to
synchronize
> the bulk xml load?
> Many thanks
> Jonny
>|||Thanks Bertan
Jonny
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:%23zeEgDBLFHA.688@.TK2MSFTNGP10.phx.gbl...
> SQLXMLBulkload is apartment threaded so you can use in multi-thread
> aplications safely but not the same bulkload object in different threads.
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Jonny Wilkinson" <jonny@.nospam.jonnywilk.co.uk> wrote in message
> news:d1c73u$j9g$1$8302bc10@.news.demon.co.uk...
> threads.
> synchronize
>|||Actually, we recently found out that there is possible chance of name
collisions on temp tables that are created for identity value propagation, a
feature which is enabled by setting keep-identity property to False.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonny Wilkinson" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d1m8po$6eb$1$8302bc10@.news.demon.co.uk...
> Thanks Bertan
> Jonny
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:%23zeEgDBLFHA.688@.TK2MSFTNGP10.phx.gbl...
threads.
>|||arghh don't tell me that! lol
I have to has the keep-identity property as false otherwise my identity
column wouldn't create a new ID?
What's the best thing for me to do in this situation? Not use Bulkload in a
multithread app?
Cheers
Jonny
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:udFtrXyLFHA.568@.TK2MSFTNGP09.phx.gbl...
> Actually, we recently found out that there is possible chance of name
> collisions on temp tables that are created for identity value propagation,
> a
> feature which is enabled by setting keep-identity property to False.
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Jonny Wilkinson" <jonny@.nospam.jonnywilk.co.uk> wrote in message
> news:d1m8po$6eb$1$8302bc10@.news.demon.co.uk...
> threads.
>|||In this case, you should make it single-threaded. We're working on a fix
for this for SqlXml 4.0 (which will be available in Sql Server 2005).
Irwin
"Jonny" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d210i6$rll$1$8300dec7@.news.demon.co.uk...
> arghh don't tell me that! lol
> I have to has the keep-identity property as false otherwise my identity
> column wouldn't create a new ID?
> What's the best thing for me to do in this situation? Not use Bulkload in
> a multithread app?
> Cheers
> Jonny
>
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:udFtrXyLFHA.568@.TK2MSFTNGP09.phx.gbl...
>