Star Trek: The Next Generation Season 6 Episode 4

Stardate: 46125.3. Montgomery ‘Scotty’ Scott is discovered suspended in a transporter beam 75 years after he disappeared. After the Enterprise crew re-materialise him, he has a hard time adjusting to the new society.