Re: Active directory update

From: oj (nospam_ojngo_at_home.com)
Date: 04/21/04 

Date: Tue, 20 Apr 2004 17:24:49 -0700

Paul,

I would look into WMI and sp_OA* if you really want to do it from Sql.
Though, I would go against this. Modifying AD is quite serious. Care should
be taken. 

-- 
-oj
http://www.rac4sql.net
"Paul Ritchie" <Paul.Ritchie@REMOVEpayglobalREMOVE.comREMOVE> wrote in
message news:%235UQlnnJEHA.2412@TK2MSFTNGP12.phx.gbl...
> A client has asked me whether it is possible to (i) update an Active
> Directory when Employee details are changed in our SQL Server database.
> There is also the requirement to (ii) update our database when AD records
> are changed.
>
> I thought that given there appears to be an OLEDB provider that there
should
> be a way to implement (i) using a trigger/stored proc.  I'd really like to
> find an example of that before I believe it is achieveable however.
>
> It seemed to me that I would have to modify our application to achieve
(ii),
> especially as there appears to be no trigger type event in AD.  However if
> (i) can be achieved with triggers then maybe the same logic could be used
to
> periodically update the database from AD using a stored procedure.
>
> I have searched the newsgroup archives but this area does not seem to be
> actively used.  Am I maybe looking in all the wrong places?
>
> regards,
> Paul Ritchie.
>
>

Relevant Pages

  • Re: Trigger for update
    ... > which 2 logins has access to modify this DB and specially EMP, ... > the trigger works successfully when I make new changes in empname ... Since you are dealing with a cross database query, ... A better way might be to use dynamic SQL to determine if the user really ...
    (microsoft.public.sqlserver.programming)
  • RE: Execute a DTS package from a trigger?
    ... I'll assume you are refering literally to "Database Transformation Services" ... Yet you allude to SQL 2005. ... *Using a trigger to *directly* start another process may lead to trouble. ... The message gets sent from the outbound queue to an inbound queue (within the ...
    (microsoft.public.sqlserver.dts)
  • Re: application roles
    ... I 've made a trigger on a SQL2000 database to test your solution with the ... But my login-account and database user appear in my logtable instead of the ... if you are on SQL 2005. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: after servererror trigger question
    ... sql> DROP TABLE SERVERERROR_LOG; ... CREATE OR REPLACE TRIGGER UB_OBJECTS.log_server_errors ... AFTER SERVERERROR ON DATABASE ... vProgram VARCHAR2; ...
    (comp.databases.oracle.server)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
Quantcast