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
What is the difference in storage type of numeric and decimal data types in sybase ?
Explain procedure cache?
What you need to do is issue an ase kill command on the connection then un-suspend the db?
Is sybase sql?
What is the command for quitting from sybase?
Can I run any transact-sql command on a partitioned table in sybase?
How does sybase replication work?
How to implement if-then-else in a select clause in sybase?
What is sybase replication server?
What mandatory options are required for bcp command utility?
What is a good example of a transaction in sybase?
What is sybase used for?
A single operation is failing to escalate?
You need to add a notnull column in a table by using alter command (without using default command). How would you do that?
Is sybase free?
