A police detective has testified in court that the TV reporter who died while covering Super Bowl week in New Orleans had a sedative drug in his system.