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.
Nov 10 '09 at 01:30 PM
Nov 11 '09 at 08:47 AM
Melvyn Harbour 1 ♦♦
One way you could do this is by running WMI scripts through XPCmdShell in your trigger.
Read more on the WMI script here:
There are multiple issues with this, though:
Nov 10 '09 at 02:44 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Nov 10 '09 at 01:30 PM
Seen: 2440 times
Last Updated: Nov 11 '09 at 08:47 AM
Has anyone tried TDE and seen how it performs in production
IS THE PORT 1433 A SECURE PORT
How do you get disk drive stats without the use of OLE Automation or XP_CMDSHELL?
Tracking record's origin
how to find dropped login by whoom
SQL Server Login Audit
not possible to add a group to a database role?
Using views & triggers for security instead of stored procedures
Where does the future of security go after Stuxnet
How to Restrict DBA from Read/Write But Still can perform Maintenance tasks