CE only supports merge replication (as far as I know) and, from MSDE, it only supports Merge in both directions (transactional subscriber not publisher, and snapshot are also available).  So...

That's an impressive amount of code!

I can only assume that it works! 

Surely though it could...

Set ANSI_PADDING is something that applies to the current block of SQL, it doesn't change it for the database.  The databasePropertyEx function tells you the "default" value that connections will...

Are you deleting whilst reading new data (eg users using the app, running selects) - I assume you plan to try to do the deletion during a "quiet" time in...

Readtext is usually for use within TSQL stuff executing on the server. You can "select" text / image columns and it is up to your client side library (eg...

Yup, covering index is usually the easiest way to avoid bookmark lookups - just make sure your inserts & updates are not affected adversely.

Yeah Remi is right. The other one is very procedural - not very SQL friendly.

I assume there is no "line number" or other incrementing number in your text file - add an identity field to the table and then order your cursor based on...

I had awful trouble once trying to just understand the myriad of things to do with Oracle - client had an app with it that we had to work with...

There must be 50 posts on this site about the topic - it is true, and makes good sense when you think that SQL Server has to make some assumption...

As far as I know this is not true - 5 concurrent users is the limit at which MSDE starts throttling back its performance.  The more concurrent CONNECTIONS to the...

It's almost 1am where I am (Australia) so I'm not really gonna look deep into the code, but when I had a similar trouble with bookmark lookups I did one of...

And I guess it is precisely the reason why DTS can fail if you just tell it to "copy data" - it doesn't analyse table relationships, etc.  You are effectively...

Well certainly for a data load such as you describe, I suppose it is quite ok to disable constraints, etc on your tables because

• You are the only one putting data...

Cheers 4 that - looks very useful!