Thanks guys.

Im checking if ExtendedEvents could work for me.

Adding a DatabaseAudit to the model wont work as theres a good chance a lot of the databases will be restores from...

thanks guys. perfect explination. I was incorrectly viewing how decimal/numeric are formatted. Issue resolved.

Hey Guys.

I was viewing the information incorrectly and so phrased the problem incorrectly.

The waits were not due to the insert, but the select statement that was being used as the...

I dont think it will be worthless. Its no longer attainable as its not available, the standard required to obtain it still exists, anyone who got it, reached that standard...

perfect, thanks!

Thanks for the input folks. I do expect to have to put in a certain amount of time outside of work, but its becomming a bit much lately. I am...

That's an interesting statement. Thanks for...

perfect, great help, thank you!

that helps a lot. By tacking "always on" to "failover Clustering" in the documentation microsoft confused the issue.

when you say a failover cluster can be geographically disparate, you mean...

I appreciate it might not be the best solution from your point of view, but forgetting if its good or bad, is the only way to assign a new owner...

Ok, I got it sorted, escalation to management made a lot of stuff easier!

Regarding the question "can you initialize mirroring with a copy only backup", there has been no answer...

the latest scheduled backup is 6 days old meaning there will be a LOT of log files to restore. Coupled with the further red tape to get access to the...

no worries. thanks for giving it a go. it may well be that my pc just needs a rebuild.

Yes, SSIS is installed.

Thanks! I didn't know that, really good to know.

The item in question is a Script Component, and it is set as a transformation.