Returns the version information of the installation scripts (installmaster, installdbccdb, and so on) that was last run and whether it was successful.
sp_version [script_file, [all]]
is the name of the installation script (the default value is NULL).
reports details about the installation scripts, such as the date it was run and the time it took to run.
Returns the script name, version, and status of all installation scripts that have been run:
sp_version
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 installmaster 15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1/32-bit/OPT/Thu Sep 23 22:12:12 2004 Complete installmodel 15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1861/32- bit/OPT/Mon Sep 27 23:40:02 2004 Complete
Returns information about the installmaster installation script:
sp_version installmaster
----------- --------------------------------------------------------- installmaster 15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1/32-bit/OPT/Thu Sep 23 22:12:12 2004 Complete
Returns script file name, date, time, version, and status for all the installation scripts run:
sp_version null, 'all'
Script Version Status Start/End Date --------------------------------------------------------------------- installdbccdb 15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1861/32- bit/OPT/Mon Sep 27 23:40:02 2004 Complete [Started=Sep 29 2004 4:41PM]-[Completed=Sep 29 2004 4:42PM] 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 29 2004 3:49PM]-[Completed=Sep 29 2004 3:58PM] installmodel 15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1861/32-bit/OPT/Mon Sep 27 23: 40:02 2004 Complete [Started=Sep 29 2004 4:51PM]-[Completed=Sep 29 2004 4:51PM]
Returns script file name, version, and status of installation of all the install scripts having names like install%:
sp_version 'install%'
Script Version Status ---------- ------------------------------------------------------- installdbccdb 15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1861/32-bit/OPT/Mon Sep 27 23:40:02 2004 Complete installmaster 15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1/32-bit/OPT/Thu Sep 23 22:12: 12 2004 Complete installmodel 15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1861/32-bit/OPT/Mon Sep 27 23: 40:02 2004 Complete
Returns all detailed information about installation scripts matching the wildcard “install%”:
sp_version 'install%', 'all'
Script Version Status Start/End Date --------------------------------------------------------------------- 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 29 2004 3:49PM]-[Completed=Sep 29 2004 3:58PM]
Returns all detailed information about the installmaster installation script:
sp_version 'installmaster', 'all'
Script Version Status Start/End Date --------------------------------------------------------------------- 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 29 2004 3:49PM]-[Completed=Sep 29 2004 3:58PM]
sp_version allows you to determine the current version of the scripts (installmaster, installdbccdb, and so on) installed on Adaptive Server, and whether they ran successfully or not, and the time they took to complete
Any user can run sp_version.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
