Not sure yet, this is a work in progress. Given the nature of the data the number of columns returned from the source would be variable as would the values.

This...

Hi, no the denormalised result set will go into a SQL table that will feed BI "bits"

Thanks. Still no good in IE.

Tried in Chrome and get the exe perfectly.

Indeed. Apologies. Like another earlier poster I too missed the subsequent pages of replies and didn't see that the offending process had been identified.

I wish I had it would have...

Thought I would add to this thread as I have just had the exact same issue and have nailed the culprit.

System Center Management Service Host Process

The network admin set-up SCOM...

Thanks, I've sent them an email asking if there is anything I should be wary of.

Will post back their advice.

Cool thanks.

Here is what I have done and it appears to have achieved the desired result.

On the 2 databases that I wanted this account out of I ran

ALTER AUTHORIZATION ON DATABASE::DBname...

Thanks, these 2 dbs have always resided on the same server. They are a test and a production of the same application. Bad practice, I know, but not my set-up.

There...

I don't think this is being used for backup purposes in the traditional sense. I do SQL backups and commvault picks these up off the system.

In this instance, this server...

Yep, picking it is Simpana from Commvault.

Going to get the network admin to call to confirm with them.

Maybe it has always worked this way but I'm only seeing them in...

We have commvault simpana which apparently has a SQL Connector for backups.

Perhaps this has detected the enterprise version and is utilising snapshots in order to do it's thing.

We haven't bothered...

Just did and was on my way back to report 🙂

Seems the sys engineer priovided the incorrect key when installing - this is indeed enterprise!

So now that mystery is solved.

How,...

Thanks, these are not hidden as I can see them on the file system and under snapshots in SSMS.

Do you know what is taking them, how it could have done...

Yep, I have a dedicated disk for TempDB and only TempDB

This is a Sharepoint (SQL) server so the activity is "sort of" predetermined.

No other apps/DBs on this server.

I heard...