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:
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”.