By default in a multiplex database, sp_iqindexinfo displays
information about the shared IQ store on a secondary server. If
individual tables or indexes are specified, then the store to display
is selected automatically.
Permissions
DBA authority required. Users without DBA authority must be
granted EXECUTE permission to run
the stored procedure.