A database, in SQL Server, doesn't have a password; each login has a password. I'm not familiar with Control M, but it sounds like you're provided the wrong credentials. I'd...

Ideally, don't do this in SQL Server but in your presentation layer. Things like SSRS (using a Matrix) or Microsoft Excel (using a Pivot Table) is far easily. Is this...

Found it! https://www.sqlservercentral.com/Forums/1935691/Corruption-of-the-file-format-mdf#bm1955086

I'm 99% positive that this has been posted before (I recall finding the idea of an MDF getting well again (it had a cold? 🙂 ) quite amusing).

The...

Ire

PRINT @SQL;
Your best friend when debugging dynamic SQL. Debug the SQL output from the PRINT, and then propagate any fixes the the SQL that generated your dynamic SQL.

I very much doubt you need all of those columns in your Clustered Index. Have a look at this article from Redgate: https://www.red-gate.com/simple-talk/sql/learn-sql-server/effective-clustered-indexes/.

Notice, the description says...

You could, with a trigger, however, I don't recommend it. Sounds like you need to create a role or set the permissions of the users/roles at a schema level.