ALTER DATABASE [DB_NAME()] SET TRUSTWORTHY ON

https://docs.microsoft.com/en-us/sql/relational-databases/security/trustworthy-database-property?view=sql-server-2017

No one seems to link the property to the ability to EXECUTE AS OWNER, etc. but its critical for impersonation, I think.

Hi

We have a table with a LOB column (varchar(MAX)) which we update to NULL, after a period of time.

Historical date sensistive archive / operational data... used for tracking and processing.

Row...

Got it. It relates to Locale.

UTF-8 has code page 65001

ANSI Latin-1 has code page 1252

Not sure why this has to be checked, but

ensure the same locale is used.

😀

I...

Used Wizard to import 1 of 3 FLAT FILE CSV files; created destination table.

Used Wizard to import 2 of 3 FLAT FILE CSV files; specified destination created in first run.

SAVED...

Not sure of helpfulness... was running a trace and also hit multiple queries.

select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid

from [DEV].[sys].[filetable_updates_2105058535] with (readpast) order by table_id

Tried to get idea of results;...