Answer Posted / prabhu

When you install Adaptive Server, it contains these system
databases:

The master database controls the user databases and the
operation of Adaptive Server as a whole. It stores
information about all user databases and their associated
database devices.

The model database is used by Adaptive Server as a template
for creating new user databases.
A new database cannot be smaller than the model
database.

? The sybsystemprocs database contains the system stored
procedures.

The sybsystemdb database contains information about
distributed transactions.

? The temporary database, tempdb, stores temporary objects,
including temporary tables created with the name
prefix ?tempdb..?.

? The sybsecurity database, contains the audit system for
Adaptive Server. It consists of:

The system tables, sysaudits_01, sysaudits_02, ...
sysaudits_08, which contain the audit trail
The sysauditoptions table, which contains rows describing
the global audit options.
All other default system tables that are derived from model

How do I connect to sybase?

827

---

How to check if sybase database is up and running?

774

---

What are table partitions? How is it different with ase 15.0 version?

815

---

How do you check database space? What measures are there to increase the db space?

890

---

How do I make isql secure in sybase?

812

---

How would you configure identities in sybase?

935

---

What do you mean by sybase iq?

846

---

Why am I running out of locks on the replicate side in sybase ?

929

---

Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

791

---

Is sybase owned by sap?

843

---

What is open client in sybase?

805

---

How can I improve throughput in sybase?

847

---

There is no space in file system and you need to take a back up. What will you do?

782

---

How to connect to sybase database from linux?

903

---

what is update statistics in sybase?

1101

---