Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Logins from AD to SQL table

    USE [master]

    GO

    sp_configure 'show advanced options',1

    GO

    reconfigure with override

    GO

    sp_configure 'Ad Hoc Distributed Queries',1

    GO

    reconfigure with override

    GO

    SELECT Name,displayName,givenname,sn,telephoneNumber,mobile,mail,distinguishedName,SAMAccountName,'description'

    FROM

    OPENROWSET('ADSDSOObject','adsdatasource' ,

    'SELECT Name, displayName,givenname,sn,distinguishedName,

    SAMAccountName,mail,mobile,telephoneNumber,description

    ...

Viewing post 1 (of 1 total)