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

As previously mentioned:

This share is located locally on the secondary server, so I...

The underlying hypervisor virtual infrastructure all appears to be ok and up-to-date. It is regularly patched and updated.

We may well need to open a support request with MS. In the...

CPU averages around 1%

108GB free on the data drive, 83GB free on the logs...

Update:

We attempted to go down the repair route for the secondary database, to try and glean more information. However this did not meet with success.

-- The following failed, and resulted...

Ok but how does one create a login and associated user (destined for the secondary database/domain) in the primary database/domain? The Windows NT user or group will not necessarily be...