1. Determine the current number of user connections configured: by using the following command

 isql -Uusername -Ppassword 
1> sp_configure "number of user connections"
2> go

2. Set the new value for user connections: (use sp_monitorconfig to monitor the number of user connections)

1> sp_configure "number of user connections",
2> new_value
3> go

3. Restart Adaptive Server to activate the changes.

Thursday, May 16th, 201310:02 amThis entry was posted on at and is filed under Sybase ASE. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.