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...

Sergiy (11/21/2016)

---

I guess this trigger would do what you want to do:

CREATE TRIGGER dbo.trg_MakeLatestRecordActive ON dbo.Records

FOR INSERT, UPDATE

AS

UPDATE R

SET Active = CASE WHEN R.RecordID = i.LastRecordID THEN 1 ELSE...

John Rowan (11/21/2016)

---

Consider changing your design. I prefer to not persist this type of value in my data. A view would be a great way to expose the...

Unfortately the test environments are not exhibiting the same symptoms, and neither have they been provisioned with comparable resources. This makes it more difficult to reproduce.

Is there another approach...

Will an index not just potentially slow things down further?

Can you see any way in which this trigger can be improved? This seems to be our sole (and frequent) source...