It would still be nice to see the code of the function.

Depending on what functions does, they may force row-by-row operations, in effect creating an 'implicit cursor' on you, even...

Maybe this is not what you'd want to hear, but the solution to the problem doesn't lie with convoluted SQL (although I know - this is what we all have...

The trigger doesn't deal with multiple records affected, it just pours the entire contents of inserted and deleted into the audit table. So...... what does the update triggering this look...

I believe your best method would be to load the text file into a staging table with bcp. When you ahve the file loaded in that table, you can then...

I prefer to use LIKE and wildcards, gives more control over what type of chars you want to qualify (assumes char/varchar datatypes for your data when validating)

create table...

Oh, no worries. Sometimes I overly mark words a bit. Perhaps due to English not being my native language

AFAIK, this syntax has...

Unfortunately there is no way in Transact SQL to trap this (or any other fatal) error, since the SQL code stops executing immediately and exits. You never get to the...

Hmm... are you positive that both plans are identical? If that indeed is the case, there has to be something else. At least the step of retrieveing the rows has...

What does the queryplan say? Do you get tablescan when using variables and index seek with hardcoded values?

..felt I had to give a small tip on the datehandling when setting...

UPDATE f

SET f.fleetCODE = m.FleetNr

FROM dbo.machine m

JOIN dbo.fill f

ON m.machinereg = f.fleetreg

/Kenneth

..and you can do a 'SELECT * from oldowner.Loan_Dim' as well...?

/Kenneth

Not trying to beat a dead horse here, but I just want to stress that it's not really a workaround - it's how it's supposed to work (though very poorly...

Yes, this pretty much sums up the confusion about re-enabling and re-enabling AND validating existing data.

BOL is very confusing about the syntax, and what really happens when you say...

We are on the path of redefining 'elegant' now, aren't we..?

/Kenneth

Have you tried sp_changeobjectowner 'oldownerName.Loan_Dim', 'dbo' ?

/Kenneth