When Scotty walks on to the holodeck version of the (true) 1st Enterprise. Not a fan of the NX-01 retcon as the 1st. His line here's to you lads gets me every time. The follow up exchange between him and Picard is brilliant also.
Here is a link to that scene http://www.youtube.com/watch?v=k2Rv2wZrj-0