Private investigators must operate openly under their real names, says veteran trainer – many fear being branded their town’s ‘Columbo’