Sybase ADDICT

Sybase tips, howto and technical informations – All in a blog !
  • Home
  • Sybase Downloads
  • Sybase Related Links
  • Sybase Jobs


  


  • Tell what platform Sybase ASE is running on, with a sql query

    March 31st, 2010 @ 8:17 PM by Jean-Francois LEBON | 1 Comment

    Want to know what platform your Sybase Adaptive Server is running on ? No need to connect to the machine to find out, just run this little query:

    select name from master..spt_values
    where type = 'E' and number = 1
    go

    For me it shows:

    name
    --------------------------------------------------------
    linux

    Nice…


    Tags: ase, howto, sql, sybase, Sybase Adaptive Server Enterprise, tips, transact-sql

  • Previous post
    Next post


  • 1 Comment »

    1. select @@version

      Should do it also.

      Comment by dsharp63 — April 1, 2010 @ 12:13 AM

    RSS feed for comments.

    Something to say ? Leave a comment...

    You must be logged in to post a comment.



Categories:

  • Review
  • Sybase Adaptive Server Enterprise
  • Sybase Adaptive Server IQ
  • Sybase Articles
  • Sybase HowTo
  • Sybase News
    • End of Life Notice
    • General News
  • Sybase Replication Server
  • Sybase Tips & Tricks
  • Sybase Transact-SQL Code
  • Videos/Podcasts/Webcasts

Quick Links:

  • Sybase quick refence
  • Sybase Bookmarks
  • Sybase Team Forums
  • Sybase Inc
  • International Sybase User Group
  • CodeXchange
  • SQL Anywhere question and answer
  • Sybase Jobs [US]
  • You need a Sybase DBA

Archives:

  • February 2011
  • January 2011
  • October 2010
  • August 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • September 2009
  • July 2009
  • May 2009
  • April 2009
  • January 2009
  • December 2008
  • October 2008
  • September 2008
  • May 2008
© Sybase-ADDICT.com - All Rights Reserved. Entries RSS Comments RSS sybase addict