Can I, on an update trigger, add a user to an Active Directory security group? Please help with the T-sql. It is beyond my skills, but the need is there! thanks.
asked
Add user to an Active Directory security group using an UPDATE trigger
One way you could do this is by running WMI scripts through XPCmdShell in your trigger.
Read more on the WMI script here:
http://gallery.technet.microsoft.com/ScriptCenter/en-us/b9c5914e-86cc-4b2b-8b7d-6a82ab2b465d
There are multiple issues with this, though:
- It will make your Updates slower because now you have to shell out, then open a trigger
- In most well set up SQL Server environments XPCmdShell is disabled because opens up security holes - Good luck on getting your DBA to open that one up for you.
