Does anybody have an example or know where to get one on how to implement role-based security using sql server?

I have done a few searches, and I find alot of info on doing this, but none of them use SQL for the user list.

Please someone help.