Igor Micev (5/16/2014)

In your select

SELECT *

FROM OPENQUERY(ADSI,'SELECT cn,SamAccountName, ADsPath FROM ' 'LDAP://DC=DomainName,DC=com' ' WHERE bjectCategory=' 'person' ' AND objectClass=' 'user' ' ')

why do you have ' 'LDAP://DC=DomainName,DC=com' ' ? You...

All Sorted found the problem.......

The Default Cursor has changed to Local... Needs to Global for Dymanic Cursors to work

I have search but cant find a reason for this.... seen problems with TSQL Code

Have delete and recreated the Group Account.

My Account DB_Ower does the same thing, the sa account...