What I meant about capital letters is exactly that. Capital letters in the URL.  SQLServer is not the same thing as sqlserver. Notice the capital letters?

Also, did you try running...

• This reply was modified 5 years, 8 months ago by Mr. Brian Gale.

Michael.leach2015 - you should read Mike01's link.  A lot of people (myself included) do not like downloading random files off of a forum to try to help people.

Drew.Allen did a...

Without a bit more information it is impossible to say.

What does it mean by "stopped allowing connections"?  It could be account lockouts, could be your SQL is not doing authentication...

even with the corrected XML that I put there?

If you run the query I provided in full, it runs and gives you the results you want.

I ran this on SQL...

I think the tool you are looking for already exists in SQL Server - comments.

If the code is difficult to understand, it should be commented.

Failing that, PRINT or SELECT to...

One option that would allow you to continue to control the databases while not presenting it to the client would be to still own the databases.  Host them yourselves or...

This is what you need to add:

  DBType = x.value('(Query/DataSetParameters/DataSetParameter/rd:DbType)[1]','VARCHAR(MAX)'),
  IsMultiValued = x.value('(Query/DataSetParameters/DataSetParameter/rd:IsMultiValued)[1]','VARCHAR(MAX)')

Full query:

DECLARE @xml XML = '<SharedDataSet xmlns:rd="http://schemas.microsoft.com/sqlserver/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition" >
 ...

• This reply was modified 5 years, 8 months ago by Mr. Brian Gale.

for those who want to run this without having to create a table and put the XML into it:

DECLARE @xml XML = '<SharedDataSet xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition">
  <Description...

Have you tested it?  Have the developers tested it?

It falls under "it depends", but, similar to working with ROLLBACK or COMMIT on a transaction.  If you have something like this:

While your assumption of my incompetence probably would save you time somewhere, no, I do not fall in that group of people. Also, bite me.

Just because there are ways...

You could use "location" still, but put []'s around it too.  My habit is to put [] around my objects.  Never know when a new version of SQL...

• This reply was modified 5 years, 8 months ago by Mr. Brian Gale.

I think my only question here is what do  you consider a "valid" revised start/end dates?  for example, if you had this:

start              end

Dec 1,2020...

If I understand that script correctly, you are essentially doing a find and replace with a large list of characters to swap out, correct?  If the character is "aù", you...

You could use "location" still, but put []'s around it too.  My habit is to put [] around my objects.  Never know when a new version of SQL will add...

I don't think telling SQL it can use more memory is the way to go when you are possibly having memory pressure already. If I understood you correctly you said...