Thanks for your thoughts Dixie.

I think you may be right and I need to look elsewhere for an answer.

Thanks for the reply Dixie.

We are running SQL2016 and the project target platform is SQL2016.

I've checked the Compatibility level and it is 130.

The SP deploys and executes without issue...

Good article. Something I read once that has stuck with me is "the plural of anecdote is not data" - I find myself reminding myself of that quite regularly (see...

Ahh... the benefit...

We use RedGate SQL Compare to create all the scripts for a DB and this structure is then held in Subversion.

We then develop using QA (or whatever suits the...

I have just had a similar problem with the same error message.

I got around it by changing the name of the sheet that I was trying to create to something...

I think that authentication issues and concerns will limit remote access to potentially sensitive data held by Drs, Banks, etc.

Good Question:

Also

DECLARE @PrincipalAmount VARCHAR(15)

SET @PrincipalAmount = '£700,000'

SELECT ISNUMERIC(@PrincipalAmount)

returns 1 as does

DECLARE @PrincipalAmount VARCHAR(15)

SET @PrincipalAmount = '$700,000'

SELECT ISNUMERIC(@PrincipalAmount)

See http://msdn.microsoft.com/en-us/library/ms188688.aspx for other recognised currency symbols

I might be wrong, but I think that this is one of the practices advocated in GTD (Getting to Done).

It has been something I've tried to get into the...

The grass is always greener...

Did the distribution graph of members at each level ever get published?

I've recently being trying to get more involved in this site and I'd like to be able to...

Thanks Steve!

Could I add my vote to this suggestion.

I find the QOTD section great for testing my knowledge during a lunch break - being able to find questions I've yet to...

I find these questions great training - thanks!

Thank you very much for your help.