For SQL Server 6.5 information, see MSsubscriber_info Table in What's New for SQL Server 6.5.
Distribution database table. Contains information used by SQL Executive for passing jobs.
| Column | Datatype | Description |
|---|---|---|
| publisher | varchar(30) | The name of the publisher. |
| subscriber | varchar(30) | The name of the subscriber. |
| type | tinyint | The subscriber type. 0 indicates SQL Server 6.0 subscriber. 1 indicates an ODBC data source. |
| login | varchar(30) | Allows NULL. |
| password | varchar(30) | Allows NULL. |
| commit_batch_size | int | The number of transactions executed on the subscriber before a commit is issued. |
| status_batch_size | int | The number of transactions before the status state is updated. |
| flush_frequency | int | The minimum time, in hours, that transactions will be retained within the distribution database after they have been distributed. |
| frequency_type | int | The primary frequency of this task. One time, On demand, Daily, and so on. |
| frequency_interval | int | The interval of frequency_type. |
| frequency_relative_interval | int | The relative interval for day of the month when the freqtype is monthly (32). |
| frequency_recurrence_factor | int | The recurrence factor based on the frequency_type. |
| frequency_subday | int | The reschedule occurrence based on frequency_interval. Once, every second, every minute, every hour. |
| frequency_subday_interval | int | The amount of time per frequency_subday when it is a unit of time. |
| active_start_time_of_day | int | The time of day when this task is active. |
| active_end_time_of_day | int | The time of day this task is no longer active. |
| active_start_date | int | The date and time after which this task may be scheduled. |
| active_end_date | int | The date and time after which this task may no longer be scheduled. |
| retryattempts | int | The number of retry attempts when a task execution fails. |
| retrydelay | int | The delay, in minutes, between retry attempts. |
ucMSsubscriber_info clustered, unique on publisher, subscriber