Unanswered: How to find the version of a db in Sybase?
Could you please tell me how to find version of the database on a machine which has multiple versions of sybase installed? We are upgrading to Sybase 9 from Sybase 7 and we want to confirm once the db is upgraded if the upgrade completed successfully or not.
I tried select @@version but tht seems to be showing the version of Sybase central and not the db it is connected to.
FYI - This is for ASA upgrade and not ASE.
Any help is much appreciated.
Last edited by \Bin; 09-03-09 at 11:01.
Reason: removed version from title
But, where do I run this command from ? Sybase central ? I couldn't the iqmsg file either.
Just to confirm, I need to know the version of the database itself and not the version of Sybase installed. I have multiple dbs on my machine created by different Sybase versions ... and I need to know the version of Sybase each one of them were created.