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
Sybase configuration Parameters sp_configure ' max online engines ', 4
Go
--Configure the number of boot CPUs
sp_configure ' number of engines at startup ', 4
Go
--Configure Maximum memory count
sp_configure ' max memory ', 2097151
Go
--Allocating
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 $
Q: How does SQL server access the table of the sybase database?
A: The specific method is as follows:
1: Install the Sybase Client
Version requirements:
Sybase client 11.9.2 for NT
1.1: After the installation is complete, start
There is a lot of information about the usage of BCP on the Internet, but it can only be used after it has been confirmed by its own practice. Some of the online stuff is transferred in and out, and there will be some mistakes, therefore, the
Q: How should SQL Server access the tables of the Sybase database?
Answer: The specific method is as follows:
1: Install Sybase client
Requirements for version:
Sybase Client 11.9.2 for NT
1.1: After the installation completes, runs starts->
One install Sybase client
Version: Sybase Client 11.9.2 for NT
1 after the installation completes, the operation starts-> program->sybase->dsedit
2 Select Menu ' Server Object ',-> ' Add ' to enter service name like 1.70
3 then select ' 1.70 ' in
One install Sybase client
Version: Sybase Client 11.9.2 for NT
1 after the installation completes, the operation starts-> program->sybase->dsedit
2 Select Menu ' Server Object ',-> ' Add ' to enter service name like 1.70
3 then select ' 1.70 '
sp_configure ' max online engines ', 4Go--Configure the number of boot CPUssp_configure ' number of engines at startup ', 4Go--Configure Maximum memory countsp_configure ' max memory ', 2097151Go--Allocating maximum stored procedure
I have already compiled two documents about oracle transparent gateway connecting mysql database and sqlserver database. I thought it would not connect to other databases through transparent gateway.
I have already compiled two documents about
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.