You post data by providing tested/working insert scripts that insert test data into the relevant tables for which you have provided DDL scripts.

That has been mentioned before -- e.g., https://www.sqlservercentral.com/forums/topic/dimensional-table-and-stored-procedure#post-4145269

member_number is a bigint in [localgroupmembershiprostercsv__$], & MemberNumber is only an int in @Temp & Members? Are any of the member #s larger than an int & possibly truncated (which...

Sounds like a prelude to spam.

Despite the name, I'm not aware of that being a Microsoft system stored procedure.

Can you provide the relevant body of the stored procedure (obfuscated for security if necessary)?

The error means...

You can't alter an existing computed column -- it has to be dropped & re-added.

Not much to go on. Is  the data relational? What database system is it stored in? Do you intend to move it to the same database system? To a self-managed...

• Look at the execution plans for proc calls made by the bot vs running them in SSMS. There could be parameter sniffing issues generating bad plans. Or if they...

We appreciate the DDL.

Please provide insert scripts with sample data that we can develop & test with, not just bracketed insert templates that fail with errors when executed.

You can't guarantee that natural keys will always be a single column.

For artificial integer keys, I recommend using <TableName>ID (where <TableName> is the actual table name)to avoid ambiguity and confusion....

We use xp_delete_file  with something like this:

declare @daysToKeep int = 3
declare @minDateToKeep date = dateadd(day,-daysToKeep ,sysdatetime());
declare @dateString char(10) = convert(char(10),@minDateToKeep,121);
declare @traceFilePath varchar(30) = 'D:\Audit\';

EXECUTE master.dbo.xp_delete_file 0,@traceFilePath, N'trc',@dateString;

The second scenario makes sense -- read-committed snapshot is going to maintain the version store until transaction is completed regardless of the isolation used by that transaction, because reads by...

Is ALLOW_SNAPSHOT_ISOLATION on?

If all the tables are joined in the same query, then you need to alias Table0 in the join to each table to enabled SQL Server... and you... to resolve...

Does the SQL Server agent account have permissions on those other directories?

You are using a function in a predicate (e.g., where clause), rendering it non-sargable (can't use index). The following should probably be sargable, & perform better (assuming you have appropriate...