Thanks, 
Your idea inspired me and I manged to Create this in Power BI. Basically the same as you said. Thanks again.

• Create a Matrix
• Row = Customer
• Column = Method Of...

Thanks sgmunson, 

Out of curiosity what tools do you use? 

-Jamie

An Example of a 3rd party software we use is called "ChronoScan" But i'm sure their is many others out there.

I tried turning off the SQL server Agent on my home machine and sent an email which worked.

EXEC msdb.dbo.sp_send_dbmail @profile_name='database email',

@recipients='GaffneyJ@Eclipseblinds.co.uk',

@subject= 'TEST',

@body=' TEST'

The link below says this is possible. I...

Thanks John,

this was the issue! Not sure why i never received an error message when trying to install though.

https://msdn.microsoft.com/en-GB/library/ms143506.aspx

Compatible OS

SQL Server StandardWindows Server 2012 R2 Datacenter

Windows Server 2012 R2...

Here is a discovery report of what is installed on the server. I still think the issue is something to do with SQL Express...?

Thanks for the reply! I'm sure there wasn't even an option to enter an instance name. I think that is the next step after selecting the instance features but It...

Old thread I too have been having problems with this in the future...

It Seems to run and not show any error messages...

Command i am running: Setup /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=ecljagaf /sapwd=Password...

Hello,

Thanks you for the replies. I managed to get this sorted with some hardcore googling! Hopefully someone with a similar issue with stubble upon this thread.

http://stackoverflow.com/questions/4381625/first-column-of-insert-into-over-linked-server-ms-sql-mysql-always-empty-stri

This user was...

Hello,

Thanks for the replys. Tried casting as NTEXT/NVARCHAR(MAX) with no luck. The collations probably are the issue, i'll see if I can find some way to get them to...

Bump, still no resolution to this