I just learn from Nakul''''s Blog That spdboption store procedure is “discontinued” SQl Server 2012
Replacement is the ALTER DATABASE statement, for existing sp_dboption
ALTER DATABASE TestDB SET READ_ONLY
Thank You
Published under: SQL Server Tips · · · ·
Thank-you very much, Kirti for sharing! Also, I am glad you found my post to be useful. Do keep sharing your feedback!