| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_external_policy_refresh (Transact-SQL) |
Reference documentation to explain sp_external_policy_refresh (Transact-SQL) system stored procedure. |
srdan-bozovic-msft |
srbozovi |
randolphwest |
08/23/2023 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE sqlserver2022]
Forces immediate download of latest published policies for the whole instance (for every database).
Note
If there are any ongoing pull requests by the background task or by another user, the request waits until the former task is finished and starts a new pull. – This ensures that the result of calling this proc explicitly always results in a refreshed cache.
sp_external_policy_refresh [ @type = ] 'type'
[ ; ]
Type can be reload (complete policy download) or update (incremental policy download). Default type is update.
0 (success) or a nonzero number (failure).
Requires ALTER SERVER STATE (covered by CONTROL SERVER) permission.
The following example downloads complete set of policies.
EXEC sp_external_policy_refresh @type = 'reload'The following example downloads policies incrementally by using the default type 'update'.
EXEC sp_external_policy_refresh;