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

Can I use a named pipe to bcp/dump data out or in in sybase?

1000

---

How do I force an index to be used in sybase?

833

---

How to take backup in sybase database in sap?

883

---

You need to manipulate varbinary columns in sybase. How would you do that?

942

---

Can you create your own sps for system wise?

907

---

What do you mean by adaptive server enterprise?

945

---

Which version of open client works with which ase in sybase?

911

---

Explanation about replication server software?

933

---

What will cause the size of a stored procedure to grow in sybase?

816

---

For synchronizing the logins from lower version to higher version, just take the 11.9.2 syslogins structure, go to 12.5 higher version server?

821

---

How would you improve throughput in sybase?

962

---

How do I run multiple versions of sybase on the same server?

868

---

How to start sybase database in windows?

1137

---

Can two tasks be assigned to the same partition in sybase?

815

---

What is sybase? What are its important features?

1009

---