Hi,

does it possible to add or remove a member from a role using an XML/A
command?
from what I can see, I can change the members list, but the command
completly overwrite the member list, not only adding/removing 1 member from
the list.

any documentation around this?

thanks.

Jerome.

I think you are right. Running profiler while changing roles from SSMS
(which is probably what you did too) produced an XMLA command which
would entirely overwrite the memberlist.

I have not seen any specific documentation on this, but from my
experiences with XML/A it does seem to work in this manner. It would be
interesting to hear confirmation from MSFT if anyone is watching this
thread.

I don't know if this would help in your situation, but it is possible to
generate this XMLA using AMO. You basically turn on the CaptureXML
property and then make your changes using the AMO object model and then
extract the generated XMLA from the CaptureLog property.

I have some sample code on using this technique on my blog here:
http://geekswithblogs.net/darrengosb.../GenerateXmlaB
yName.aspx

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <OtSnlUGpGHA.1140 (AT) TK2MSFTNGP05 (DOT) phx.gbl>,
willgart_A_ (AT) hotmail_A_ (DOT) com says...