>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!