Post reply

AD data extract

  • February 9, 2016 at 4:09 am

    #308304

    Hi All,

    Need help with my query extracting data from AD. It errors with Msg 7330, Level 16, State 2, Line 1

    Cannot fetch a row from OLE DB provider "ADsDSOObject" for linked server "linkedserver".

    The number of records im pulling is around 35000 it stops @ 17000. In my query i have some timing not bomb out

    Please help

    Ta!

    It's better to fail while trying, rather than fail without trying!!!

  • February 9, 2016 at 8:35 pm

    #1857584

    In the past I have used and abandoned using a linked server to get AD information. It is slow and limited (e.g. max records it will return without telling you that it is not giving you everything)

    Instead, try using PowerShell. There are plenty of example out there. It is heaps quicker and I have not seen the limitations that the linked server implementation imposes.

    As a starter, have a look at https://gallery.technet.microsoft.com/scriptcenter/Powershell-script-to-5edcdaea

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply