Wednesday, May 1, 2013

SQL Server 2012 -- sp_dboption stored procedure no longer exists

This is a problem as the 2008 style scripts for Northwind and Pubs databases include sp_dboption.
Its not the end of the world, you can  comment them out and use ALTER DATBASE instead.

--exec sp_dboption 'Northwind','trunc. log on chkpt.','true'
ALTER DATABASE Northwind SET RECOVERY SIMPLE 

Seems like a comprehensive reference here:

http://beyondrelational.com/modules/2/blogs/28/Posts/15429/replacement-for-system-stored-procedure-spdboption-in-sql-server-2012-denali.aspx

No comments: