Yeah, I remember one episode where Mr. Scott took his bottle of Scotch and tried to use it to get someone drunk but it didn't work. Can't remember the reason though.
Actually, I believe it did work. But Scotty got drunk and passed out, too.