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')

Chocolate Fireguard

Unknown

Everything

Are BizTalk and SQL on the same box? If yes, then you could potentially run into an issue if MSDTC wants to use one of the SQL Ports

Depends on the corruption

What is the full output of

DBCC CHECKDB <<DBNAME>> WITH NO_INFOMSGS, ALL_ERRORMSGS

When was your last good backup?

ALTER SCHEMA dbo TRANSFER MDCH.Hist5657;

GO

Check the job history in Job Activity Monitor or MSDB, it should detail who started the job.

It all comes down to how you want to manage security?

Can you allow the same account to connect to all databases? Does this pose a security risk to your...

Did you change the accounts back to the original service account prior to doing different ways?

IE if you used services.msc first, did you then go straight to SSCM or did...

How did you change the service account?

Services.msc or SQL Server Configuration Manager?

This isn't a SQL Express install by any chance is it?

Will it work - Yes

But from your first post, using it for reporting, using Developer edition will breach the T&C's you accept at install time

Restore the backup as another name, then use T-SQL or SSIS (Import/Export Data Wizard) to move the data from tables in question

Have you given permissions at the root and worked them down the folder structure, or given them at the individual report level?