Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

ADS Refresh

 
   Database Help (Home) -> Programming RSS
Next:  I am looking for a php newsletter manager  
Author Message
wcgoddard

External


Since: Feb 10, 2009
Posts: 5



(Msg. 1) Posted: Tue Feb 10, 2009 8:59 am
Post subject: ADS Refresh
Archived from groups: microsoft>public>sqlserver>programming (more info?)

I have set up a linked server to ADS in sql2005. Using OPENQUERY() I fill a
view with the required user properties from AD. However, when I change any of
the user properties in ADS the information displayed in the view does not
seem to show the new values even though the OPENQUERY() each time the view
loads. Any ideas as to what may be going on?
--
warren

 >> Stay informed about: ADS Refresh 
Back to top
Login to vote
Richard Mueller [MVP]

External


Since: Apr 03, 2007
Posts: 14



(Msg. 2) Posted: Tue Feb 10, 2009 11:07 am
Post subject: Re: ADS Refresh [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"wcgoddard" wrote in message

>I have set up a linked server to ADS in sql2005. Using OPENQUERY() I fill a
> view with the required user properties from AD. However, when I change any
> of
> the user properties in ADS the information displayed in the view does not
> seem to show the new values even though the OPENQUERY() each time the view
> loads. Any ideas as to what may be going on?
> --
> warren

Possibly the changes have not replicated. It can take 15 minutes or so for
all DC's to get the modifications, longer if you have slow links between
remote locations. In extreme cases replication could be scheduled once per
day.

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--

 >> Stay informed about: ADS Refresh 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Alter Table Refresh!!! -

need help with query - I want to sum the records in a table (u) which have 'P.M.' in a field value and test against a fixed limit something to the effect of : case when SUM(substring(u.sTime,1,4)='P.M.') <= 64 Then .... except it should work ...

Next?? - I have a field stored as NTEXT(16). I need to replace some of the content in this field. I know the replace function doesnt work. I see there is UPDATETEXT - is this the ONLY way to do it ?? 'cos it looks quite complicated? thanks, Justin

How can I get the resultset from a stored procedure - I have a stored procedure which will output a table. How can I use a sql statement to get the result of the sp? Thanks a lot

Audit V2 - I am looking to write a SQL script that will show me for each table, in all the databases on a server, which users / groups have access. In addition, I want to break the access into whether it is SELECT, UPDATE, INSERT or DELETE permissions. Is this..
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]