Is it possible something modified [RISE].[dbo].[tb_CompaniesToRun] while the process was running?  Since you're requerying that table every time you loop it's possible something was modifying those SP names while it was...

Try changing the format of the input file from fixed width to ragged right, you shouldn't need a pre process step.

This might work better as a preprocess step as this kind of logic generally lends itself better to scripting languages if you don't have an easy way to identify header...

Yes if you know the login/logins at fault you can certainly script out the grant/deny permissions on the objects in question.

Assuming Anl2 is actually a nvarchar type you need to put the 01 in single quotes '01' , what's happening is SQL Server is seeing 01 as a number so...

I would definitely recommend number 3, let the OS handle the actual file management that's part of what it's there for after all.  In the database store whatever meta data...

Maybe the DBA's didn't quite understand what you were asking?  You are correct however if you already knowing certain columns will be unique adding more columns to that combination will...

Just?

SELECT 'SELECT '+c.name+' FROM '+s.name+'.'+t.name+' WHERE FirstName = ''Desmond'''
FROM sys.columns c
INNER JOIN  sys.tables t on c.object_id=t.object_id
INNER JOIN sys.schemas s on t.schema_id=s.schema_id