The error looks like a firewall thing to me. Can't establish a connection.

I might connect to the source SQL Server and verify the source db is accessible. Meaning that TDE...

Not entirely sure, but I do know there is a proc that you can run, which might do what the auto cleanup is missing: sp_flush_CT_internal_table_on_demand

I might run that and...

No company can afford a highly skilled coder to go around refactoring their code base and shouldn't use an inexperienced coder for the task.  When does it make sense...

I am currently in the midst of a refactoring project primarilly intended to "quiet" the log files.  Non-catestrophic errors and warnings are polluting the log files causing unacceptable growth.

One...

I tend to adopt Aaron's view a lot. I am refactoring my code and trying to make it better, but also help me clean things up that are an investment...

You can ask the AI what they did. I asked to restore a single table. Got "RESTORE FROM DISK WITH SINGLE_TABLE". Told it didn't exist but I could have pasted...

This apply?

https://support.microsoft.com/hu-hu/topic/kb4538365-fix-change-tracking-cleanup-does-not-work-when-invalid-cleanup-and-hardened-cleanup-version-are-negative-in-sql-server-2017-and-2019-f186bd92-622c-89f2-a6c2-739c250593f2

Expired records should be those that are in the tables, but should be deleted. Are you saying based on settings there aren't any records in the on-disk table...

Jason,

ask yourself this. Is the vibe coding any different from blindly approving a PR from a colleague? Or having to support someone else's code who you know takes shortcuts?

Those lawyers...

There is an FTP task in SSIS (https://learn.microsoft.com/en-us/sql/integration-services/control-flow/ftp-task?view=sql-server-ver17) and it works. Not SFTP though.

Works fine and I ahve friend still running xfers via ftp (or sftp via third party)

Glad you liked it

Yes, indexing makes a huge difference and the performance savings can overwhelm the index creation time/CPU

I find that the more talented people are with a skill, the less they trust an AI or want to use it. It's interesting, because it "reasons" about as well...

https://learn.microsoft.com/en-us/sql/reporting-services/report-server/rsreportserver-config-configuration-file?view=sql-server-ver17

I lean towards Uwe's solution, especially when I need the table to stay online and accept insert/update/delete while I'm deleting data.

Microsoft implemented a change requiring a cert that is trusted through the local hierarchy, or the client clicking "trust cert". Depending on which client versions were upgraded or servers changed,...