Hi,

Using Win2K, SQL2K.

We're using OPENROWSET(NetUserGetGroups, @acctname) to get the list of AD groups to which the @acctname belongs. Note that the call does not specify which domain controller to query.

Well, the DC it is querying is experiencing some technical difficulties in that it is not allowing updates to AD. So newly created groups are not being returned (this is not due to the replication lag, it saw these groups yesterday).

Is there a way to specify which DC to query? How?

P


MS Sql Server LazyDBA home page