Today a coworker taught me how to figure out what database instance I am using when using the isql command line tool connecting to Sybase. This involves two query statements:
select dbid from master..sysprocesses where spid = @@spid
The above statement will display the dbid of the database instance you are using. Next using this dbid to find out the name:
select name from master..sysdatabases where dbid = [dbid]
Thanks to Bob for this cool trick! 🙂
Dave's Blogs 