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: 2632 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?
how to find dropped login by whoom
Tracking record's origin
not possible to add a group to a database role?
SQL Server Login Audit
Using views & triggers for security instead of stored procedures
sql 2k5 effective permissions list not containing the explicit permissions
Maintenance job failure