Perhaps the SAGE ODBC drivers are not very friendly for use in a threaded server environment?  You could create a DTS task that imported the data into some staging table...

Could you please provide your table definition (the create table statement) and the exact textcopy command line parameters you are using...  Textcopy won't create new rows in a table -...

When you say "corrupt" - what is telling you it is corrupt and giving you the primary key violation error?  If it is your powerbuilder client-side app, then SQL is...

All valid but they are getting a bit "icky"   Two separate resultsets is the clearest way to do it, but depending on your...

Yeah - most certainly not to use in a busy production environment   Same goes for normal app programming - don't have user interactions...

Problems like that can be frustrating

I don't envy your next couple of weeks

If it's "none", then ask for lots of cash for servers....   And then move to another...

Many ppl on here (I've been too lazy to do it unless doing big bulk updates!) ALWAYS start their scripts with a BEGIN TRANSACTION when working in QA.

They also automatically...

Are you using simple or full recovery?  If using full, backup the transaction log, or switch to simple recovery mode which will truncate the log at various intervals.

If you insert the 50 records in a single insert statement using something like

insert into User_Master(....)

select blah1, blah2, blah3, etc

from some_joined_tables

then your trigger will fire once.

If you issue 50 separate...

Check things like blocking, also look at your queries to see how efficient their use of indices is...

Please don't cross post...

Answer in this forum instead...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=248306

Thanks...

Sounds like you might need to write a lot of custom scripts to accomplish this...  Use uniqueidentifier columns liberally to at least make life easier (not needing to deal with...

And all your SQL instances backup to the same set of folders?  Have you checked the folder permissions for the SQL Server account & SQL Server Agent account?

Didn't know about the raw option on bulk insert (haven't used bulk insert that much).  From reading BOL it appears that you have to have field terminators, row terminators, etc...  Do you...