>I have another question with Application Role. If the application uses SQL connection pooling which means the application closes the connection when done and recreate when needed, can I still use application role?
>
This is not entirely correct. When the application is done with the connection, the connection is returned to the pool. From SQL Server's POV, the connection has not been closed. sp_setAppRole throws an error if an application role is already activited and you try to activate it again.
Hmm...I wonder if the ConnectionReset attribute causes would cause an Application Role to be removed?
-Mike
The last time that I used Application Roles I was bit because the Application Role was still in place when the connection was pulled from the pool.
>I think the answer is no but I just want to confirm.