Or if you can't rewrite it, launch a JOB that will do the web service stuff for you asynchronously.

Though doing a UNION and not a UNION ALL probably will resort your data. Possibily in another order.

And if you want all the rows and not a fixed number there...

I guess the problem might be with the characters that make up the table name. BCP maybe interprets part of it as a parameter. Try to do a

'bcp "SELECT...

Depends on what you mean by fastest! For you to develop or for the data to be transferred?

Fastest to transfer is BULKING the data out to a file on the...

Thanks  Always glad if I can help!

Maybe also your second problem can be solved. Is this with loading data into SQL Server or still...

I understood that, that's why I stated that the setting doesn't entirely work

One of the reasons I have for stating this comes from microsoft:...

Eric Mueller has some valid points there and the only thing I would add would be that it might be time to check...

Did you read this: http://support.microsoft.com/default.aspx?scid=kb;en-us;281517?

By default, the value for this key is 8. Hence, the provider scans the first 8 rows of the source data to determine the...

You have to have a clustered index on your table to be able to reclaim space from deleted records. Put one and see that the reserved space for that table...

Well, it wouldn't be that easy. Vítor Nuno Viana Ferreira expressedly stated that the files were malformed. I.e not possible to Bulk Insert.

To me it seems unlikely that it could be a memory problem. If your SQL Server is configured using dynamic memory, it will try to grab all the (available) physical...

Well, are the two servers containing the same data and the same data structure? Could it not just be a result of poor database design?

//Hans

Hi,

SHRINK is a very resource intensive task and should (if ever) be done during off peak hours.

I would not recommend auto shrink your databases. In fact if you need...

I belive you! As you see I havn't sent in any questions as of yet Well, if you form a review board, I...

Or bulk insert to a staging table and from there do a TSQL INSERT INTO or whatever.