Thanks Darren. I am going to try this stuff.

Darren, May you please point me to some link how to use this XML insert mechanism. Or some sample code.

Thanks for your time.

Any idea or link to the infromation of using ADO for bulk insert/bcp.

I know There is an IRowsetFastLoad interface; but does anybody have sample for using it with VB/ADO....

I tested the Staging table (a copy of the original table schmema with no index, no contraints) doesn't help because perfomance is still same.

Any other ideas please!!

It is C++/VB application which collects data from various apps and the format of data doesn't make more sense because it is all collected data a row at a time....

It is a kind of data collection application so it doesn't have all 100,000 rows at a time; but Idea is we need fast insert mechanism. So I think bcp...

Just make sure other procedures (5 procs) should not be returning more than the expected number of clumns and they should be returning only one recordset otherwise behavor is unexpected...

Thanks. It works.

But for some transaction logs it gives me following error. "Cannot shrink log file 2 (L490SU001) because total number of logical log files cannot be fewer than...