No movie or TV production titled "Sweet Deadly Dreams" from 2006 exists in major databases.
Likely issues:
Provide any remembered details—actors, plot fragments, genre, where you saw it mentioned—to aid identification.