Thanks as always Luis

Excellent thanks John, greatly appreciated as always.

Yeah its the series group that causes the issue.

Does your target get its DB's from multiple sources?

If so do any of the sources share the same SQL Login names?

If not and its a 1...

Could just keep it simple and do

CD C:\MyScripts\
COPY *.sql > BigScript.sql

Good script, I would however change sp_change_users_login to ALTER LOGIN instead as the former is marked for depreciation in a later release of the product, just to ensure continued support...

Sorry the reply email went into my Junk folder.

The step is just a simple execute an exe from a network location \\Server\Share\app.exe, running this via CMD as the domain...

No, doing a full backup will not affect the LSN chain so LogShipping will continue to function as needed.

Deprived

GilaMonster (12/23/2015)

Which is an Enterprise edition feature.

With Standard edition, you'll need a 3rd party backup...

Bedtime

Backup encryption without TDE is a 2014 or above feature. https://msdn.microsoft.com/en-us/library/dn449489(v=sql.120).aspx

The only thing I would suggest is to look at TDE (Transparent Data Encryption) https://msdn.microsoft.com/en-us/library/bb934049(v=sql.105).aspx

Statistics

Will be exactly how you call the CONCAT function and how you have already discribed it

CREATE FUNCTION dbo.my_func (@string1 varchar(10), @string2 varchar(10),............, @stringn varchar(10)

...

...

...

dbo.my_func ('string1','string2',.....,'stringn')