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
Is sybase owned by sap?
How to start and stop sybase database in linux sap?
How do I take advantage of table partitioning with bcp in sybase?
Which should I use, repagent or ltm in sybase?
Are there any alternatives to isql in sybase?
You need to multiply all values of a single column. How would you do that?
What measures are there to increase the db space?
Can I run any transact-sql command on a partitioned table in sybase?
How to take backup in sybase database in sap?
What is difference between sybase and oracle?
How do I find the oldest open transaction in sybase?
What is ceiling()?
Explain bind cache?
What is sybase used for?
How would you configure identities in sybase?
