Thank you for your input. This is a true air gapped system/network and connection is strictly limited to machines on that network. Opening it up to external access, no matter...

Thanks I'll look into that. I agree with you regarding the SQL Server logins and that's what I'm pushing since there are quite a few of them. I'd like to...

Thanks for your input. I've done some thinking about this and might be able to work something out querying the sys.syslogins. Since a trigger will catch every login it's not...

Good point. I have no idea why they choose not to use ALTER.  My guess is that they want to start "fresh" or they don't fully understand ALTER

Developers don't deploy, the scripts are handed off to me and I usually go back and run grant statements.  Sometimes things slip through the cracks and I miss something.  Of...

That's what I needed - Thanks

Yes, the staging table can be anything right now

I'll take a look at these two paths, thanks for your suggestions

Ideally, I would like to get this into 2 columns.  One for the 4 digit integer (which would actually be my key) and then the description

The flat file has the data in the correct order, every record does begin with the 4 digit integer and then the description, but there are carrage returns at the...

The rows are in the correct order from what I can tell

Hopefully this will help, right now there are 7 records that need to be combined into 2 records each beginning with the 4 digit integer and the corresponding string.

Sorry, I would like to have the rows that don't begin with nnnn to be attached to the previous row.  The data source I recieved has a Item number (nnnn)...

Works, thanks

Thanks for the suggestion.