The table provides an overview of the implementation of Sybase and Microsoft system databases.
Database item |
Sybase Adaptive Server Enterprise (SQL Server 10+) | Microsoft SQL Server 7.0 |
Comments |
|---|---|---|---|
| Stored Procedures | Stored in the sybsystemprocs database. | Stored in the master database. | Change references from sybsystemprocs to master. |
| Memory Management | Beginning with System 11, user-defined data caches allow each user to create an area of data cache that can be reserved for specific objects. | Dynamic memory management techniques eliminate the need for administrative configuration of memory. | |
| Information about the oldest open transaction | The syslogshold table records the oldest open transaction. | The DBCC OPENTRAN statement records the oldest open transaction. | Replace all references to syslogshold with DBCC OPENTRAN logic. |
For an explanation of the Microsoft SQL Server system database structure, see “System Databases and Data” later in this chapter.