patternModerate

sp_dboption is not available in SQL Server 2012

Submitted by: @import:stackexchange-dba·Mar 10, 2026·

Viewed 0 times

sp_dboptionavailable2012sqlservernot

Problem

The system stored procedure sp_dboption is not available in SQL Server 2012 anymore. How could it be replaced?

Solution

sp_dboption was deprecated a while ago - http://msdn.microsoft.com/en-us/library/ms187310(v=sql.105).aspx

The recommended alternative is ALTER DATABASE - http://msdn.microsoft.com/en-us/library/ms174269.aspx

Context

StackExchange Database Administrators Q#27879, answer score: 16

Revisions (0)

No revisions yet.