There is something about application roles and the like as a whitepaper at the MSDN site.
>Does anyone have a sample setup login screen that will gain access to an application role on a sql server using ADO?
>
>jeff T.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05