With the disclaimer that this is the first I've ever even heard of {SAP} S/4 Hana databases...

I assume that, since you're posting on an SQL Server forum and mentioned SSIS, ...

DBCC SHRINKFILE on its own isn't the full command... especially if you have 8 files in total.  I'm thinking that you need 8 separate commands for that along with a...

Not me, back at work and getting some things done here today.

Enjoy the holiday, and be safe. My daughter had surgery last week, so we're still helping her recover...

Like I ...

Bah!  It's just not worth it.  You can't add a default column to Temporal Tables.  You can't add a column to the History table without adding it to the main...

Crud.  I was afraid of that.  The dynamic SQL cannot see the INSERTED/DELETED tables, either.  I could copy the INSERTED table to a temporary table or table variable but that's...

p.s. I wish they'd fix the bloody code windows for color on SSC.  It would be better if they simply rendered out as all black rather than serious color mistakes...

That works great but only if that's the only UPDATE trigger on the table.  Here's a test that shows that even though the value of some columns hasn't been changed,...

If I had to do this on a regular basis and couldn't simply do a restore (because of PII of the data simply being too large for a Dev environment,...

My apologies.  You're correct.  You didn't mention Excel anywhere.  My old sometimes caffeine deprived eyes misread it that way.

Going back to the beginning, you stated that the file had both...

My apologies, Scott.  I wasn't clear.  In this particular case, I was referring mostly to solving the problem of having a column that identifies who did the update without the...

@rocky_498 ,

Trying to get this thread back on track for your original question... is there an answer to my inquiry so we can get busy with answering your question with...

You have nothing to apologize about.  I appreciated the humor about the # sign.  I've never...

I've had to use "extension" tables here a few times too, for various reasons.

If you have an identity column present, do remember / be aware of the issues with...

Thanks Neil,

I assumed this level of disdain, to those less experienced, had disappeared twenty years ago from technical forums - apparently not.

I will not be asking too many questions...