Adaptive Server Enterprise

0.    ASE History
       0.1    What's in a name?
       0.2    A History of ASE versions
1.    ASE Administration
       1.1    Basic Administration
       1.2    User Database Administration
       1.3    Advanced Administration
       1.4    General Troubleshooting
       1.5    Performance and Tuning
       1.6    Server Monitoring
2.    Platform Specific Issues
       2.1    Solaris
       2.2    NT
       2.3    Linux
3.    DBCC's
4.    isql
5.    bcp
6.    SQL Development
       6.1    SQL Fundamentals
       6.2    SQL Advanced
       6.3    Useful SQL Tricks
7.    Open Client
9.    Freeware
10.  Sybase Technical News
11.  Additional Information
12.  Miscellany

0.1 What's in a name?

Throughout this FAQ you will find references to SQL Server and ASE or Adaptive Server Enterprise to give it its full name.  Do not be confused by the fact that Microsoft also has a product called SQL Server. 

Well, back at about release 4.2 of Sybase SQL Server, the products were exactly the same.  Microsoft were to do the port to NT.  Well, it is pretty well documented, but there was a falling out.  Both companies kept the same name for their data servers and confusion began to reign.  In an attempt to try and sort this out, Sybase renamed their product Adaptive Server Enterprise (ASE) starting with version 11.5.

The following is a quote from a Sybase manual:

Since changing the name of Sybase SQL Server to Adaptive Server Enterprise, Sybase uses the names Adaptive Server and Adaptive Server Enterprise to refer collectively to all supported versions of the Sybase SQL Server and Adaptive Server Enterprise. Version-specific references to Adaptive Server or SQL Server include version numbers.

We will endeavour to try and do the same within the FAQ, but the job is far from complete!

Back to Top

0.2 A History of ASE Versions

The following is a list of the versions of ASE released over the years:

• Sybase SQL Server 3.0 – the first publicly released version of the product released in 1988.
• Sybase SQL Server 4.0 – released in 1990.
• Sybase SQL Server 4.2 – released in 1991.
• Sybase SQL Server 4.8 – released in 1992.
• Sybase SQL Server 4.9 – also released in 1992, along with version 4.9.1; version 4.9.2 was released in 1993.
• Sybase System X, aka Sybase SQL Server 10.0 – released in 1993.
• Sybase SQL Server 11.0 – released in 1995.
• Adaptive Server Enterprise 11.5 – released in 1997.
• Adaptive Server Enterprise 11.9 – released in 1998. It does not appear that version 11.9.0 was ever publicly released; instead 11.9.2 was the released version, and 11.9.3 was the first 64 bit version made available.
• Adaptive Server Enterprise 12.0 – released in 1999.
• Adaptive Server Enterprise 12.5 – released in 2001.
• Adaptive Server Enterprise 12.5.0.1 – released in 2002, along with version 12.5.0.2.
• Adaptive Server Enterprise 12.5.0.3 – released in 2003, along with version 12.5.1.
• Adaptive Server Enterprise 12.5.2 – released in 2004, along with version 12.5.3.
• Adaptive Server Enterprise 12.5.3a – released in 2004/2005.
• Adaptive Server Enterprise 12.5.4 – released in 2006.
• Adaptive Server Enterprise 15.0 – released in 2005, along with version 12.5.3.
• Adaptive Server Enterprise 15.0.1 – released in 2006.
• Adaptive Server Enterprise 15.0.2 – due for release in 2007.

Back to Top