A months-long narcotics investigation led to the execution of a search warrant on Monday in Greenville where authorities say drugs, a firearm and distribution materials were recovered.