Yes. you need to open the original Messaging app (if you have deleted it from your home screen, you can find it in the Applications section). Once it is open, hit the Menu button, then Settings. Scroll down to the Notification setting and unselect it.
You will then get a notification from...