SQL SERVER - HELP!!!!

Can someone post some code which provides an example of using SQL Server application roles within the vbcode.

(also any other info which you feel may be inportant for someone who has not done this before)

Please Help.

Thanks in advance.