Database Options (Level 1)
Administrative scripts may have used these database options. In SQL Server 2000, database options should be set with the ALTER DATABASE statement rather than the sp_dboption stored procedure. For more information about database options, see Setting Database Options and ALTER DATABASE.
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| The subscribe option of sp_dboption enabled or disabled a database for subscriptions. | Removed; no longer available. Use sp_addsubscription to enable or disable a database for subscriptions. |
| The no chkpt. on recovery option of sp_dboption defined whether or not a checkpoint record was added to a database recovered during a SQL Server startup. | Removed; no longer available. When using a warm standby server, use the WITH STANDBY clause of the RESTORE statement. |