Skip to main content

Posts

Showing posts from May, 2015

Northwind Sample DB Script is not work on SQL 2014

Comment out the line #24-25 in file  "SQL Server 2000 Sample Databases\instnwnd.sql" sp_dboption removed after SQL 2012 -- exec sp_dboption 'Northwind','trunc. log on chkpt.','true' => ALTER DATABASE Northwind SET RECOVERY SIMPLE -- exec sp_dboption 'Northwind','select into/bulkcopy','true' => ALTER DATABASE Northwind SET RECOVERY BULK_LOGGED Referenece: https://gist.github.com/idevacc/4527115