I think I found the issue, not sure why , but the "instead of" trigger on that table seems to be re-firing itself

I turned the "allow triggers to fire triggers"...

I managed to track down the code in the trigger (using print statements on my 2019 dev kit)

INSERT INTO order_line
(
    account_code,
   ...

yes,

there is also a begin tran/try catch/commit/rollback in the calling proc

I know the proc should be handling the transaction, but someone has been a bit "slap happy" with XACT_ABORT and...

Ultimately memory optimised tables end up having to be persisted to disk and lord alone I've never tested them with bulk inserts and data manipulation

Are you maybe talking about using...

apologies - I read "truncate table" as "truncate log" my mistake

additionally were you running previously in simple recovery mode?  the database may have been changed to full recovery and there is no t-log backup job..... just guessing.

you could also try...

just for clarification (before I give you the wrong advice) - You mentioned Replication and CDC (change data capture)

which one are you using? they are very different things

I think you are right, Mike. I'm certain that in my position I don't have the clout to effect change. Developers and DBAs are viewed as people who keep...

gotta disagree with frederico on this one... if the software is licenced to the client and the client owns the server then they can do what the heck they want...

I told them when they hired me that I can be a walking HR violation and that they should seat me near people that are not easily offended when I...

• This reply was modified 5 years, 8 months ago by MVDBA (Mike Vessey).

Jeff???? really - you have an age column? whoever did that needs a beating - even as a 16 year old (a long...

Jeff???? really - you have an age column? whoever did that needs a beating - even as a 16 year old (a long time ago)...

This article, Kendra, comes at a critical time for my work, which in the last 18 months had begun to adopt a more agile approach to software development. We...

Sorry to jeff, but i'm going to make light of the split functionality, it ends up in a function that goes RBAR - Use a TVP...

filegroups in a database can be used for a few things (filestream, memory optimised tables etc etc) but splitting your storage is your main gain.. (perhaps a tiny improvement if...