Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. salmontraining

    Maximum length of varchar in sybase 12.5

    The maximum length of a Varchar depends on the version of Sybase you are using. 11.9 and below was 255. Version 12.5 and onwards has maxium length of about 32KB - much bigger :-} Whether it's "better" to store as a text type depends on what you want to do with it. Sybase increased the maximum...
  2. salmontraining

    Sybase, Windows 2003 server issue

    What version of Sybase ASE are you using? I had a problem that sounds similar that was due to corruption in the procedure cache (memory area that holds procedures) - it started happening when I upgrated to 2003 and version 15. Once I rebooted the ASE it cleared up - but I had to reboot a few...
  3. salmontraining

    SYBASE environment variable must be set error

    Sounds like you haven't sourced the SYBASE.sh file, which contains all the Sybase environment variables. You can check quickly with: env | grep SYBASE If you're not getting a load of output, source the file with something like this (depends where you've installed sybase to) ...
  4. salmontraining

    newbie logsegment question

    The standard way to monitor the transaction log is to put a "free-space threshold" on it. Basically, you tell Adaptive Server to do something when the log gets X percent full. You can get ASE to call a stored procedure that YOU write - this proc can dump the transaction log, or write to an error...

Part and Inventory Search

Back
Top