Inserting an ApplicationGroup

Topics: General Topic
Dec 5, 2014 at 9:59 PM
Edited Dec 5, 2014 at 10:09 PM
I'm trying to insert an ApplicationGroup using the objectsid generation here:

It says to use CONVERT(VARBINARY(85), Name). The issue with this is that running the UI after inserting this just gives me an exception saying that the sid revision number other than 1 is invalid. I'm trying to generate the sid based on the Name parameter that I'm passing in. I looked at the code for CreateFromParts to generate the _BinaryForm and I don't understand what's going on there. I just want to be able to create an objectsid for a basic Application Group using only sql. How can I accomplish this?

.NET SQL Authorization Manager Ver