sp_version allows you to determine the current version of the scripts (installmaster, installdbccdb, and so on) installed on Adaptive Server, whether they ran successfully or not, and the time they took to complete.
The syntax for sp_version is:
sp_version [script_file [, “all”]]
where:
script_file is the name of the installation script (the default value is NULL).
all reports details about the installation scripts, such as the date it was run and the time it took to run.
For example, the following reports the latest version of installmaster that was run:
1> sp_version installmaster
Script Version Status ----------- ------------------------------------------------------------ ----------- installmaster 15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1/32-bit/OPT/Thu Sep 23 22:12:12 2004 Complete
This example describes what installation scripts were run, what time they were run, and what time they finished:
sp_version null, ‘all’
Script Version Status ----------- ------------------------------------------------------------ ----------- installmaster 15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1/32-bit/OPT/Thu Sep 23 22:12:12 2004 Complete [Started=Sep 24 2004 3:39PM]-[Completed=Sep 24 2004 3:45PM
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
