Verify that servers are running

  1. To find out whether Adaptive Server is currently running, try to log in to the server, using isql:

    isql -Usa -P -Sserver_name

    If the server is running, you see the isql prompt:


    You can also use the showserver command to determine whether any Adaptive Server processes are running. For example:

  2. To verify that you are at the new version level, connect to Adaptive Server via isql and run the following commands:

    1> select @@version 
    2> go

    Look for “12.5” in the version string.

    1> sp_configure "upgrade version" 
    2> go

    sp_configure should return the Run Value “12500”.