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?

Thanks.

/Chris