Hi Can some one assist,
I managed to find a few spare mins today looking into this problem.
I zoned in that the problem is relating to the sp_helpqreader_agent SP, and is the problem SP as it returns null for the @loc_distribdb which it retrieves from the CONVERT(sysname, SERVERPROPERTY('ServerName')) .
When I run @@Servername is showing correctly my alias name, but when I run the serverproperty statement above i recieve the actual SERVERNAME\ALIAS, which seems wrong and like its a bug. I've trawled around to find a solution but have not yet found a solution.
Is there any way around this so the name is displayed correctly?