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
A common-sense approach to Big Data
12 years ago
No comments:
Post a Comment