Apologies for the delayed response. Not wanting to resort to CDOC, we found a workaround as follows:
- We split the stored procedure into two, the first with hard-coded delete...

Hi John,

Thank you for your reply, yes apologies you have spotted two typos of mine:
- The login is called something very simple (e.g. "DeleteMyRows") rather than the...

Hi Grant, thanks very much for the response. Will do!

Thank you, we have already tried, but the error still occurs.

Do you please have any other suggestions?

We've tried both.

Here are some more things we've tried:

- Modified local security policies
- Modified Domain GP for admin accounts
- Used a domain...

Thank you, yes the Import and Export Wizard does appear to be an option in Web Edition. We will see if it could provide an alternative solution.

Does anyone...

Yes I think you are right, we'll have to keep an eye on it! Many thanks for your assistance.

Thank you, yes you are right, and we do have some error handling in place already. The actual script is below - can you see any way in which we...

/S : Copy Subfolders.

/MIR : MIRror a directory tree - equivalent to /PURGE plus all subfolders (/E)

Incredibly, it appeared to be a security issue on a...

I have found the solution:

https://msdn.microsoft.com/en-us/library/ms190078.aspx

Options | Query Results |SQL Server |Results to Grid Page | Retain CR/LF on copy or save

Open a new query window and the carriage returns should...

Sadly something was changed infrastructure-side which resulted in this error disappearing without explanation. I cannot provide a solution to this now unfortunately, suffice to say that we have now got...

Chris Harshman (11/22/2016)

zoggling (11/22/2016)

When we attempt to connect to a named instance on the database server from the web server, the following error is raised in the IIS Log:

Error occurred...

Phil Parkin (11/22/2016)

zoggling (11/22/2016)

Phil Parkin (11/22/2016)

We have installed SQL Server 2016 Web Edition (64-bit) on a new virtualised database server running Windows Server 2016 Standard. We have an existing web...

Thom A (11/22/2016)

Phil Parkin (11/22/2016)

We have installed SQL Server 2016 Web Edition (64-bit) on a new virtualised database server running Windows Server 2016 Standard. We have an existing web server...

Phil Parkin (11/22/2016)

We have installed SQL Server 2016 Web Edition (64-bit) on a new virtualised database server running Windows Server 2016 Standard. We have an existing web server running Windows...