Someone asked the question about app roles and I had a similar question. If you are developing your own app that has logins; does it make more sense to...

I thought that was old school and in 2005 you are supposed to use the system views?

I'm bummed about the dynamic SQL though, dang it.

Thank you for the advice.