Some of the system tables in Microsoft® SQL Server™ version 7.0 were present in version 6.5. Some of these tables have changed. This section lists the columns that have been dropped or have been assigned different data types. Columns that have been added for the current version are not shown.
The SQL Server system tables are described in detail in System Tables. This list of column changes is provided for informational purposes only. Applications should not be written to query the system tables directly.
Note The lengths for nchar and nvarchar columns are expressed in characters. sysname is defined as varchar(30) in SQL Server 6.5 and as nvarchar(128) in SQL Server 7.0.
These columns have been dropped:
| commit_batch_size | frequency_relative_interval | active_start_date |
| status_batch_size | frequency_recurrence_factor | active_end_date |
| flush_frequency | frequency_subday | retryattempts |
| frequency_type | frequency_subday_interval | retrydelay |
| frequency_interval | active_start_time_of_day |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| publisher | varchar(30) | sysname |
| subscriber | varchar(30) | sysname |
These columns have been dropped:
| task_id | has_email_notification | has_pager_notification |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| name | varchar(60) | sysname |
| event_source | varchar(100) | sysname |
| event_id | varchar(20) | int |
| notification_message | varchar(255) | nvarchar(512) |
| database_name | varchar(30) | sysname |
| event_description | varchar(100) | nvarchar(100) |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| creation_script | varchar(127) | nvarchar(255) |
| del_cmd | varchar(255) | nvarchar(255) |
| description | varchar(255) | nvarchar(255) |
| filter_clause | text | ntext |
| ins_cmd | varchar(255) | nvarchar(255) |
| name | varchar(30) | sysname |
| upd_cmd | varchar(255) | nvarchar(255) |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| name | varchar(30) | sysname |
| description | varchar(255) | nvarchar(255) |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| name | varchar(30) | sysname |
| colid | tinyint | smallint |
| prec | tinyint | smalint |
| scale | tinyint | int |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| colid | tinyint | smallint |
| text | varchar(255) | nvarchar(4000) |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| comment | varchar(255) | nvarchar(255) |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| colid | tinyint | smallint |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| comment | varchar(255) | nvarchar(255) |
These columns have been dropped:
| logptr | dumptrdate |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| name | varchar(30) | sysname |
| status | smallint | int |
These columns have been dropped:
| mirrorname | stripeset |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| name | varchar(30) | sysname |
These columns have been dropped:
| distribution | segment | rowpage |
| keys1 | keys2 |
These columns have different data types:
| Column name | Previous data type | Current data type |
|---|---|---|
| first | int | binary(6) |
| root | int | binary(6) |
| name | varchar(30) | sysname |
| maxlen | int | smallint |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| name | varchar(30) | sysname |
| alias | varchar(30) | sysname |
| months | varchar(251) | nvarchar(372) |
| shortmonths | varchar(119) | varchar(132) |
| days | varchar(216) | nvarchar(217) |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| name | varchar(30) | nvarchar(128) |
| dbname | varchar(30) | nvarchar(128) |
| password | varchar(30) | nvarchar(128) |
| language | varchar(30) | nvarchar(128) |
This column has been dropped: langid
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| description | varchar(255) | nvarchar(255) |
This column has been dropped: schema
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| name | varchar(50) | sysname |
| email_address | varchar(100) | nvarchar(100) |
| pager_address | varchar(100) | nvarchar(100) |
This column has been dropped: gid
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| status | char(10) | nchar(128) |
| hostname | char(16) | nchar(128) |
| hostprocess | char(8) | nchar(8) |
| cmd | char(16) | nchar(16) |
This column has been dropped: restricted
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| description | varchar(255) | nvarchar(255) |
| name | varchar(30) | sysname |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| remoteusername | varchar(30) | nvarchar(128) |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| srvname | varchar(30) | sysname |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| dest_db | varchar(30) | sysname |
These columns have different data types.
| Column name | Previous data type | Current data type |
|---|---|---|
| name | varchar(30) | sysname |
| length | tinyint | smallint |
| prec | tinyint | smallint |