I am configuring a new, fully AD group based security scheme on an existing SQL Server 2008.
When I change the group to which I belong to test my configs, it seems that there is quite a delay between the change and it appearing in SQL Server.
To try and improve this I do:
repadmin /syncall /Ade (to force full domain syncing) DBCC FREESYSTEMCACHE(‘TokenAndPermUserStore’)
I've also tried disconnecting and reconnecting the user in SSMS.
Any idea how I can get the AD group permissions to apply faster? Testing once every ten minutes is painful!