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?

Might be an issue with 2016, you running the most recent CTP?

Not had chance to install and play with 2016 yet so all stabs in the dark.

Try running IE as admin to get around UAC, if that's your problem question with you sysadmins / security personnel as to weather or not UAC is a requirement for...

Something like the following

;with cte as

(

select

row_number() over (partition by t1.pid order by t1.pid, t2.flag) as RN,

t1.pid,

t1.name,

t1.amount,

t2.subnum,

t2.flag

from

t1

inner join

t2

on t1.pid = t2.pid

)

select

case when rn = 1 then pid else 0 end as...