ChrisM@Work (10/7/2016)

---

Super_Grover (10/7/2016)

---

Okay, so I created and (partly) filled the three lookup tables and took a go on Scott's approach.

Turned out I was thinking waaay too complex. I ended up...

Okay, so I created and (partly) filled the three lookup tables and took a go on Scott's approach.

Turned out I was thinking waaay too complex. I ended up with a...

drew.allen (10/6/2016)

---

Have you tried Scott's approach?

I also want to add that this violates 2nd Normal Form. Have you considered how you want to handle it when one of the codes...

Okay, so I'll to post some relevant info and while keeping it compact.

This is table: [dbo].[SaltoCardholders]

with some columns:

[ExtUserID] [nvarchar](32)

[FirstName] [nvarchar](40)

[LastName] [nvarchar](40)

[GPF1] [nvarchar](32)

[GPF2] [nvarchar](32)

[GPF3] [nvarchar](32)

[GPF4] [nvarchar](32)

[GPF5] [nvarchar](32)

[ExtAccessLevelIDList] [nvarchar](1024)

[AutoKeyEditROMCode] [varchar](14)

[UserActivation] [datetime]

[UserExpirationExpDate]...

Luis Cazares (10/5/2016)

---

Right now, your code can be simplified to the following.

UPDATE dbo.SaltoCardholders

SET <column_x> = '<some_value>'

WHERE GPF5 = 'VWB';

I'm sure that doesn't solve your problem, but we need more...

Yes, you're right Perry. Connection with DB breaks on failover.

Turned out that the IP config of the listener was not correct. I corrected it yesterday but apparently it needed quite...

I'm connecting to the listener name, but there's someting weird in the config there. I think it's wise for me to have a chat my sysadmin tomorrow morning to clarify...

Maybe it helps, maybe not but here part of the log on failover back to the working node. See attachment.

Hi all, sorry for the delay but I did some testing and checking the logfile.

Yes, I'm talking about Availability Groups. Sorry for the confusion.

I, have this AG for testing and...

Thank you for your input Eddie. Tonight I have a look in the errorlog and do some more testing. I'll be back with the results asap.