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?
I think the answer is no but I just want to confirm.
Stephen Lee
--------------------------------
Too much to code
Too little time
--------------------------------