david.gugg (6/19/2014)

---

GilaMonster (6/19/2014)

---

On dev servers, I'm very happy to give developers db_owner of the DB they're working in,...

Koen Verbeeck (6/19/2014)

---

I think the motive behind the question is something like this:

the developer has no clue what actual permissions he needs, so he aims for the big guns and...

Unless there is a new 2012 feature that hasn't been well advertised, SQL Server does not do active/active clusters.

You have created two SQL instances which are active/passsive on different servers,...

Seems to be a lot of re-invent-the-wheel being suggested.

If you want unique ids (including generating across different machines) and you want random for "security" because you think they are unguessable...

Mark Horninger (5/19/2008)

---

Seems like the 'right' answer is to redesign the DB.

Having inherited designs like this most likely the reason for the design is to provided the flexibility to add...