Last updated: 01 September 2020
Site Map

🡆 🡆 🡆 Notice: will be closing down. More information is here.

Welcome to, a web site dedicated to the Sybase products ASE, Replication Server and IQ.
Most content on this web site has been created by Rob Verschoor, a Sybase Certified DBA for Sybase ASE, Sybase IQ and Sybase Replication Server. Some material has kindly been contributed by other authors as indicated.

The information on this web site is copyrighted material, available free of charge. Please be aware of the applicable copyright issues, the legal disclaimer, and some restrictions.

Contents: (bold = most popular)

What's new at (September 2020):

Sybase books by Rob Verschoor
The Complete Sybase ASE Quick Reference Guide; 7th edition  
The Complete Sybase IQ Quick Reference Guide; 1st edition
  The Complete Sybase Replication Server Quick Reference Guide; 3rd edition
"The Complete Sybase ASE Quick Reference Guide" - 7th edition -- an indispensable resource for any ASE DBA or developer, covering all commands, functions and system stored procs in ASE. The 7th edition is updated for version 16.0 SP03
Available now!
"The Complete Sybase IQ Quick Reference Guide" - 1st edition -- a must-have for every IQ DBA or developer, covering all commands, options, startup switches and background info you may need in practice. Covers IQ 15.0 - 15.4.
Available now!
  "The Complete Sybase Replication Server Quick Reference Guide" - 3rd edition, updated for RS 15.7.1 -- an essential companion for every RepServer DBA.
Available now!
    Tips, Tricks & Recipes for Sybase ASE; 2nd edition    
    "Tips, Tricks & Recipes for Sybase ASE" - 2nd edition -- a unique book full of handy tips & tricks to make the most of ASE. The 2nd edition is fully reviewed and updated for ASE 15.0, with 80 pages of new material.
Available now!

A quick introduction to Sybase ASE

If you're new to Sybase ASE, here is some info about ASE to get you started:

Tips & Tricks & Documentation
  • Granting SA-commands to non-SA users: it may not be in the books, but it is possible! This shows how to allow ordinary users to execute commands like kill, sp_sysmon and sp_showplan without giving them sa_role ... (includes downloadable code)

Background Documentation
  • Everything you wanted to know about login triggers (a new feature in ASE 12.5)
  • ASE Replicator: a new feature in ASE which can be used to implement small replication systems.

Sybase IQ

Replication Server

ASE Tools
  • sybinit4ever - an ASCII-only Unix tool for ASE 12.5/12.0/11.9/11.5 server creation; runs on all Unix platforms, including Linux.
  • A page with details about all dbccdb faults; handy for DBAs running ASE pre-, where sp_dbcc_help_fault is not yet available. .
  • sp_exec_table, a handy stored procedure that lets you execute SQL based on the contents of a column in a table.
  • sp_license, a stored procedure showing exactly which licensable options you're running.
  • sp_recreate, a stored procedure to drop and recreate triggers in a single command, without re-entering the SQL source code.
  • SQL-to-XML tool for ASE - a simple tool to present data in an ASE table or view as XML; includes a downloadable stored procedure.

Miscellaneous Topics
  • Query Filter - a Unix tool to find "Queries from Hell" before they hang up your server (for ASE 11.0.3; it hasn't been updated for later versions; it may still be inspiring, though...)

About this site

This web site is maintained by Rob Verschoor, a free-lance Sybase ASE consultant (check out my CV/Resume and my certifications) who also wrote most of the documentation and software on this site. Sypron B.V. (short for "Solving Your Problems Now") is Rob's company -- hence the name; check out some customers.

In 2001, Rob received the International Sybase User Group (ISUG) Outstanding Achievement Award -- details & picture are here.

Contact Rob Verschoor at If you're a recruiter, please read this first.

Our privacy policy is at

Support this site!

All information on this web site is freely available to the Sybase community. It is still possible to keep this web site free of ad banners and popups (except a few about this site itself), although the ever-increasing volume of traffic (or rather, the associated costs) may require that to change at some point.
If you find this web site useful, and you'd like it to continue and remain ad-free, you can support this web site in two ways:
  • Link to from your web site, and recommend it to others.
Many thanks in advance for your support!

 This document is located at