Solution found -

SET IDENTITY_INSERT [FIM_GLOBAL_ID] OFF

drop the row I want to change the ID on and then re insert it with the new ID

SET IDENTITY_INSERT dbo.[FIM_GLOBAL_ID] ON

Very good question - got caught out with as well. Should have realized that with out the where clause that each max() is evaluated individually... nice to learn something at...

+1...

Thanks for the QotD.

L' Eomot Inversé (11/5/2013)

---

Ford Fairlane (11/4/2013)

---

Richard Warr (11/4/2013)

---

Seems to be one where the people who didn't think about it found it easy (see some of the comments above) whilst those...

😀 Easy question - no wait after looking deeper into this shouldn't I expect to see oh wait no it was easy thanks Steve for the QotD

Richard Warr (11/4/2013)

---

Seems to be one where the people who didn't think about it found it easy (see some of the comments above) whilst those who dug a bit deeper...

Too easy and straight forward QotD. 🙂

The man...

Great QotD - made me think and slow down before answering ( also ran the code to check what I thought MAY be the answer )

Nice QotD thanks

Nice start to the week.

Thanks for the easy way to end my week 🙂

Koen Verbeeck (10/23/2013)

---

Easiest question ever. It doesn't even matter which feature is being asked.

Enterprise has every feature, and developer & evaluation have the same features as Enterprise.

Ergo, no thinking needed,...

Nice question - thanks