>I’m using MS SQL application roles to maintain some through VFP5. Once I initialize the application role the only way to disable it is to issue an SQLDisconnect. I then have to issue another SQLConnect to continue. Does anyone know how to disable the role without disconnecting or am I just out of luck?
From SQL's Books Online:
After an application role is activated with sp_setapprole, the role cannot be deactivated in the current database until the user disconnects from SQL Server.Therefore, I would say that you are out of luck!
Sylvain Demers