SELECT Util.dbo.StringConcat('REPLACE(', '') + '@SQL' + Util.dbo.StringConcat(',' + srtr + ' + ''' + dstr + ''', ' + srtr + ' + ''LTL_DBA.'')', '')
FROM ( VALUES ( 'CHAR(9)'), ( 'CHAR(10)'), ( 'CHAR(32)') ) a (srtr)
CROSS JOIN (SELECT * FROM (VALUES ('DBA.'), ('[DBA].')) AS D (DSTR)) D
SET NOCOUNT ON
DECLARE @SQL VARCHAR(MAX),
@FilePath VARCHAR(256) = 'c:\temp\repl.sql'
EXEC dbo.sp_script
@DropFunction = 1,
@DropProcedure = 1,
@DropTrigger = 1,
@DropView = 1,
@CreateFunction = 1,
@CreateProcedure = 1,
@CreateTrigger = 1,
@CreateView = 1,
@CreateSETANSI = 1,
@UseGOBatchTerminator = 1,
@IncludeMSShipped = 0,
@ExcludeSchemaList = 'cdc sys Metadata',
@SQL = @SQL OUTPUT
SELECT @SQL = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@SQL, CHAR(9) + 'DBA.', CHAR(9) + 'LTL_DBA.'), CHAR(10) + 'DBA.', CHAR(10) + 'LTL_DBA.'),
CHAR(32) + 'DBA.', CHAR(32) + 'LTL_DBA.'), CHAR(9) + '[DBA].', CHAR(9) + 'LTL_DBA.'), CHAR(10) + '[DBA].',
CHAR(10) + 'LTL_DBA.'), CHAR(32) + '[DBA].', CHAR(32) + 'LTL_DBA.')
SELECT ReturnVal,
MESSAGE,
@FilePath AS FilePath,
'Saved to ' + @FilePath AS Info
FROM Util.FS.AppendAllTextToFile(@FilePath, @SQL, 1)
EXEC Util.dbo.PrintLargeText
@SQL