Interested to Buy Any Domain ? << Click Here >> for more details...
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
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
State some of the criticism about sybase iq?
Does table partitioning require user-defined segments in sybase?
How can set the multipal database ?
How can you change to get the decimal separator as comma instead of the decimal point (.)?
What is cis and how can I use it?
When are stored procedures compiled in sybase?
How do I configure identities in sybase?
What is sybase used for?
What is the use of 'with check' option in views?
Are you doing the updates from within a cursor?
What is coalesce in sybase?
How to compute database fragmentation in sybase?
What do you mean by exception log in replication?
Differentiate between db-lib and ct-lib?
What causes re-resolution of a stored procedure in sybase?
