Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Database Options (Level 1)

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.

Show:
© 2015 Microsoft