Well in SQL Server 2012, to be quite blunt, [sys].[sp_dboption] has been deprecated, dumped, canned or if you prefer, sent to Zim. Now isn’t that just dandy..because you will only realise this only when it is too late. But on the other hand Darren, you can always do a quick fix, all you need is an earlier flavour of SQL Server and some creative thinking. Open SSMS and explore your database in question.
USE[master] GO /****** Object: StoredProcedure [sys].[sp_dboption] Script Date: 2013-01-14 10:49:58 AM ******/ SETANSI_NULLSON GO SETQUOTED_IDENTIFIERON GO /*ALTER procedure [sys].[sp_dboption] -- 1999/08/09 18:25*/ CREATEproc