4. Improve the article
If you forget the password for the SA, how to recover it.1, first stop Sybase ASE service.2, under the Sybase Security directory%%\sybase\ase-12_5\install\, modify the Run_sybase database server startup script, add-psa Save
1. Sybase ASE transaction log
Each database of Sybase ASE, whether it is a system database (master, model, sybsystemprocs, tempdb) or a user database, has its own transaction log, and each database has a syslogs table. Logs record user operations on
After you download ase15.0.2 from the Sybase official website, if you select to install express edition or Developer Edition, you will not encounter any problems, except for some limited functions.
However, most of them may be Enterprise Edition for
Configure Turbo Linux + ASE 12.5 database serverFirst, Turbo Linux installation process:Insert Turbo Linux installation into the optical drive, CMOS settings for the CD drive boot, start the computer, type carriage return, enter the default graphics
Sybase Database BCP description
BCP is a tool provided by Sybase for database table-level data backup.
It is generally stored in the bin directory of the installed ASE or open client.
For ASE earlier than version 12, the BCP storage directory is $
Working in a software environment that allows you to quickly create robust, flexible applications is the dream of every developer. SAIC, which runs the IT operations of BP Exploration, believes it has turned this dream into reality by combining
---------------------------------------------------------------------------
---- This is andkylee's personal originality. Please repost it with respect to the author's Labor achievements;
---- The original source must be specified for
The solution is as follows:
The validity of the login is validated by using the stored procedure Sp_modifylogin provided by the characteristics of Sybase ASE.
First create a new user with high enough permissions to recover the SA in the future
BCP is generally stored in the BIN directory of the installed ASE or Open Client. For ASE earlier than version 12, the bcp directory is $ SYBASE/bin, and for Versions later than Version 12 (including version 12), the directory is $
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.