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.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Nov 10 '09 at 01:30 PM
Seen: 2098 times
Last Updated: Nov 11 '09 at 08:47 AM
Tracking record's origin
how to find dropped login by whoom
How do you get disk drive stats without the use of OLE Automation or XP_CMDSHELL?
not possible to add a group to a database role?
Has anyone tried TDE and seen how it performs in production
IS THE PORT 1433 A SECURE PORT
SQL Server Login Audit
Using views & triggers for security instead of stored procedures
How do I get the last time a database was accessed?
property size is not availalbe for database tempdb.
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.