top of page
Search
Where did my [sys].[sp_dboption] go?
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. If you don’t find [sys].[sp_dboption], just grab it off a SQL 2008 Ser

sqldba
Jan 14, 20134 min read
bottom of page

