Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2014

    Unanswered: Query not showing correct database name

    I am executing this query
    select hostname=host_name(), 'sybase instance' = @@servername, dbname=db_name(), 'current date'=getdate()

    The result shows master as the database when the database is DIMM01. Why is it showing master and how do I get it to show DIMM01
    [sql] sasybd11,sad11id1,master,2014-12-05 13:08:16.733
    [sql] 0 rows affected
    [sql] 1 of 1 SQL statements executed successfully

  2. #2
    Join Date
    Jan 2004
    Provided Answers: 4
    What version of Sybase are you running?
    I'm not crazy, I'm an aeroplane!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts