Spotlight reports error like this:
WARN Procedure _replication.agentsummary failed : Collection 'Replication Agents' failed : An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. Database '' does not exist. Make sure that the name is entered correctly. [1038]
The dedicated standalone distributor is added as the server to the Replication node of Spotlight but it only detects one publication when there are more different publishers and they all have their own dedicated distribution database.
WORKAROUND
None
STATUS
Issue fixed in version 11.7. The latest version of Spotlight on SQL Server Enterprise can be downloaded here
